|
| |
|
|
jorgev
Posts: 19
Joined: 2/14/2005
Status: offline
 |
Date as criteria problem - 3/25/2009 7:21:43
Hello all,
I'm having troubels to get my query working, I know the problem lies withing the fact that i'm using a datefield as criteria
This is the link i'm using to get to the page that will execute the query
deleteontworming.asp?paardid=<%=FP_FieldURL(fp_rs,"paardid")%>&dat=<%=FP_FieldURL(fp_rs,"dat")%>
If i hover over this link then in the status bar of IE i see the following info:
Instead of displaying the date part as 20/03/2009 it will be displayed as 20%2F03%2F2009 in the link, could that be the problem??
This is the page (deleteontworming.asp) with the query:
fp_sQry="DELETE DISTINCT from wormen where paardid=::paardid:: and [dat]= #::[dat]::#"
Offcours dat is the datefield
But its not working , can anyone give me some tips, i know it has been asked before, iv'e been reading lots of posts regarding this but i can't figure it out.
|
|
|
|
jorgev
Posts: 19
Joined: 2/14/2005
Status: offline
|
RE: Date as criteria problem - 3/25/2009 14:30:12
I could redo the thing and work with an ID field, and thus avoiding the use of a date as criteria, but i want to do it just to learn something new.
I think i have to format the hyperlink i'm using, actually the following part of it:
&dat=<%=FP_FieldURL(fp_rs,"dat")%>
beceause it's giving this as result in IE:
20/03/2009 will be passed as 20%2F03%2F2009
so the wrong data is send to the query
So i'm looking for a way to format my link so it knows that "dat" is a date.
&dat=<%=FP_FieldURL(fp_rs,..........)%>
any help would be welcome
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Date as criteria problem - 3/28/2009 10:27:44
Does it help any if you change:
&dat=<%=FP_FieldURL(fp_rs,"dat")%>
to
&dat=<%=FP_Field(fp_rs,"dat")%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 