Does any soul out there have any idea why am i getting this error:
............... ............... ............... ............... ............... ............... ........
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (comma) in query expression 'banner_postnr= '5000', banner_gender ='mand''.
............... ............... ............... ............... ............... ............... .......
Here is the the code thanks:
............... ............... ............... ............... ............... ............... .......
<% sub random_record()
dim myconn,id1,myta ble,mytable2,my table3,mysql,sq l1,db_connectio nstring %>
<!-- #INCLUDE FILE="inc.asp" -->
<%
DIM strfirst, strlast, strgender, strage, strzip
strfirst = Request.Cookies ("prefs")("firs t")
strlast = Request.Cookies ("prefs")("last ")
strgender = Request.Cookies ("prefs")("gend er")
strage = Request.Cookies ("prefs")("alde r")
strzip = Request.Cookies ("prefs")("zip" )
Set Myconn = Server.CreateOb ject("ADODB.Con nection")
Myconn.CommandT imeout = 30
Myconn.Connecti onTimeout = 20
Myconn.Open DB_CONNECTIONST RING, DB_USERNAME, DB_PASSWORD
SET MYTABLE= SERVER.CREATEOB JECT("ADODB.REC ORDSET")
SET MYTABLE2= SERVER.CREATEOB JECT("ADODB.REC ORDSET")
SET MYTABLE3= SERVER.CREATEOB JECT("ADODB.REC ORDSET")
duplicateaccno = "true"
set mytable=server. createobject("a dodb.recordset" )
set mytable2=server .createobject(" adodb.recordset ")
set mytable3=server .createobject(" adodb.recordset ")
mySQL = " SELECT * FROM [banner] WHERE banner_postnr= '" & strfirst & "', banner_gender ='" & strgender & "'"
mytable.open mySQL,myconn,3, 3
randomize
Randomno = int ((mytable.recor dcount * rnd) + 1)
mytable.absolut eposition = cint(randomno)
sql1 = " SELECT * from Admin WHERE ID=1 ;"
mytable3.open sql1,myconn,3,3
%>
<% ' random usin mytable %>
<head>
<meta http-equiv="REFRESH" content="<%= mytable3.fields ("refresh").val ue %>">
<title></title>
</head>
<body topmargin="0" leftmargin="0">
<a href="redirect. asp?id=<%= mytable.fields( "id").value %>" target="_top">< img src="<%= mytable.fields( "banner_url").v alue %>" border="0"></a>
<%
id1= mytable.fields( "id").value
'count
mySQL = " SELECT * FROM [banner] WHERE id=" & id1 &";"
mytable2.open mysql,myconn,3, 3
mytable2.fields ("shows").va lue = mytable2.fields ("shows").va lue + 1
mytable2.update
mytable.close
set myconn=nothing
mytable2.close
end sub
%>
<%random_record %>
............... ............... ............... ............... ............... ............... ........
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (comma) in query expression 'banner_postnr= '5000', banner_gender ='mand''.
............... ............... ............... ............... ............... ............... .......
Here is the the code thanks:
............... ............... ............... ............... ............... ............... .......
<% sub random_record()
dim myconn,id1,myta ble,mytable2,my table3,mysql,sq l1,db_connectio nstring %>
<!-- #INCLUDE FILE="inc.asp" -->
<%
DIM strfirst, strlast, strgender, strage, strzip
strfirst = Request.Cookies ("prefs")("firs t")
strlast = Request.Cookies ("prefs")("last ")
strgender = Request.Cookies ("prefs")("gend er")
strage = Request.Cookies ("prefs")("alde r")
strzip = Request.Cookies ("prefs")("zip" )
Set Myconn = Server.CreateOb ject("ADODB.Con nection")
Myconn.CommandT imeout = 30
Myconn.Connecti onTimeout = 20
Myconn.Open DB_CONNECTIONST RING, DB_USERNAME, DB_PASSWORD
SET MYTABLE= SERVER.CREATEOB JECT("ADODB.REC ORDSET")
SET MYTABLE2= SERVER.CREATEOB JECT("ADODB.REC ORDSET")
SET MYTABLE3= SERVER.CREATEOB JECT("ADODB.REC ORDSET")
duplicateaccno = "true"
set mytable=server. createobject("a dodb.recordset" )
set mytable2=server .createobject(" adodb.recordset ")
set mytable3=server .createobject(" adodb.recordset ")
mySQL = " SELECT * FROM [banner] WHERE banner_postnr= '" & strfirst & "', banner_gender ='" & strgender & "'"
mytable.open mySQL,myconn,3, 3
randomize
Randomno = int ((mytable.recor dcount * rnd) + 1)
mytable.absolut eposition = cint(randomno)
sql1 = " SELECT * from Admin WHERE ID=1 ;"
mytable3.open sql1,myconn,3,3
%>
<% ' random usin mytable %>
<head>
<meta http-equiv="REFRESH" content="<%= mytable3.fields ("refresh").val ue %>">
<title></title>
</head>
<body topmargin="0" leftmargin="0">
<a href="redirect. asp?id=<%= mytable.fields( "id").value %>" target="_top">< img src="<%= mytable.fields( "banner_url").v alue %>" border="0"></a>
<%
id1= mytable.fields( "id").value
'count
mySQL = " SELECT * FROM [banner] WHERE id=" & id1 &";"
mytable2.open mysql,myconn,3, 3
mytable2.fields ("shows").va lue = mytable2.fields ("shows").va lue + 1
mytable2.update
mytable.close
set myconn=nothing
mytable2.close
end sub
%>
<%random_record %>
Comment