Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
feral99 #1
unusual cfquery problem
This is an unusual problem.
I am attempting to populate a grid from a query ("rec_count2") which has a
"where" variable based the tab selected (#tags.pageid#) by the user.
The issue is that the variable is being passed sucessfully to the query when
the appropriate tab is selectedv and the result is being correctly displayed in
<cfformitem>, however when building the grid, only the results for the initial
"where" variable are being diplayed regardless of the the tab selected.
<cfform name="mulitdata" format="flash" skin="haloGreen">
<cfformgroup type="tabnavigator" width="420">
<cfloop query="tags">
<cfformgroup type="page" query="tags" label="#tags.pagedesc#"
onclick="window.close">
<cfquery name="rec_count2" datasource="hyd2web">
SELECT lldata.pageid, lldata.siteid, llsites.sitedesc, lldata.date_time,
lldata.value FROM lldata, llsites
WHERE llsites.SiteID=lldata.SiteID and lldata.value<>"not available" and
lldata.pageid='#tags.pageid#'
</cfquery>
<cfformitem type="text" height="20">
database: <cfoutput>#rec_count2.pageid#</cfoutput>
</cfformitem>
<cfgrid name="#tags.pagedesc#wind_stat" width="400" height="360" font="Arial"
rowheaders="no" colHeaders="yes" colHeaderFontSize="11" colHeaderBold="yes"
BGCOLOR="##DDE3E1,##FFFFFF">
<cfgridcolumn name="Site" width="70" dataAlign="Right" >
<cfgridcolumn name="Desc" width="70" dataAlign="Center" >
<cfgridcolumn name="Date" width="64" dataAlign="Right">
<cfgridcolumn name="Time" width="70" dataAlign="Right">
<cfgridcolumn name="Value" width="100" dataAlign="Right">
<cfloop query="rec_count2">
<cfgridrow
data="#rec_count2.pageid#,#rec_count2.sitedesc#,#d ateformat(rec_count2.date_time
,"dd/mm/yy")#,#timeformat(rec_count2.date_time,"HH:MM:SS") #,#rec_count2.value#">
</cfloop>
</cfgrid>
</cfformgroup>
</cfloop>
</cfformgroup>
</cfform>
feral99 Guest
-
CFQUERY problem
I am passing three values from a form to a search application, miles, zip, and day. I want to test for database entries in which the day's field is... -
double single quote problem in cfquery
Hi, i've this problem with ColdFusion MX 6.1 Updater and MX 7 If i try to insert a text containing a single quote (for example TEST') all works... -
<cfquery> syntax problem
Guys can someone tell me whats wrong with the line I have put in bold? Im trying to run this query but I get an error telling me the syntax is wrong... -
Javascript and CFquery problem
Hi guys, im hoping you can help. Im currently working on a page that contains a single drop down list that is dynamically populated from the... -
Getting unusual error - I think.
Running W2K, Access 2000 with all updates prior to SP4. Running into two errors. Attempting to recreate a Microsoft ASP "Guestbook" example. (About...



Reply With Quote

