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
:
: 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)
:
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)
: :
:
:
:
: