Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.9K
1 Posted Topic
help im trying to create a conditional database query this is what i have <CFQUERY name="qget_by_date" datasource="log"> Select * FROM productioninfo WHERE ((txtdate =#LSDateFormat(Now(), "d/m/yy")#)) </CFQUERY> <cfif qget_by_date.recordcount GT 0 > <cflocation url="poductioninfo_entryform.cfm"> <cfelse> <cflocation url="main.asp"> </cfif> this works but i need to check date=now and username="txt" an date= now …
The End.