<cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#arguments.details.CONTENT#">,
Error saving to a Memo field when the length of "CONTENT" is more than 510. Otherwise saves ok.
Please advise. ThankYou
ContiW
I would like to determine whether the value of an expression is equal to any of the values of a list contained in a specified column field:
Suppose "fieldname" contains (value1, value2, ....)
What is the correct syntax for:
SELECT *
FROM Orders
WHERE ShipRegion In (fieldname)
Thank You very...
Thanks LPatton. I would love to have some hints about it. Thanks for your offer.
WConti
walter@wconti.com
By the way: does the latest version of ColdFusion create PDFs automatically?
Newbe approach to Acrobat/ColdFusion interfacing.
A form is being submitted as HTML to a ColdFusion page.
Everything ok with the exception that the CF page does not open in my default browser (IE6) but in Acrobat. Is there a way of submitting and exiting Acrobat?
Thank you for helping.
SELECT COUNT(*) as reccount,
SUM(j.duration*#session.payInter.translatorRate#) as tot2pay,
SUM(j.duration) as totduration
FROM jobsDb j
WHERE j.linguistId = #linguistId#
AND j.status = 'completed'
AND j.interInvoiceBilled is not null
AND j.interInvoicePaid is null
j.duration could be a value...
The following query returns the expected recordset but all those subqueries look weird to me.
Is there a way of optimizing it? Thank You
<cfquery name="session.getJobs" datasource="#db#">
SELECT
j.*,
IIF([status] = 'completed','b','a') as statusorder,
j.duration*u.BasicFees as charges,
(select...
Need to extract distinct month name from date column.
I have found something like this
-----
SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
-----
which does not work.
Please advise. Thank You.
Need to know if the current page is the last in the history array. Theoretically "history[history.length-1] == window.location.href" should do it but
history[...],
history.current,
history.previous,
history.next,
return "undefined". Working with IE 6.0.
Is it a security...
Need to reposition the mouse pointer to 0,0 until the page loads completely. Disable it will also do. In any case it should be out-of-the-way. Is it possible with javascript, css, or dhtml?
Thank You all for helping.
myVar is actually an array element tranformed for semplicity, and it comes from a chunk of XML code which
comes from a database query. Cannot touch that.
Hello!
I have this var
myVar=new Date(2003,2,12,17,18,12);
alert(myVar)
returns "Wed Mar 12 17:18:12 PST 2003"
Is it possble to get the literal string
"new Date(2003,2,12,17,18,12)"
instead of the formed date?
All the best.
Greetings!
A tablecell contains a picture, a link and variables for the onMouseover statemnet, something like this:
<td width=100 align=center>
<img name='img"+i+"' src='./GalleryCover/"+i+".jpg' height=100 width=100 border=0...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.