Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. anthonycervantes

    Using Variables in WHERE clauses

    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...
  2. anthonycervantes

    Using Variables in WHERE clauses

    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...
  3. anthonycervantes

    "&" in querystrings?

    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...
  4. anthonycervantes

    "&" in querystrings?

    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 =...
  5. anthonycervantes

    Query String syntax help please.

    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...
  6. anthonycervantes

    Searching/Comparing array values

    Thanks for the suggestion. AC
  7. anthonycervantes

    Searching/Comparing array values

    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...
  8. anthonycervantes

    Deleting fields from a recordset

    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...
  9. anthonycervantes

    Populating VBscript drop down w/ array

    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.

Part and Inventory Search

Back
Top