Gossamer Forum
Home : General : Internet Technologies :

Help on coding

Quote Reply
Help on coding
anyone can help? my this code not working

Code:
<html><body>
<%
'Declare variables'
Dim objConnection
Dim objRecordset 'Create objects'
Set objConnection = Server.CreateObject('ADODB.Connection')
Set objRecordset = Server.CreateObject('ADODB.Recordset') 'Open connection and run query'
objConnection.open "database"
objRecordset.Open 'SELECT * FROM STUDENTS', objConnection While Not ObjRecordset.EOF
Response.Write( objRecordset ('Adm_No') & ' ')
Response.Write( objRecordset ('Name') & '<br>' )
Response.Write( objRecordset ('HomeTel') & '<br>' )
Response.Write( objRecordset ('Course_Code') & '<br>' )
Response.Write( objRecordset ('Race') & '<br>' )
Response.Write( objRecordset ('Sex') & '<br>' )
objRecordset.MoveNext
Wend
%>
</body>
</html>
Quote Reply
Re: [gnehs] Help on coding In reply to
Whats the language? C++ , Java? Doesn't look like PHP or Perl. This would be better in the Internet Technologies forum. I'll move it in a second.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [gnehs] Help on coding In reply to
That looks like vbscript to me.. What's not working? What's the error?

Cheers,

Alex
--
Gossamer Threads Inc.