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 SkipVought 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 Bernie...mind explaining 'bout hard coding the dates?...in my database for ArticleDate table, the record states 10-JUL-03.Hence, that's why I have AD = strDay & "-" & strMonth & "-" & strYear to replace into ARTICLEDATE.ART_DATE='"&AD&"' which gives me...- bingbing
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Blank page (no results) from my SQL query
Dear LV and anyone whose reading this, So far LV's suggestions have been really helpful in debugging my code. However, I feel that it's appropriate to explain the logic of my code and what I actually intend to do with my SQL statement. I have the following tables in my database...- bingbing
- Post #4
- Forum: Microsoft: ASP (Active Server Pages)
-
Grabbing external variables into SQL statement (create view)
Dear LV and anyone whose reading this, So far LV's suggestions have been really helpful in debugging my code. However, I feel that it's appropriate to explain the logic of my code and what I actually intend to do with my SQL statement. I have the following tables in my database...- bingbing
- Post #11
- Forum: Microsoft: ASP (Active Server Pages)
-
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 again...okay so I rebooted my comp and ran the code again and this time there's no error except that I get a blank page after I ran the ASP file. I figured it could be my SQL part and following LV's previous suggestion on concatenation string...I've made the following changes... <HTML>...- bingbing
- Post #9
- Forum: Microsoft: ASP (Active Server Pages)
-
Grabbing external variables into SQL statement (create view)
Hi again...based on your suggestion in the previous thread, I've tried using a variable to replace my entire SQL statement as a string. It works but currently I'm facing a problem with OraOLEDB (Oracle's Provider) since I'm using Oracle 9i for the database. My code looks like this now: <HTML>...- bingbing
- Post #8
- Forum: Microsoft: ASP (Active Server Pages)
-
Grabbing external variables into SQL statement (create view)
This is my latest revision of my code...ignore previous posts... Set recordSetLINK=Server.CreateObject("ADODB.recordSet") recordSetLINK.Open "Select LINK, PUBLICATIONS.PUB_ID, CATEGORY.CAT_ID, ARTICLEDATE.DATE_ID, KEYWORD.KEYWORD_ID from LINK, PUBLICATIONS, CATEGORY, ARTICLEDATE...- bingbing
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Grabbing external variables into SQL statement (create view)
Hi, To LV, I am really glad that your idea really helped me a lot. I've abandoned the idea of creating views and using Select statements all the way. I still have a small problem though...the following is my code: Set recordSetLING=Server.CreateObject("ADODB.recordSet") Set...- bingbing
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Grabbing external variables into SQL statement (create view)
Thanks for the info. Now i've managed to avoid the problem of KW being an invalid identifier. However, referring to my code above, 'To check whether KW contains the correct value from combobox <br>You have chosen <br>Keyword: <%=KW%> This correctly shows me the value of KW that the user has...- bingbing
- Post #3
- 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 - - - -...
