Click here to Skip to main content
15,892,746 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Want to build content-based websites Pin
Roger Wright30-Nov-04 19:36
professionalRoger Wright30-Nov-04 19:36 
GeneralRe: Want to build content-based websites Pin
raouls30-Nov-04 3:32
raouls30-Nov-04 3:32 
GeneralRe: Want to build content-based websites Pin
raouls8-Dec-04 3:31
raouls8-Dec-04 3:31 
GeneralRichTextBox control and ASP Pin
maibuihuynhtg29-Nov-04 21:01
maibuihuynhtg29-Nov-04 21:01 
GeneralRe: RichTextBox control and ASP Pin
Sven Cipido29-Nov-04 23:52
Sven Cipido29-Nov-04 23:52 
GeneralU can help Pin
davilism29-Nov-04 19:22
davilism29-Nov-04 19:22 
GeneralRe: U can help Pin
aplope1-Dec-04 7:06
aplope1-Dec-04 7:06 
Generalquerying database with cookie values Pin
SkinnyLou29-Nov-04 11:30
SkinnyLou29-Nov-04 11:30 
I'm wondering if anyone has come across this before. I'm trying to get values out of a database using values set in a cookie.

I'm sure that cookies can be processed with VBscript, but not being familiar with that, I get the values using Javascript, set a text box with the values I need, then build an SQL string.

However, for some reason, anything within a VBScript script tag, is not visible when you exit the script and use the <% %> tags. For example, once the text box is set, I use the following:


dim SQL
tempArray=Split(Document.form1.Elements(0).value,",")
SQL="Select * from tblSubPart where PartID IN ("
for each part in tempArray
SQL=SQL & "'" & trim(part) & "',"
next
SQL=SQL & ")"



<%
Set objDC = Server.CreateObject("ADODB.Connection")
objDC.Open "data"

Set objRS = objDC.Execute(SQL)
%>

for some reason, I cannot use the code to open the recordset within the tags, but without the tags, it will not recognize my reference to the form item. As the code sits, it does not see the variable "SQL" when it tries to open the recordset.

Does anyone know what I am overlooking?
GeneralWeb Service responce size Pin
Colin Mc29-Nov-04 3:36
Colin Mc29-Nov-04 3:36 
Generaljavascript typing effect Pin
rgoyal29-Nov-04 0:43
rgoyal29-Nov-04 0:43 
GeneralRe: javascript typing effect Pin
Sven Cipido30-Nov-04 0:11
Sven Cipido30-Nov-04 0:11 
GeneralRe: javascript typing effect Pin
rgoyal30-Nov-04 1:04
rgoyal30-Nov-04 1:04 
Generalftware trainee.how to start reading asp.net Pin
Member 154350728-Nov-04 23:04
Member 154350728-Nov-04 23:04 
Generalftp+php Pin
rgoyal28-Nov-04 21:30
rgoyal28-Nov-04 21:30 
GeneralRe: ftp+php Pin
raouls29-Nov-04 19:14
raouls29-Nov-04 19:14 
GeneralRe: ftp+php Pin
rgoyal30-Nov-04 1:09
rgoyal30-Nov-04 1:09 
GeneralRe: ftp+php Pin
raouls30-Nov-04 3:28
raouls30-Nov-04 3:28 
GeneralRe: ftp+php Pin
rgoyal6-Dec-04 23:05
rgoyal6-Dec-04 23:05 
GeneralRe: ftp+php Pin
raouls7-Dec-04 10:44
raouls7-Dec-04 10:44 
Generalabout layer of div Pin
zhanglei28-Nov-04 21:22
zhanglei28-Nov-04 21:22 
GeneralRe: about layer of div Pin
DavidNohejl30-Nov-04 22:22
DavidNohejl30-Nov-04 22:22 
QuestionWhat is the difference between the two? Pin
rgoyal28-Nov-04 18:02
rgoyal28-Nov-04 18:02 
AnswerRe: What is the difference between the two? Pin
JKroschel2-Dec-04 11:08
JKroschel2-Dec-04 11:08 
GeneralRe: What is the difference between the two? Pin
rgoyal2-Dec-04 18:09
rgoyal2-Dec-04 18:09 
GeneralForcing Page To Stay In ASP Pin
Bassam Abdul-Baki26-Nov-04 16:08
professionalBassam Abdul-Baki26-Nov-04 16:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.