Ask a Question related to Macromedia ColdFusion, Design and Development.
-
chriskeeler2 #1
help with query code
Debugging info:
pdfselectlist (Datasource=prereg, Time=20ms, Records=3) in
D:\htdocs\examples\mycfs\formprocess.cfm @ 14:33:32.032
SELECT *
from pdf_status
WHERE ID IN (012,7,5)
Record count says 3, but I get 3 of the same pages inside the new PDF.
<cfcase value="batch">
<cfset SelectList = form.selectlist>
<cfquery datasource="prereg">
UPDATE pdf_status
SET print_flag = 'Yes'
WHERE ID IN (0#SelectList#)
</cfquery>
<cfquery datasource="prereg" name="pdfselectlist">
SELECT *
from pdf_status
WHERE ID IN (0#SelectList#)
</cfquery>
<cfset status = "Printed">
<cfset timestampfile = "#DateFormat(Now(), "mm-dd-yyyy")#"&"#TimeFormat(Now(),
"hh-mm-ss")#">
<cfset filename = "#timestampfile#.pdf">
<cf_pdf file="batch\#filename#">
<cfoutput query="pdfSelectlist">
<cf_pdf_info file="upload\#pdfselectlist.pdf_name#">
<cfset index=1>
<cfloop query="request.PDFInfo">
<cf_pdf_page width="#width#" height="#height#">
<cf_pdf_read file="upload\#pdfselectlist.pdf_name#" page="#index#" />
</cf_pdf_page>
<cfset index = index + 1>
</cfloop>
</cfoutput>
</cf_pdf>
<!---<cflocation url="formmanage.cfm?status=Printed">--->
</cfcase>
chriskeeler2 Guest
-
Zip code radius query
I found this query in another post and since it appeared to be exactly what i needed, i copied it. thank you to the author. My problem is that... -
Query of Queries in CF7 crashes code from CF5
If anyone has a suggestion to this question, I would be most appreciative. In CF5, I was using a query to show current logged in users within our... -
Query return code question
All... I'm having problems figuring out what pg_query() really returns when there is an error. The documentation says it returns "FALSE",... -
how to pass an access DB query onto *next* page? trouble with *next* and *previous* querystring code
Don;t see any sign of any paging code is your snippets normally take this form Set rso = Server.CreateObject("ADODB.Recordset") rso.PageSize =... -
diff between query and sql code?
in the example following here, it seems to be invoking the 'yourQuery' but the sql code is doing that same thing only based on an index lookup.... -



Reply With Quote

