Click here to Skip to main content
15,895,871 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: .net or php Pin
raouls13-Mar-05 19:53
raouls13-Mar-05 19:53 
GeneralRe: .net or php Pin
DavidNohejl14-Mar-05 6:23
DavidNohejl14-Mar-05 6:23 
GeneralRe: .net or php Pin
raouls15-Mar-05 1:22
raouls15-Mar-05 1:22 
GeneralRe: .net or php Pin
DavidNohejl15-Mar-05 3:09
DavidNohejl15-Mar-05 3:09 
GeneralRe: .net or php Pin
alex.barylski16-Mar-05 12:53
alex.barylski16-Mar-05 12:53 
GeneralRe: .net or php Pin
DavidNohejl18-Mar-05 1:09
DavidNohejl18-Mar-05 1:09 
GeneralRe: .net or php Pin
JKroschel21-Mar-05 6:49
JKroschel21-Mar-05 6:49 
Generaldatabase connection Pin
mpapeo13-Mar-05 13:13
mpapeo13-Mar-05 13:13 
Pliz help me with the hi-lighted string sql. It shows that there is an error by underlining. But i can't see any problems...

<br />
<body><br />
<%<br />
'Dimension variables<br />
Dim adoCon 			'Holds the Database Connection Object<br />
Dim rsProjectdb			'Holds the recordset for the record to be updated<br />
Dim strSQL			'Holds the SQL query for the database<br />
Dim lngRecordNo			'Holds the record number to be updated<br />
Dim rs<br />
<br />
'Read in the record number to be updated<br />
lngRecordNo = CLng(Request.QueryString("password"))<br />
<br />
'Create an ADO connection odject<br />
Set adoCon = Server.CreateObject("ADODB.Connection")<br />
<br />
'Set an active connection to the Connection object using a DSN-less connection<br />
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Projectdb.mdb")<br />
<br />
'Create an ADO recordset object<br />
Set rsProjectdb = Server.CreateObject("ADODB.Recordset")<br />
<br />
'Initialise the strSQL variable with an SQL statement to query the database<br />
<br />
strSQL = "SELECT Table1.studentid, Table1.password FROM Table1 WHERE studentid= &studentid& "AND"  password = &password& " <br />
<br />
'Open the recordset with the SQL query <br />
rsProjectdb.Open strSQL, adoCon<br />
<br />
' Execute the SQL query string <br />
Set rs = adoCon.Execute(strSQL)    <br />
<br />
'Show the contents of the table   <br />
While Not rs.EOF   <br />
Response.Redirect (http://www.mmegi.bw)   <br />
rs.MoveNext   <br />
else Response.Redirect(http://www.ub.bw)<br />
Wend     <br />
<br />
'close the connection   <br />
rs.Close : adoCon.Close <br />
set rs = Nothing : set adoCon = Nothing  <br />
%><br />
</body><br />
</html><br />

Any help appreciated

oam
GeneralRe: database connection Pin
DavidNohejl13-Mar-05 14:02
DavidNohejl13-Mar-05 14:02 
General.DLL Path for IIS 6.0 Pin
gmhanna13-Mar-05 7:21
gmhanna13-Mar-05 7:21 
GeneralOutput Directory Pin
gmhanna12-Mar-05 18:31
gmhanna12-Mar-05 18:31 
Generalpeer to peer application on pocket pc Pin
manasrahfantom12-Mar-05 3:40
manasrahfantom12-Mar-05 3:40 
Generalupload indicator Pin
asif m@hmood11-Mar-05 23:35
asif m@hmood11-Mar-05 23:35 
GeneralRe: upload indicator Pin
raouls13-Mar-05 20:15
raouls13-Mar-05 20:15 
GeneralRe: upload indicator Pin
asif m@hmood13-Mar-05 21:58
asif m@hmood13-Mar-05 21:58 
Generaljs example XPPanelbar not working Pin
david()()()()11-Mar-05 10:24
david()()()()11-Mar-05 10:24 
GeneralRe: js example XPPanelbar not working Pin
DavidNohejl11-Mar-05 14:16
DavidNohejl11-Mar-05 14:16 
GeneralRe: js example XPPanelbar not working Pin
david()()()()14-Mar-05 5:49
david()()()()14-Mar-05 5:49 
GeneralRe: js example XPPanelbar not working Pin
DavidNohejl14-Mar-05 6:17
DavidNohejl14-Mar-05 6:17 
Generalconectivity of database Pin
Bhuvanish11-Mar-05 10:04
Bhuvanish11-Mar-05 10:04 
QuestionHow to send different encoded characters from a page? Pin
Anonymous10-Mar-05 23:36
Anonymous10-Mar-05 23:36 
AnswerRe: How to send different encoded characters from a page? Pin
DavidNohejl11-Mar-05 5:06
DavidNohejl11-Mar-05 5:06 
GeneralRe: How to send different encoded characters from a page? Pin
Anonymous11-Mar-05 16:14
Anonymous11-Mar-05 16:14 
GeneralRe: How to send different encoded characters from a page? Pin
DavidNohejl12-Mar-05 0:36
DavidNohejl12-Mar-05 0:36 
Generalupdate a file on net, port 80 Pin
popaserban10-Mar-05 5:37
popaserban10-Mar-05 5:37 

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.