Dynamic Query

[akola]

I have this query and would like it to display different results. I have to
display records for either today, yesterday, this week, last week, last month
and older. I could do it it several different queries but would rather have
one query and pass a parameter. I need help doing this. Here is the query I
am using.

Thanks.

SELECT a.dealer_id,
b.customerid,
b.CustomerFirstName,
b.CustomerLastName,
a.fullname,
a.status ,
a.loginID ,
b.Assigned_Time,
b.Date_Entered,
b.customertype,
b.vehicleType
FROM logins AS a
INNER JOIN Customers AS b
ON a.loginid = b.loginid
WHERE b.loginid = #client.bus_off_loginid#
and b.status not in ('Deleted','Transfered')
and CONVERT(char(10), b.assigned_time, 101) = '#dateformat(now(),
'mm/dd/yyyy')#'

[Jonathan_Quebec]

I would like to create a dynamic query

<cfquery name="update2" datasource="#Variables.DSN#" >#ligne#</cfquery>

the content of #ligne# is syntaxicely correct in SQL but procude a error.

what cann I do ?

[mxstu]

Post the query and the error message.

[MikerRoo]

Also try:

<cfquery name="update2" datasource="#Variables.DSN#" >#PreserveSingleQuotes (ligne)#</cfquery>

[fkj]

In ColdFusion, as it has its own form tags, is it possible to execute a query
like this:
<cfinput onblur="executethequeryhere"></cfinput>

Or something like this: <cfquery>select * from tablename where fieldname =
'formfield.value'</cfquery>

Thanks a lot,

Phillip

[CFDEBUG]

1st one don't work since JS is Client side and CF is server side.
2nd one is the standard form submission. so you can do it

Just have the input fields in a form and when you submit it, do the query like
you want to. If you need more details, do a search in these forums or check cf
doc or google. This has been discussed so many times.

[vkunirs]

Hi

<cfinput onblur="executethequeryhere"></cfinput>
if you want to execute some function when onblur, then you can write a JS
function which will submit the page to the itself.
then you can have condition whether it is onblur or not....

[PaulH]

if you're using cf7 and flash forms and don't mind writing a bit of action
script, yes you can do want you want clientside via remoting. see
[url]http://www.asfusion.com/blog/entry/populating-a-cfgrid-with-flash-remoting[/url] for
example. even *i* could do it ;-)