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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How read a database value into vbscript variable?
- Thread starter seidel
- Start date
Using ASP: (I'm sure this can be also done with PHP)
<% 'Fragmented code below. If you don't know ASP/ Learn it!
dim yourValue
'Database query
SQL="Select ID,Fname from SomeTable"
'create recordset
set objRec=server.createobject("ADODB.recordset"
'set recordset
objRec.open objConn.execute(<your SQL code>)
'set ASP variable
yourValue=objRec("ID"
%>
<HTML>
<HEAD>
<Script language=vbscript>
dim yourVariable
'this is how you would assign the database field
'to your vbscript variable
yourVariable=<%=yourValue%>
</Script>
</Head>
<BODY>
</BODY>
</HTML>
"did you just say Minkey?, yes that's what I said."
MrGreed
<% 'Fragmented code below. If you don't know ASP/ Learn it!
dim yourValue
'Database query
SQL="Select ID,Fname from SomeTable"
'create recordset
set objRec=server.createobject("ADODB.recordset"
'set recordset
objRec.open objConn.execute(<your SQL code>)
'set ASP variable
yourValue=objRec("ID"
%>
<HTML>
<HEAD>
<Script language=vbscript>
dim yourVariable
'this is how you would assign the database field
'to your vbscript variable
yourVariable=<%=yourValue%>
</Script>
</Head>
<BODY>
</BODY>
</HTML>
"did you just say Minkey?, yes that's what I said."
MrGreed
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
