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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Blank page (no results) from my SQL query
Hi all, I've got a problem with the following ASP code. I'm writing a search page (interface) using VBScript to connect to an Oracle 9i database. The problem is that I get a blank page (no results) from my SQL query. Using Response.Write strSQL, I copied the string of SQL statement displayed...- bingbing
- Thread
- Replies: 6
- Forum: Microsoft: ASP (Active Server Pages)
-
Grabbing external variables into SQL statement (create view)
Hi, I'm having a problem with inputting values of external variables into an SQL statement which functions to create a view. FYI, I'm using Oracle 9i Database Enterprise Edition. The following is my code: <% Dim recordSetLING Dim connectionToDatabase Dim KW 'In my webpage, I have a combobox...- bingbing
- Thread
- Replies: 12
- Forum: Microsoft: ASP (Active Server Pages)
-
SQL concatenation issue for Oracle 9i
Hi, I'm currently using Oracle 9i for a class database project. I'm kinda stuck at the following problem...I have a view called LING shown below: A B C D - - - - 2 4 1 1 The problem is I'm trying to create a view (Oracle's view) called TEMP that will look like this: A B C D E - - - -...
