SQL statemetn syntax error

[tester321]

Hi i'm using an access db and am getting this error, but i can't see what i did wrong, any ideas? thanks

Select [_BlogBook].MarkerID, [_Marker].MarkerLable FROM [_BlogBook] JOIN [_Marker] ON [_Marker].MarkerID = [_BlogBook].MarkerID Where [_BlogBook].BlogBookID=35


using it like so:

Set RS = Conn2.Execute("Select [_BlogBook].MarkerID, [_Marker].MarkerLable FROM [_BlogBook] JOIN [_Marker] ON [_Marker].MarkerID = [_BlogBook].MarkerID Where [_BlogBook].BlogBookID="&Request.QueryString("c"))

If Not RS.EOF Then
MN=RS("MarkerLable")
End If



Thanks again.

 

[ChrisHirst]

No idea,

you need to write the completed SQL string to the browser then you will see what is missing.

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[monksnake]

What error are you getting?

It could be a number of things that we can't see in your post.

<.

 

[mych]

tester...

change your code to

strSQL = "Select [_BlogBook].MarkerID, [_Marker].MarkerLable FROM [_BlogBook] JOIN [_Marker] ON [_Marker].MarkerID = [_BlogBook].MarkerID Where [_BlogBook].BlogBookID="&Request.QueryString("c"))

Set RS = Conn2.Execute(strSQL)

Response.write(strSQL) [red] 'this line will output the sql string to screen and you can then check for syntax or copy and paste it into an Access Query so that it points to where the syntax error may be. [/red]

If Not RS.EOF Then
   MN=RS("MarkerLable") 
End If

HTH
Mych

 

[ChrisHirst]

actually it needs to be written to the browser before the call to the execute method, otherwise it won't be shown if there is an error.


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[mych]

Chris... sorry yes you are right... brain slower than fingers!

 

[bslintx]

ummm...what's the error?

 

[bslintx]

ooopsie...disregard....cleverly disguised in the title<grin>

to add to mych debug approach...

iC = Request.QueryString("c")

If Len(iC) > 0 Then
 If isNumeric(iC) Then
  iC = CINT(iC)
  strSQL = "Select [_BlogBook].MarkerID, [_Marker].MarkerLable " & _
           "FROM [_BlogBook] " & _
           "INNER JOIN [_Marker] " & _
           "ON [_Marker].MarkerID = [_BlogBook].MarkerID " & _
           "WHERE [_BlogBook].BlogBookID=" & iC & "))

  ' sql debug..uncomment when needed
  '  Response.Write(strSQL) 
  '  Response.End 

    Set RS = Conn2.Execute(strSQL)


  If Not RS.EOF Then
   MN=RS("MarkerLable") 
  End If
 End If
End If

 

[bslintx]

crapola...perhaps the culprit is the closing paren on the select ...man o man where is the editing button?...sorry to butcher the thread