Posts
 
Reputation
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
~178 People Reached
Favorite Forums
Favorite Tags
Member Avatar for phijim

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 …

Member Avatar for Shaun Hannah
0
178