Error Reading Database!! - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Error Reading Database!!

hi guys,

i have small problem regarding database connectivity!!
The following query is not working...:

querystr = "SELECT flight_no, from, to, dept_time, arr_time FROM tbl_FlightInfo WHERE origin = " & origin & "to = " & dest

Here:: 'origin' and 'dest' are string values which i have got thru the Request.Form()

Is there a synatx problem in the query???
Please Help!!
(SHONKS)

Comments

  • TWKTWK Posts: 1Member
    querystr = "SELECT flight_no, [from], [to], dept_time, arr_time FROM tbl_FlightInfo WHERE origin = '" & origin & "' to = '" & dest &"'"
  • sree3412sree3412 Posts: 2Member
    : hi guys,
    :
    : i have small problem regarding database connectivity!!
    : The following query is not working...:
    :
    : querystr = "SELECT flight_no, from, to, dept_time, arr_time FROM tbl_FlightInfo WHERE origin = " & origin & "to = " & dest
    :
    : Here:: 'origin' and 'dest' are string values which i have got thru the Request.Form()
    :
    : Is there a synatx problem in the query???
    : Please Help!!
    : (SHONKS)
    :



  • sree3412sree3412 Posts: 2Member
    hai..

    my name is sreejith a k ..
    ibeans software solution private limited
    kerala

    ******
    'origin' and 'dest' are string values so u pls change ur query like this ' " & origin & " ' and ' " & dest & " '



    note ... string values enclosed in this method ' " & field name & " '
    and integer values " & field name & "

    currect query is shown below


    querystr = "SELECT flight_no, from, to, dept_time, arr_time FROM tbl_FlightInfo WHERE origin =' " & origin & " ' to = ' " & dest & " ' "


    ******



    : : hi guys,
    : :
    : : i have small problem regarding database connectivity!!
    : : The following query is not working...:
    : :
    : : querystr = "SELECT flight_no, from, to, dept_time, arr_time FROM tbl_FlightInfo WHERE origin = " & origin & "to = " & dest
    : :
    : : Here:: 'origin' and 'dest' are string values which i have got thru the Request.Form()
    : :
    : : Is there a synatx problem in the query???
    : : Please Help!!
    : : (SHONKS)
    : :
    :
    :
    :
    :

Sign In or Register to comment.