In an Oracle 8.1.7. Database there's a package like this:
PACKAGE CONSTANTS
C1 CONSTANT NUMBER := -1;
END PACKAGE;
How do I reach CONSTANTS.C1 from ASP?
I have tried
SELECT CONSTANTS.C1 FROM DUAL;
but it didn't work even when run in the database console.
Can I use server.execute to get constant values ?
View Replies View Relatedif there is a web package available in either PHP or ASP that will do a classified type site but that has the ability to charge CC and take other forms of payment bundled with it. I know this site has pretty much everything that i would need and it is coded in ASP can anyone tell me if this is a package that is avaible or if it was custom coded.
View Replies View RelatedI currently work for a small design shop and one of our clients is looking for us to re-do their site, possibly with a CMS package so we dont always have to do the maintaining.
we are looking for something in what I think is mid-price range ($1000 - 10,000) that will do the trick.
we would like something that allows for ASP vbscript , and javascript to be integrated. A system that clients will have an easy time working with. we have no CMS experience.
I have a big problem here ....i have an oracle pakage and i need to call this package in ASP , when i use "microsoft odbc for oracle" it work fine .
But now we need to change the odbc to "Oracle in OraHome92" ...so evrything in the package call must be change. any one can help me ?? how can i call this package via this odbc driver and how i can retrun a record set from the package?.
I have been developing an online payment system using classic ASP
which uses Msxml2.ServerXMLHTTP to submit an XML package to a 3rd party payment
system. The website the payment system is part of is one of many on a
Server 2000 / IIS5.0 installation. Each web site on my server has its
own IP address. The 3rd party payment system is hosted on another
server not under my control.
The issue I have is that when the XML package is submitted, the 3rd
party system is not registering the correct IP addresss for the
originating request from the website, it is registering the 'Core' or
first IP address on the server. The originating IP address is part of
their authentication model and so the XML submission is failing
because the wrong IP address is being passed through.
Does anyone know how to return data from an Oracle pakage using Oracle driver?
View Replies View RelatedI have developed an asp application and now I want to package it with licence. I really have no idea how to do this.
View Replies View Relatedi've used in my site a free user management package ,but i wanna change the Background color of that package,to match mine, but i don't know is it an included file contains these formats or coding!i've attached the package.plz check & lead me to where to change the colors?
View Replies View RelatedI am trying to expose a table from a packege in Oracle. I am using a Oledb Connection. I only know how to see the data using a Packege with only inputs parameters. When i use a output parameter it is do nothing..
View Replies View RelatedI'm trying to transfer an intranet app from one server to another. I'm
having a problem with the ADO constants on the destination server.
Our intranet site runs on the server.
In a virtual directory, I have a seperate application that is accessible
from the intranet.
I have the following in the global.asa in the virtual directory:
<!--METADATA TYPE="typelib"
UUID="2A75196C-D9EB-4129-B803-931327F72D5C"
NAME="Microsoft ActiveX Data Objects 2.8 Library"-->
This usually allows me to refer to the ADO constants, e.g.
Set rsLoc = oConn.Execute (sSQL, iAffected, adCmdText)
However, in this case, IIS is complaining... Variable is undefined:
'adCmdText'
This is a new (clean) server, so I'm wondering if there is some kind of
confirguration issue..
I'm relatively new to coding activex and I have a problem. I've written an activex component in c++ and I am now using asp/vb pages to access the object. Is it possible to access constants that I've defined in the activex object? For example, can I do something like the following:
Dim constantValue
Set activeX = CreateObject("MyObject.MyClass.1")
constantValue = activeX.MY_CONSTANT_VALUE
Is it possible that both adUseClient and adLockOptimistic does not really work with ASP ?When I use 3 for both - it does.
View Replies View RelatedI realize that this isn't a VBS newsgroup, but it's the only Microsoft newsgroup I read regularly so I hope that you'll be gentle with me. Where is the constant "vbCrLf" defined? My computer has been searching its hard drive for about three hours, now, looking for a definition and it still hasn't found anything.
The reason I'd like to find vbCrLf is because I wonder what else is in there. Is there a vbTab? vbBackspace?
I've been searching for a complete listing of the CDO constants, but have
come up empty. Where can I find a listing of all the CDO named constants
that can be referenced directly with the CDO metadata typelib, i.e.,
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
I've been trying to create read-only global variables by creating constants (Const) in my global.asa, but I can't seem to reference them. Sticking them in an include works fine, but it seems more structurally sound to use Application_OnStart. Am I attempting the impossible, and if so, why?
View Replies View RelatedI know the basic 8, how do i find any others besides those 8? do you use hex codes? should also note that i need to be able to match the vbcolor to a hex color.
View Replies View RelatedIs it possible to server.execute a file that has a list of constants and then use those constants? I've tried, but the asp tells me the the variable is undeclared when I try to <%=const_name%>
View Replies View RelatedI have the following problem.
I'm building a site with a db backbone.
In an "include file" I set a constant like:
Const partners = 22
and on some other page, I want to pass the word partners using the query string.
Meaning: I want to make such a link:
href="mypage.asp?module=partners"
When my page reads the querystring - I want it to be able to understand the value of the constant "partners".
when I read from the db using the following kind of Query, I get a "no value specified for one of more..." Code:
Getting this error:
The name 'squibble' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
/squibble/incFunc.asp, line 13
when trying the following:
Code: ....
I need to process a string to do some data insertion into a database table.
However, this string contains some constant variables (set in the include file) and it depends on the value of intDataCtr as below : Code:
I've created a web application with Visual Interdev and I've added Microsoft
XML, version 4 in project's references. A META tag has been successfully added
in global.asa:
<!--METADATA TYPE="TypeLib" NAME="Microsoft XML, v4.0"
UUID="{F5078F18-C551-11D3-89B9-0000F81FE221}" VERSION="4.0"-->
But when I write the following code in an ASP server-side javascript:
<p>Value: <% = SOMITEM_ELEMENT %></p>
I get a Microsoft VBScript error '800a01f4'. Undefined variable:
'SOMITEM_ELEMENT'
I don't get such an error with ADO constants (even though I didn't include
ADOJS.inc). Can someone tell me what's wrong?
anyone has any idea what IMS Package is all about? i read that The IMS Package consists of two major elements: a special XML file describing the content organization and resources in a Package, and the physical files being described by the XML.
The special XML file is named as imsmanifest.XML, together with all resources, when import, will be extracted from a single .zip file.
Does any one know where i can get such kind of .zip files so that i can check what exactly happening inside?
How to value in drop down value from mysql database ..
Technical Languages:
Front ENd: XHTML
Validation: JavaScript
Server Scripting: ASP
Server:IIS
Database: MySQL
I have two tables having similiar columns ( i had to do this to compare the values given to me, because both the table data came from different sources)
The tables named are
OFFICERS
token
full_name
division
EMPLOYEE
token
full_name
division
Now the table EMPLOYEE contains more than 5000 records and the table OFFICERS contains around 2400 records which are already present in the EMPLOYEE table.
Now I want to build a query that will return me all the records in the EMPLOYEE table that are not present in the OFFICERS table. The criteria for comparing 'full_name'. so the query should return me 2600 records that are not present in the OFFICERS TABLE.
I tried doing this
" SELECT DISTINCT EMPLOYEE.full_name,EMPLOYEE.token,FROM EMPLOYEE,OFFICERS WHERE EMPLOYEE.full_name<> OFFICERS.full_name"
But this query returns me records that is not present in the OFFICERS table as well as some more 1000 records which are present in both tables.
thanks a lot
I want to have a form where there is a textfield and a Browse... button to the right of it. I want the user to be able to press the Browse... button and select a file and then that filename be returned to the textfield.
I don't want it to upload it or anything like that...I just want to know the filename that the user has selected. Also, when the user presses the Browse... button, I want it to automatically go to a certain place.
I write the code as floowing to check the file nam before submit , but it show nothing when i click submit button. Code:
View Replies View Relatedif i have 08/21/2007 11:07:27 AM in the database..
what should i do to just show it out as 08/21/2007 ?
I am trying to access the following site with an asp page. I am just starting out with XML
URL
This is my stats page for battlefield Vietnam. I have managed to get a local verison to work if I save the source code of the page above as an xml file on my server, and I use the following code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<% Option Explicit %>
<%
Dim xmlDoc, root
Dim success, player, strData, online ,rank, rp, score, kills, deaths, fttk, kdr
Dim dpm, ftpm, mppr, medals, gold, silver, bronze, rounds
Set xmlDoc = server.CreateObject("msxml2.DOMDocument")
'
What I can't figure out is how to access the data from the external site.
This is my code can you fix it if it have an error
<select>
<%
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select cat from events"
rs.ActiveConnection = conn
rs.open strSQL
if not (rs.eof or rs.bof) then
for i = 0 to rs.eof
response.write("<option>" + rs(i) + "</option>")
next
end if
%>
</select>
I know that you can retrieve data from a form using
Request.Form("name"), but how do you retrieve a file?
how can i retrieve information on a form page that once previously submitted by the user so that when the user goes back to that form page it will remember what they inputted instead of having them to retype it again? do i have to use session? can somebody please help me... what would be the easiest and most efficient for a newbie to tackle this problem?
View Replies View Relatedhow to retrieve a data that has been selected using combo box with asp
View Replies View Related