Hoping someone can help me out here.
I have a CF template that updates a database of music file info from disk
directory info. I can say more about the template, but the problem seems to be
somewhat unrelated.
On my development machine, the template runs perfectly. It takes about 12
minutes
Hi Massimo,
Yes, it's something like the
http://www.massimocorner.com/libraries/spry/linkedselect/sample_api.htm
example.
I will try to modify it to allow items to be moved between the two
selects and instead of the Reset button to have another select. If the
selected item in this select is
Can anyone tell me exactly what is causing this error ?
!---Update using a CFQUERY with SQL UPDATE ---
CFquery NAME=qUpdate DATASOURCE=learncfe!--- error ---
UPDATE GuestBook
SET (GuestName = '#Form.GuestName#',
Email = '#Form.Email#',
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Sorry that should be Comments = '#trim(Form.Comments)#)'
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu jide_a...@hotmail.com wrote:
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Remove the opening bracket as well
CFquery NAME=qUpdate DATASOURCE=learncfe!--- error ---
UPDATE GuestBook
Thanks, but that is supposed to be the right bracket of the SET
- Original Message -
From: Jide Aliu jide_a...@hotmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December 28, 2008 4:33 PM
Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments =
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Remove the opening bracket as well
CFquery NAME=qUpdate DATASOURCE=learncfe!--- error ---
UPDATE GuestBook
SET
GuestName = '#Form.GuestName#',
Email =
Woo !Thanks for that. works ok now.
- Original Message -
From: Casey Dougall ca...@uberwebsitesolutions.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December 28, 2008 4:37 PM
Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
On Sun, Dec 28, 2008
Woo ! Thanks for thatworks ok now.
- Original Message -
From: Jide Aliu jide_a...@hotmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December 28, 2008 4:35 PM
Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments = '#trim(Form.Comments)#')
Thanks, but that is supposed to be the right bracket of the SET
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Yep, but syntactically (sqlwise) you can't have the construct (opening and
closing bracket) the way it's laid out unlike your
View the source from the browser, and compare the one on your dev
machine to the live server. There is always the chance of a virus on
the server putting something extra into the output
~|
Adobe® ColdFusion® 8 software 8 is
I have a CF template that updates a database of music file info from disk
directory info. I
can say more about the template, but the problem seems to be somewhat
unrelated.
On my development machine, the template runs perfectly. It takes about 12
minutes to
do all of the disk read,
Is there a way to set the default zoom to 100% for a generated PDF
document by changing some attribute in the cfdocument code?
Controlling the default in the file is preferred over relying on the
default set in Acrobat Reader.
I believe it is possible to change the default by post-processing with
I have a CF template that updates a database of music file info from
disk directory info. I
can say more about the template, but the problem seems to be
somewhat unrelated.
On my development machine, the template runs perfectly. It takes
about 12 minutes to
do all of the disk
View the source from the browser, and compare the one on your dev
machine to the live server. There is always the chance of a virus on
the server putting something extra into the output
~|
Adobe® ColdFusion® 8 software 8 is
View the source from the browser, and compare the one on your dev
machine to the live server. There is always the chance of a virus on
the server putting something extra into the output
Al, Thanks for the suggestion. The problem is that the page never really
completes in the tab that it's
I have an orders table with a datetime field. I'm trying to query orders that
are x number of days back from today. Ex. Show me all orders 30 days back from
now.
SELECT date(orderdate) as thedate, sum(ordertotal) AS ordersubtotal
FROM tblOrders
where orderdate = current_date() - 30
group by
Hey Everyone,
I am trying to write a script that will hit the next button (right arrow
key to the right of jump to) on this page:
https://www.stompy.com/index.php?section=ep
the problem is that there is no specific link - that tracklisting window
is dynamically generated and that button uses
I would use the DATEDIFF() function:
SELECT DATE(orderdate) AS thedate, SUM(ordertotal) AS ordersubtotal
FROM tblOrders
WHERE DATEDIFF(current_date(), orderdate) = 30
GROUP BY DATE(orderdate)
(I think this should work; I use MSSQL, so can't test this...)
Seb
Seb Duggan
Web ColdFusion
One of the last few threads mentioned about ColdFusion Express? Last heard was
like four or five years ago, have I been sleeping all these years? Or is it
something sort of Adobe's interesting secret? Or does the thread refer to the
same old express?
Enlight me please.
Hi all
Razuna 1.1.3 with MySQL support, and much more available.
http://blog.sixsigns.com/2008/12/26/razuna-113-released-even-more-power-to-the-open-source-digital-asset-management/
Kind Regards,
Nitai
--
Razuna On-Demand - Hosted Digital Asset Management Solution
Razuna - Open Source
I am trying to write a script that will hit the next button
(right arrow key to the right of jump to) on this page:
https://www.stompy.com/index.php?section=ep
the problem is that there is no specific link - that
tracklisting window is dynamically generated and that
button uses javascript
One of the last few threads mentioned about ColdFusion
Express?
Nothing's changed since you originally heard about it. It was released
in the CF 4.5 timeframe. There have been no new releases.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest
Take a look at the page and you'll notice that the href for the next
page (right arrow) is href=#. It seems to be handled by
onclick=mClick('next').
any idea if there's anything I can do?
Dave Watts wrote:
I am trying to write a script that will hit the next button
(right arrow key to
(I think this should work; I use MSSQL, so can't test this...)
Seb
Yep, that works perfectly! I really appreciate it dude!
I still wonder why what I was using wasn't working.
Thanks,
Will
~|
Adobe® ColdFusion® 8 software 8
Yeah DATE_SUB() would work too
select * from table WHERE date_column BETWEEN CURDATE() and
DATE_SUB(CURDATE(),INTERVAL 30 DAY)
Eric
On Sun, Dec 28, 2008 at 7:00 PM, Will Tomlinson w...@wtomlinson.com wrote:
(I think this should work; I use MSSQL, so can't test this...)
Seb
Yep, that
I'm doing a series of Open University short courses,
and being introduced to CF with this version.
It also came with the SAMs Teach Yourself ColdFusion Express in 24 hrs.
- Original Message -
From: Don L do...@yahoo.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December
That version, as has been pointed out, is quite a number of years old. You
might be better off downloading the developer's edition of the latest
version (CF 8) from Adobe's site. It's free and fully functional (only
limitation is that it can only be accessed by 2 external IP addresses... but
29 matches
Mail list logo