I could not get the bind variable solution to work. Did you leave out some syntax? That is the one I would like to use. I did however get the substituting variable solution to work. Thanks.
It barked at the "var" in the:
var cp_id number
exec :cp_id := 95967
Here is what I have...
OK, I am not a Oracle guy, I know Microsoft, but I am writing a script for an Oracle 8 DB. I want to declare variables, set those variables and then use them in a WHERE clause of a SELECT statement. Here is how I would do it for SQL Server 2K:
DELCARE @myvariable varchar(10)
SELECT *
FROM...
I tried that and it passed through and saved but it is now passed as "ch(38)" literally. Now the email address is saved as firstch(38)last@mail.com. I need it to be saved from the querystring as first&last@mail.com. This is a start. I will see if I can do some kind of search...
I am trying to pass email addresses via a querysting. The problem is if I have an email address that has a "&" it does work right. I have tried all these before it is put into the querystring:
frm.txtEmail.value =...
I am trying to pass an email address using a query string. It works most of the time. The times it doesn't is when the email address has certain characters in it. For example:
john&doe@email.com
or
john#doe@email.com
I works for stuff like:
john$doe@email.com
A. Which symbols are used...
I need to pull all unique values from a grid column and put them in an array. I am wondering how to search the values in an array to check if a value in the column is already there or if it needs to add it to the array. How do I do this in VBScript? I have looked everywhere. Please throw...
Howdy,
I am trying to delete a field from a recordset that happens to be XML (the field not the recordeset). I have tried the set value to null and any nonXML value. The reason I think I need to delete the XML field is because I need to convert the entire recordset to XML and pass it along...
I am trying to populate a VBscript drop down box with an array of string values. This would not be a one time thing. Every time the page is accessed a new array would be created thus making the options in the drop down box different. Any help would be appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.