RE: Help please - a 500 null error
Pete, Try putting cfflush / as the VERY FIRST part of the application. What I find with the 500 NULL errors is that an error is occuring so early that no content even gets flushed the browser. But putting CFFlush in, it sometimes forces the ColdFusion Exception objecto be dumped to the screen. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Friday, November 16, 2007 12:52 AM To: CF-Talk Subject: Help please - a 500 null error I am getting a 500 null error (and that is all it says) under MX7. The code works great under CF8 (and in fact is modified from a site I wrote previously that works perfectly still). It is not using any CF8 features as my host does not yet support it. Tried local MX7 (500 Null) and CF8 (works great - as intended). Any ideas where I should look to solve this problem? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help please - a 500 null error
Check your ColdFusion server logs. They will usually contain the real error. I have gotten 500 NULLs before when wddxing large objects, or applying regex to very lengthy strings. It could be a number of things-- but likely memory related. ~Brad -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 11:52 PM To: CF-Talk Subject: Help please - a 500 null error I am getting a 500 null error (and that is all it says) under MX7. The code works great under CF8 (and in fact is modified from a site I wrote previously that works perfectly still). It is not using any CF8 features as my host does not yet support it. Tried local MX7 (500 Null) and CF8 (works great - as intended). Any ideas where I should look to solve this problem? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP Please - Using Coldfusion to Import delimited txt files.
It would appear that not all the lines of your input file have four values. Keep in mind current versions of CF ignore empty list elements. Ex: item1,item2,,item4 The above comma delimited list only has 3 items, even though it would appear to have 4. (Word is, CF8 fixed that) ~Brad = Invalid list index 4. In function ListGetAt(list, index [, delimiters]), the value of index, 4, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list.The error occurred in *testload.cfm: line 15* ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HELP Please - Using Coldfusion to Import delimited txt files.
Wait, I just noticed the fourth listgetat doesn't specify a delimiter--
which means it is defaulting to a comma.
That would cause problems when using a | or ~ delimiter. (or
technically, anything OTHER than a comma)
If you change the fourth line to '#listgetAt('#index#',4,'|')#' that
should help.
~Brad
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284114
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Dae,
I have questions:
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
First, are you sure that #chr(10)##chr(13)# is working for you? I've always
concatenated those two things together to get the carriage return linefeed.
#chr(10) chr(13)#... Either way, the double set of pound signs isn't
necessary here one set will do.
Second, the last list get at is missing the pipe delimiter so that one will
default to a comma. Did you do that on purpose or is that a typo?
Also again, It isn't necessary to have all those pound signs in your
listgetat statements. The following will work:
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('index',1, '|')#',
'#listgetAt('index',2, '|')#',
'#listgetAt('index',3, '|')#',
'#listgetAt('index',4)#'
)
/cfquery
Does any of that help? Let us know.
Cheers,
Chris
On 7/19/07, Dae [EMAIL PROTECTED] wrote:
Someone help me... I need a way, other then using DTS to insert data into
a
SQL table. I was able to find some code on easyCFM.com, and it works, but
only with comma delimited files. What I need to know is how I might be
able
to correct this so I can use files with other delimiters.
Below is the text file and code. The way it is now, it works fine. When
I
change the delimiter from a comma ',' to say tilde '~' in the file and the
code, I bombs!
test.txt file:
20070510,Joe Smith, 312-555-1212,32121
20070510,Mary Smith, 312-555-1212,32121
20070509,John Doe, 413-555-4312,54331
20070508,Mike Cole, 541-555-9119,21112
20070504,Jane Short, 801-555-1332,73124
=
Here's the code:
!--- get and read the TXT file ---
cffile action=read file=test.txt variable=txtfile
!--- loop through the TXT file on line breaks and insert into database
---
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
!--- use a simple database query to check the results of the import -
dumping query to screen ---
cfquery name=rscsvdemo datasource=sqlconnect
SELECT * FROM testload
/cfquery
cfdump var=#rscsvdemo#
Someone help!! How do I fix it to work with other delimiters? I get the
below error if I can the comma to say a pipeline '|'. I made sure to
change
the test.txt file to match.
Invalid list index 4. In function ListGetAt(list, index [, delimiters]),
the value of index, 4, is not a valid as the first argument (this list has
1
elements). Valid indexes are in the range 1 through the number of elements
in the list.The error occurred in *testload.cfm: line 15*
13 :'#listgetAt('#index#',2, '|')#',
14 :'#listgetAt('#index#',3, '|')#',
*15 :'#listgetAt('#index#',4)#'*
16 : )
17 :/cfquery
Thanks all!!
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
On 7/19/07, Dae [EMAIL PROTECTED] wrote:
Invalid list index 4. In function ListGetAt(list, index [, delimiters]),
the value of index, 4, is not a valid as the first argument (this list has 1
elements). Valid indexes are in the range 1 through the number of elements
in the list.The error occurred in *testload.cfm: line 15*
13 :'#listgetAt('#index#',2, '|')#',
14 :'#listgetAt('#index#',3, '|')#',
*15 :'#listgetAt('#index#',4)#'*
16 : )
17 :/cfquery
I don't see that you specified a delimiter for the last listGetAt()
function... so it'd default to comma.
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284116
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Thank you Charlie!! I didn't think it needed one because after the 4th
field, it's a CR/LR. Regardless, changing to:
'#listgetAt('#index#',4, '|')#',
WORKED!!!
THANK YOU!!!
- Dae
===
On 7/19/07, Charlie Griefer [EMAIL PROTECTED] wrote:
On 7/19/07, Dae [EMAIL PROTECTED] wrote:
Invalid list index 4. In function ListGetAt(list, index [,
delimiters]),
the value of index, 4, is not a valid as the first argument (this list
has 1
elements). Valid indexes are in the range 1 through the number of
elements
in the list.The error occurred in *testload.cfm: line 15*
13 :'#listgetAt('#index#',2, '|')#',
14 :'#listgetAt('#index#',3, '|')#',
*15 :'#listgetAt('#index#',4)#'*
16 : )
17 :/cfquery
I don't see that you specified a delimiter for the last listGetAt()
function... so it'd default to comma.
--
Charlie Griefer
~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284120
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Someone help!! How do I fix it to work with other delimiters? I get the
below error if I can the comma to say a pipeline '|'. I made sure to change
the test.txt file to match.
*15 :'#listgetAt('#index#',4)#'*
Also, you forgot the pipe delimiter on the last line
'#listgetAt(index, 4, '|')#'
~|
CF 8 â Scorpio beta now available,
easily build great internet experiences â Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284123
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
The performance of cffile action=read and cfloop list=file, delim=end of line chars is terribly poor... Furthermore (as you have found out), there's usually a lot of trial and error getting this to work. Assuming you have a well-formatted delimited text file, the best approach is to use CFHTTP: cfhttp url=http://www.domain.com/urltotextfile/file.txt; name=data columns=field1,field2,field3 firstrowasheaders=false delimiter=| textQualifier= / OR if your first row does contain column headers: cfhttp url=http://www.domain.com/urltotextfile/file.txt; name=data firstrowasheaders=true delimiter=| textQualifier= / Both will result in a query object named 'data'. Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Also again, It isn't necessary to have all those pound signs in your
listgetat statements. The following will work:
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('index',1, '|')#',
'#listgetAt('index',2, '|')#',
'#listgetAt('index',3, '|')#',
'#listgetAt('index',4)#'
)
/cfquery
But without the quotes around the index variable!
Also, to aviod encountering the problem of empty items, i.e. 1|2||4, do a
replace on all double occurrences of your delimiter before you start the
loop. i.e.
cfset txtFile = Replace(textFile, '||', '| |', 'all)
You may even have to do that twice to fix two empty list items in a row (i.e.
'1|||4'). Don't ask me why, but I seem to remember needing to do that!
Finally, if it is a massive CSV file, you might wish to build a long SQL
string first so that only make one call to the db. So:
cfset txtFile = Replace(textFile, '||', '| |', 'all)
cfset txtFile = Replace(textFile, '||', '| |', 'all)
cfsavecontent variable=big_sql_statement
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt(index, 1, |)#',
'#listgetAt(index, 2, |)#',
'#listgetAt(index, 3, |)#',
'#listgetAt(index, 4, |)#'
)
/cfloop
/cfsavecontent
cfquery name=importtxt datasource=sqlconnect
#big_sql_statement#
/cfquery
My tuppence,
Dominic
On 19/07/07, Christopher Jordan [EMAIL PROTECTED] wrote:
Dae,
I have questions:
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
First, are you sure that #chr(10)##chr(13)# is working for you? I've
always
concatenated those two things together to get the carriage return
linefeed.
#chr(10) chr(13)#... Either way, the double set of pound signs isn't
necessary here one set will do.
Second, the last list get at is missing the pipe delimiter so that one
will
default to a comma. Did you do that on purpose or is that a typo?
Also again, It isn't necessary to have all those pound signs in your
listgetat statements. The following will work:
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('index',1, '|')#',
'#listgetAt('index',2, '|')#',
'#listgetAt('index',3, '|')#',
'#listgetAt('index',4)#'
)
/cfquery
Does any of that help? Let us know.
Cheers,
Chris
On 7/19/07, Dae [EMAIL PROTECTED] wrote:
Someone help me... I need a way, other then using DTS to insert data
into
a
SQL table. I was able to find some code on easyCFM.com, and it works,
but
only with comma delimited files. What I need to know is how I might be
able
to correct this so I can use files with other delimiters.
Below is the text file and code. The way it is now, it works
fine. When
I
change the delimiter from a comma ',' to say tilde '~' in the file and
the
code, I bombs!
test.txt file:
20070510,Joe Smith, 312-555-1212,32121
20070510,Mary Smith, 312-555-1212,32121
20070509,John Doe, 413-555-4312,54331
20070508,Mike Cole, 541-555-9119,21112
20070504,Jane Short, 801-555-1332,73124
=
Here's the code:
!--- get and read the TXT file ---
cffile action=read file=test.txt variable=txtfile
!--- loop through the TXT file on line breaks and insert into database
---
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
!--- use a simple database query to check the results of the import -
dumping query to screen ---
cfquery name=rscsvdemo datasource=sqlconnect
SELECT * FROM testload
/cfquery
cfdump var=#rscsvdemo#
Someone help!! How do I fix it to work with other delimiters? I get
the
below error if I can the comma to say a pipeline '|'. I made sure to
change
the test.txt file to match.
Invalid list index 4. In function
RE: HELP Please - Using Coldfusion to Import delimited txt files.
You don't have the delimiter specified on the last item in the INSERT
statement, but you need it. Otherwise listGetAt() (or any list function)
assumes a comma delimiter.
-Original Message-
From: Dae [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 19, 2007 12:35 PM
To: CF-Talk
Subject: HELP Please - Using Coldfusion to Import delimited txt files.
Someone help me... I need a way, other then using DTS to insert data into a
SQL table. I was able to find some code on easyCFM.com, and it works, but
only with comma delimited files. What I need to know is how I might be able
to correct this so I can use files with other delimiters.
Below is the text file and code. The way it is now, it works fine. When I
change the delimiter from a comma ',' to say tilde '~' in the file and the
code, I bombs!
test.txt file:
20070510,Joe Smith, 312-555-1212,32121
20070510,Mary Smith, 312-555-1212,32121
20070509,John Doe, 413-555-4312,54331
20070508,Mike Cole, 541-555-9119,21112
20070504,Jane Short, 801-555-1332,73124
=
Here's the code:
!--- get and read the TXT file ---
cffile action=read file=test.txt variable=txtfile
!--- loop through the TXT file on line breaks and insert into database ---
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
!--- use a simple database query to check the results of the import -
dumping query to screen ---
cfquery name=rscsvdemo datasource=sqlconnect
SELECT * FROM testload
/cfquery
cfdump var=#rscsvdemo#
Someone help!! How do I fix it to work with other delimiters? I get the
below error if I can the comma to say a pipeline '|'. I made sure to change
the test.txt file to match.
Invalid list index 4. In function ListGetAt(list, index [, delimiters]),
the value of index, 4, is not a valid as the first argument (this list has 1
elements). Valid indexes are in the range 1 through the number of elements
in the list.The error occurred in *testload.cfm: line 15*
13 :'#listgetAt('#index#',2, '|')#',
14 :'#listgetAt('#index#',3, '|')#',
*15 :'#listgetAt('#index#',4)#'*
16 : )
17 :/cfquery
Thanks all!!
~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284131
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Dominic's right. I missed the quotes around the index variable. oops! :o)
Chris
On 7/19/07, Dominic Watson [EMAIL PROTECTED] wrote:
Also again, It isn't necessary to have all those pound signs in your
listgetat statements. The following will work:
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('index',1, '|')#',
'#listgetAt('index',2, '|')#',
'#listgetAt('index',3, '|')#',
'#listgetAt('index',4)#'
)
/cfquery
But without the quotes around the index variable!
Also, to aviod encountering the problem of empty items, i.e. 1|2||4, do a
replace on all double occurrences of your delimiter before you start the
loop. i.e.
cfset txtFile = Replace(textFile, '||', '| |', 'all)
You may even have to do that twice to fix two empty list items in a row (
i.e.
'1|||4'). Don't ask me why, but I seem to remember needing to do that!
Finally, if it is a massive CSV file, you might wish to build a long SQL
string first so that only make one call to the db. So:
cfset txtFile = Replace(textFile, '||', '| |', 'all)
cfset txtFile = Replace(textFile, '||', '| |', 'all)
cfsavecontent variable=big_sql_statement
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt(index, 1, |)#',
'#listgetAt(index, 2, |)#',
'#listgetAt(index, 3, |)#',
'#listgetAt(index, 4, |)#'
)
/cfloop
/cfsavecontent
cfquery name=importtxt datasource=sqlconnect
#big_sql_statement#
/cfquery
My tuppence,
Dominic
On 19/07/07, Christopher Jordan [EMAIL PROTECTED] wrote:
Dae,
I have questions:
cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
First, are you sure that #chr(10)##chr(13)# is working for you? I've
always
concatenated those two things together to get the carriage return
linefeed.
#chr(10) chr(13)#... Either way, the double set of pound signs isn't
necessary here one set will do.
Second, the last list get at is missing the pipe delimiter so that one
will
default to a comma. Did you do that on purpose or is that a typo?
Also again, It isn't necessary to have all those pound signs in your
listgetat statements. The following will work:
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('index',1, '|')#',
'#listgetAt('index',2, '|')#',
'#listgetAt('index',3, '|')#',
'#listgetAt('index',4)#'
)
/cfquery
Does any of that help? Let us know.
Cheers,
Chris
On 7/19/07, Dae [EMAIL PROTECTED] wrote:
Someone help me... I need a way, other then using DTS to insert data
into
a
SQL table. I was able to find some code on easyCFM.com, and it works,
but
only with comma delimited files. What I need to know is how I might
be
able
to correct this so I can use files with other delimiters.
Below is the text file and code. The way it is now, it works
fine. When
I
change the delimiter from a comma ',' to say tilde '~' in the file and
the
code, I bombs!
test.txt file:
20070510,Joe Smith, 312-555-1212,32121
20070510,Mary Smith, 312-555-1212,32121
20070509,John Doe, 413-555-4312,54331
20070508,Mike Cole, 541-555-9119,21112
20070504,Jane Short, 801-555-1332,73124
=
Here's the code:
!--- get and read the TXT file ---
cffile action=read file=test.txt variable=txtfile
!--- loop through the TXT file on line breaks and insert into
database
---
cfloop index=index list=#txtfile#
delimiters=#chr(10)##chr(13)#
cfquery name=importtxt datasource=sqlconnect
INSERT INTO testload (date_add,name,phone,zip)
VALUES
('#listgetAt('#index#',1, '|')#',
'#listgetAt('#index#',2, '|')#',
'#listgetAt('#index#',3, '|')#',
'#listgetAt('#index#',4)#'
)
/cfquery
/cfloop
!--- use a simple database query to check the results of the import -
dumping query to screen ---
cfquery name=rscsvdemo datasource=sqlconnect
SELECT * FROM testload
/cfquery
cfdump
RE: HELP Please - Using Coldfusion to Import delimited txt files.
I think your confusion was that you really have two lists here. A crlf
delimited list of pipe delimited lists.
Each line of the file is a single item in the crlf delimited list.
WITHIN each line is the second list of | delimited items.
When you reference that inner list, you still have to tell CF that it is
delimited by pipes each time. Just because you interrogate a string as
a pipe delimited list three times in a row, doesn't make CF assume you
still want to use a pipe the fourth time if you don't tell it.
Technically the crlf isn't even part of the inner list at all.
~Brad
-Original Message-
From: Dae [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 19, 2007 1:22 PM
To: CF-Talk
Subject: Re: HELP Please - Using Coldfusion to Import delimited txt
files.
Thank you Charlie!! I didn't think it needed one because after the 4th
field, it's a CR/LR. Regardless, changing to:
'#listgetAt('#index#',4, '|')#',
WORKED!!!
THANK YOU!!!
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Ben Nadel wrote a nice function for parsing csv-type files that works very well: http://www.bennadel.com/index.cfm?dax=blog:498.view Cheers, Kris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
Nice Tip Jake! Chris On 7/19/07, Jake Pilgrim [EMAIL PROTECTED] wrote: The performance of cffile action=read and cfloop list=file, delim=end of line chars is terribly poor... Furthermore (as you have found out), there's usually a lot of trial and error getting this to work. Assuming you have a well-formatted delimited text file, the best approach is to use CFHTTP: cfhttp url=http://www.domain.com/urltotextfile/file.txt; name=data columns=field1,field2,field3 firstrowasheaders=false delimiter=| textQualifier= / OR if your first row does contain column headers: cfhttp url=http://www.domain.com/urltotextfile/file.txt; name=data firstrowasheaders=true delimiter=| textQualifier= / Both will result in a query object named 'data'. Jake Pilgrim ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help please
You can't see the tables under the DB tab, but are you able to browse files on the server? Additionally, are the user name and passwords for the data sources actually in the administrator? I know I sometimes don't do that, and pass them in to the connection through the cfquery tag, for security. If that info isn't there than you won't see the DB. 1st ensure rds is on and you can browse the server then make sure that the data sources verify properly in the administrator. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 6:35 PM To: CF-Talk Subject: Help please Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help please
Well, I can browse the server and the datasources cerify as ok. I can see the SQL's base tables but cannot see the user tables. Just weird. - Original Message - From: Loathe [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, August 04, 2006 4:40 PM Subject: RE: Help please You can't see the tables under the DB tab, but are you able to browse files on the server? Additionally, are the user name and passwords for the data sources actually in the administrator? I know I sometimes don't do that, and pass them in to the connection through the cfquery tag, for security. If that info isn't there than you won't see the DB. 1st ensure rds is on and you can browse the server then make sure that the data sources verify properly in the administrator. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 6:35 PM To: CF-Talk Subject: Help please Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help please
Figured it out..damn ODBC datasources. I have to remember that you have to restart after making changes. Thanks - Original Message - From: Doug [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, August 04, 2006 5:00 PM Subject: Re: Help please Well, I can browse the server and the datasources cerify as ok. I can see the SQL's base tables but cannot see the user tables. Just weird. - Original Message - From: Loathe [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, August 04, 2006 4:40 PM Subject: RE: Help please You can't see the tables under the DB tab, but are you able to browse files on the server? Additionally, are the user name and passwords for the data sources actually in the administrator? I know I sometimes don't do that, and pass them in to the connection through the cfquery tag, for security. If that info isn't there than you won't see the DB. 1st ensure rds is on and you can browse the server then make sure that the data sources verify properly in the administrator. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 6:35 PM To: CF-Talk Subject: Help please Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!!
I don't know the exact fix, but I can tell you a little more about what Access is saying. I have seen this wonderful error before within Access while designing forms. Generally, it only comes up when you have built a form control containing a dot or a bracket in the name, which makes Access choke. How does the update statement work if you remove the email line? M -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!!
IF you're using SQLServer, it's very finicky about double and single quotes. Double quotes in your values means for SQL to set the values equal to the column name .. e.g. set the column LastName equal to the column 11. But of course you don't have a column called 11. However single quotes tell SQL to set the column equal to the value 11. Therefore, I think your problem is solved if you change your code to: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = '#form.lname#', FirstName = '#form.fname#', Building = '#form.bldg#', DeptCode = '#form.dept#', Job = '#form.job#', Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = '#form.email#', GroupCode = #form.group#, FTE = '#form.fte#', SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery And you had better check the other case too - where you have no quotes at all. They should be single quotes too I think. Not sure why the error message is so vague. Probably because SQL doesn't give ColdFusion back much to work with, but it is very obtuse and would be far better if it told you more about what it was complaining about. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 5:08 AM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!!
You've got to replace your double quotes with single quotes around the text values, otherwise SQL thinks you're trying to update a column. Old: SET LastName = #form.lname#, New: SET LastName = '#form.lname#', Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!! - SOLVED
Thanks everyone for the help! Scott -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:32 PM To: CF-Talk Subject: RE: HELP PLEASE IF you're using SQLServer, it's very finicky about double and single quotes. Double quotes in your values means for SQL to set the values equal to the column name .. e.g. set the column LastName equal to the column 11. But of course you don't have a column called 11. However single quotes tell SQL to set the column equal to the value 11. Therefore, I think your problem is solved if you change your code to: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = '#form.lname#', FirstName = '#form.fname#', Building = '#form.bldg#', DeptCode = '#form.dept#', Job = '#form.job#', Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = '#form.email#', GroupCode = #form.group#, FTE = '#form.fte#', SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery And you had better check the other case too - where you have no quotes at all. They should be single quotes too I think. Not sure why the error message is so vague. Probably because SQL doesn't give ColdFusion back much to work with, but it is very obtuse and would be far better if it told you more about what it was complaining about. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 5:08 AM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP PLEASE!!!!
Perhaps try using single quotes instead of double quotes around the values. -Justin Scott - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
This sounds like a job for (da da da-dh) RegEx! You want something along the lines of string = rereplace(string, '\[([^]]+)\]', 'a href=\1\1/a', 'all'); I /think/ this will work. I've not tested it and whatnot. Working with brackets and other special characters always adds a bit of adventure to it. :-) HTH. And, of course, if you need more help or more in-depth commentary, jump on over to CF-RegEx (available via the [http://www.houseoffusion.com] website). Good luck. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 2:43 PM : To: CF-Talk : Subject: Help Please: Find/Replace : : : OK I am sure there is an ez way to do this my brain just doesn't : seem to be : working today... : : We have an application where some people may enter URLs they are : requested : to enter them like so : : [http://www.whatever.com] : [http://www.whatever2.com] : [http://www.whatever3.com] : : What i want to be able to do is find each [ ] and take what's in : the middle : of it and wrap it in a a : href=http://www.whatever.com;http://www.whatever.com/a and : remove the [ : ] there may be multiple URLS in the text. I have been messin around with : the find/replace etc. for a bit now and running into some problems. I am : sure i am just doing it wrong. Any suggestions on how to do this right? : : Kelly : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
YOU RULE! :) that worked just wonderfully :-) From: Ben Doom [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Help Please: Find/Replace Date: Thu, 23 Jan 2003 14:54:43 -0500 This sounds like a job for (da da da-dh) RegEx! You want something along the lines of string = rereplace(string, '\[([^]]+)\]', 'a href=\1\1/a', 'all'); I /think/ this will work. I've not tested it and whatnot. Working with brackets and other special characters always adds a bit of adventure to it. :-) HTH. And, of course, if you need more help or more in-depth commentary, jump on over to CF-RegEx (available via the [http://www.houseoffusion.com] website). Good luck. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 2:43 PM : To: CF-Talk : Subject: Help Please: Find/Replace : : : OK I am sure there is an ez way to do this my brain just doesn't : seem to be : working today... : : We have an application where some people may enter URLs they are : requested : to enter them like so : : [http://www.whatever.com] : [http://www.whatever2.com] : [http://www.whatever3.com] : : What i want to be able to do is find each [ ] and take what's in : the middle : of it and wrap it in a a : href=http://www.whatever.com;http://www.whatever.com/a and : remove the [ : ] there may be multiple URLS in the text. I have been messin around with : the find/replace etc. for a bit now and running into some problems. I am : sure i am just doing it wrong. Any suggestions on how to do this right? : : Kelly : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Please: Find/Replace
Kelly Matthews writes: YOU RULE! :) that worked just wonderfully :-) He is an elite RegExp Ninja :) From: Ben Doom [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Help Please: Find/Replace Date: Thu, 23 Jan 2003 14:54:43 -0500 This sounds like a job for (da da da-dh) RegEx! You want something along the lines of string = rereplace(string, '\[([^]]+)\]', 'a href=\1\1/a', 'all'); I /think/ this will work. I've not tested it and whatnot. Working with brackets and other special characters always adds a bit of adventure to it. :-) HTH. And, of course, if you need more help or more in-depth commentary, jump on over to CF-RegEx (available via the [http://www.houseoffusion.com] website). Good luck. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 2:43 PM : To: CF-Talk : Subject: Help Please: Find/Replace : : : OK I am sure there is an ez way to do this my brain just doesn't : seem to be : working today... : : We have an application where some people may enter URLs they are : requested : to enter them like so : : [http://www.whatever.com] : [http://www.whatever2.com] : [http://www.whatever3.com] : : What i want to be able to do is find each [ ] and take what's in : the middle : of it and wrap it in a a : href=http://www.whatever.com;http://www.whatever.com/a and : remove the [ : ] there may be multiple URLS in the text. I have been messin around with : the find/replace etc. for a bit now and running into some problems. I am : sure i am just doing it wrong. Any suggestions on how to do this right? : : Kelly : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
To take a page from Raymond Camden: -- Ben Doom Regular Expression Jedi Apprentice Moonbow Software, Inc :-) Come, Padwans from across the globe, go on a pilgramage to the source of all things CF-RegEx: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=21 There, we have faced the Dark Side and have always been victorious. Bring us your frustrations, and we shall defeat them, for frustration leads to hate, hate leads to pain, pain leads to using ASP, and that way lies the Dark Side. :-) : -Original Message- : From: charlie griefer [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 3:27 PM : To: CF-Talk : Subject: Re: Help Please: Find/Replace : : : Kelly Matthews writes: : : YOU RULE! :) that worked just wonderfully :-) : : He is an elite RegExp Ninja :) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help please!
Ryan a couple of things, are you locking the cfpop code where you are reading Session vars or move them to the request scope if you do not want to lock them and secondly what do you get if you cfdump the query recordset prior to the Query of a Query? Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:44 AM To: CF-Talk Subject: Help please! I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Help please!
Is there a reason you're sorting by UID? Why not use Date or MessageNumber instead? Maybe that will clear up the problem. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:44 PM To: CF-Talk Subject: Help please! I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Help please!
Do I need to lock them (don¹t know much about this!)? I've fixed the problem, it was as easy as a space left out.. Oops I should have checked! thanks anyways. On another note, how do you return whether the email has an attachment or not? I've tried using isDefined() and also if attachement is not '' but to no avail!! Ryan On 9/12/02 20:03, Mike Brunt [EMAIL PROTECTED] wrote: Ryan a couple of things, are you locking the cfpop code where you are reading Session vars or move them to the request scope if you do not want to lock them and secondly what do you get if you cfdump the query recordset prior to the Query of a Query? Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:44 AM To: CF-Talk Subject: Help please! I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Help please!
Ryan, glad to see you found that problem and yes to answer your question you need to lock all Writing and Reading of Application, Server and Session variables otherwise eventually you will experience problems and they will unexpected, unpredictable and very debilitating. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:48 PM To: CF-Talk Subject: Re: Help please! Do I need to lock them (don¹t know much about this!)? I've fixed the problem, it was as easy as a space left out.. Oops I should have checked! thanks anyways. On another note, how do you return whether the email has an attachment or not? I've tried using isDefined() and also if attachement is not '' but to no avail!! Ryan On 9/12/02 20:03, Mike Brunt [EMAIL PROTECTED] wrote: Ryan a couple of things, are you locking the cfpop code where you are reading Session vars or move them to the request scope if you do not want to lock them and secondly what do you get if you cfdump the query recordset prior to the Query of a Query? Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:44 AM To: CF-Talk Subject: Help please! I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Help please!! - Adding Email Alert functionality to a site
Check CF Dev Exchange for Infinite List Server - simple yet great product ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 2:06 PM To: CF-Talk Subject: Help please!! - Adding Email Alert functionality to a site We've been asked to add email alert functionality to a clients web site. The client is a recruitment company and wants to maintain a list of prospective candidates that can be automatically alerted when the company has new job openings. The clients wants to be able to manually add / remove names to the email list and to enable new job seekers to add themselves or modify their settings through their web site. The settings will be quite simple, a new job seeker can specify to receive alerts for 1) Software development jobs 2) Management jobs 3) all jobs When the recruitment company has a new job requirement they will type it up, assign it to a category, and then have an option to send it out to all the prospective job seekers who have requested for alerts in that category. Before the emails are sent out the company wants a list of all the recipients so that they can manually delete or add people from the list before the mailing is kicked off. I realize this is a simple project and there are numerous ways to get this done. What I'm looking are suggestions on how to get this done very quickly ( 2 week time line) I also want to know if there is an existing product we can buy which with some customization can achieve this for us. Would love to receive recommendations, suggestions or even proposals if you have a fast solution. Thanks. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help Please - Having trouble with cferror
My understanding is that you can't use cf code at all in an error template. You have access to a few vars. You can use mailto in cferror to send an e-mail on error. You can use CF code in a cfcatch if you trap your error that way. David Schmidt [EMAIL PROTECTED] 05/23/02 02:52PM Hey all, I'm having a bit of a brain fart here. I want to have a particular site send the details of the error message when a message occurs. The plan I have is this, but it doesn't seem to be working. \root\Application.cfm (contains a cferror tag, type=exception mailto=myemailaddr template=errors/errorhandler.cfm ...) \root\errors\Application.cfm (just holds a comment); \root\errors\errorhandler.cfm (contains code to loop over the error object if it exists, putting the messages in a cfmail tag) I've been able to use cf code in an error template before (think I was tinkering with it some time ago, can't find the code). Anyone have an idea on what I might be missing? Thanks All David __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help Please - Having trouble with cferror
Your code is most likely throwing an exception error, after which no CFML can be processed. There are multiple error types which may be thrown (exception, request, monitor and some other I can't remember). Though you did not say it, I bet your cfmail tag is getting processed some times (like when a request error is thrown), leading you to believe the code in the error template is buggy. Use multiple error handling templates (in your application.cfm), something like this: cfparam name=ExceptionHandling default=1 cfif ExceptionHandling eq 1 cferror type=request template=errorrequest.cfm mailto=#variables.ErrorEmail# cferror type=exception template=errorexception.cfm mailto=#variables.ErrorEmail# /cfif Forta's CF5 WACK book covers this in detail- HTH. -Craig __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help Please - Having trouble with cferror
This WAS true with earlier versions, but the error page is MUCH more robust now, starting with V 4.5 I think. Are you trying to make it work with a V 4.0 CF Server? On 5/24/02 11:55 AM, BEN MORRIS [EMAIL PROTECTED] wrote: My understanding is that you can't use cf code at all in an error template. You have access to a few vars. You can use mailto in cferror to send an e-mail on error. You can use CF code in a cfcatch if you trap your error that way. David Schmidt [EMAIL PROTECTED] 05/23/02 02:52PM Hey all, I'm having a bit of a brain fart here. I want to have a particular site send the details of the error message when a message occurs. The plan I have is this, but it doesn't seem to be working. \root\Application.cfm (contains a cferror tag, type=exception mailto=myemailaddr template=errors/errorhandler.cfm ...) \root\errors\Application.cfm (just holds a comment); \root\errors\errorhandler.cfm (contains code to loop over the error object if it exists, putting the messages in a cfmail tag) I've been able to use cf code in an error template before (think I was tinkering with it some time ago, can't find the code). Anyone have an idea on what I might be missing? Thanks All David __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help Please - Having trouble with cferror
My understanding is that you can't use cf code at all in an error template. You have access to a few vars. You can use mailto in cferror to send an e-mail on error. You can use CF code in a cfcatch if you trap your error that way. This is only true if you use TYPE=REQUEST or TYPE=VALIDATION within your CFERROR tag. If you use TYPE=EXCEPTION, your CFERROR page can have whatever CFML code you like within it. You can also use whatever code you like within your site-wide error handler page. It's a good idea not to do anything too complex in there, though, as you may cause an error within your error handler, which defeats the purpose of an error handler - the end user would see the regular CF error page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help Please - Having trouble with cferror
Your code is most likely throwing an exception error, after which no CFML can be processed. There are multiple error types which may be thrown (exception, request, monitor and some other I can't remember). Though you did not say it, I bet your cfmail tag is getting processed some times (like when a request error is thrown), leading you to believe the code in the error template is buggy. Sorry, I wrote that wrong, reverse 'exception' and 'request'.I meant to write: Your code is most likely throwing a request error, after which no CFML can be processed. There are multiple error types which may be thrown (exception, request, monitor and validation). Though you did not say it, I bet your cfmail tag is getting processed some times (like when a exception error is thrown), leading you to believe the code in the error template is buggy. -Craig (I'm glad it's Friday afternoon). __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help please
If sales id is a text value then you will need to quote session.procces_id WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = '#session.PROCESS_ID#' ) ^single quotes^ - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 18, 2001 1:17 AM Subject: Help please I've run into real strife with this - can anyone help please. Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = #session.PROCESS_ID#) /CFQUERY ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help please
you need to do a text compare. WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = '#session.PROCESS_ID#') notice the tick marks. christopher olive, cio cresco technologies, inc http://www.crescotech.com -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 3:17 AM To: CF-Talk Subject: Help please I've run into real strife with this - can anyone help please. Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID= #session.PROCESS_ID#) /CFQUERY ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help please
If Sales.Process_ID is a text field in your Access Database, it should be enclosed in single quotes on the query. IE - CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID= '#session.PROCESS_ID#') /CFQUERY - Jay -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 3:17 AM To: CF-Talk Subject: Help please I've run into real strife with this - can anyone help please. Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID= #session.PROCESS_ID#) /CFQUERY ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help please
you need to be doing a text compare if it is stored as text, ie. Sales.PROCESS_ID = '#session.PROCESS_ID#' Also, you probably shouldn't use session variables in your query, bc you should be locking ALL accesses to session variables. -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 2:17 AM To: CF-Talk Subject: Help please I've run into real strife with this - can anyone help please. Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = #session.PROCESS_ID#) /CFQUERY ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help please
If it is text in the database you have to put quotes around it. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 18, 2001 3:17 AM Subject: Help please I've run into real strife with this - can anyone help please. Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = #session.PROCESS_ID#) /CFQUERY ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help please
Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = #session.PROCESS_ID#) /CFQUERY Unless I'm missing something, it seems to me like you want to treat PROCESS_ID as a string in any case, if it has to be exactly twenty digits. Can't you just put quotes in your CFQUERY around Session.PROCESS_ID? AND (Sales.PROCESS_ID = '#Session.PROCESS_ID#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help please
Personally, my advice is to learn everything. That way you can go one way or the other. Makes you available for multiple jobs, as well as some places that need multiple skills. At this point and time, most of the work appears to be in ASP, and there's a healthy chunk of Perl out there. Though you don't wait until you need to a job to learn these skills; it's hard to learn enough fast enough. Always think forwards. "Suggest a way out"? McDonald's is always hiring. :) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Venkata Ramakrishna wrote: Hi gang, Iam a Cf guy since 1.5 years.I changed my company expecting a assignment in US.As the market slowed down there,my new employer is making me sit at his place. The problem is that he don't have any CF work and the other teams wont allow me inside their domain. Should i stick with CF or change to some other domain?Whats the trend at US? Can someone suggest a way out until the US markets gear up again? Expecting some serious suggestions. Thank you. Ramakrishna ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help please
Dont just stick to Web based tools, get to grips with conventional programming languages as well, such as VB, C++, JAVA. and others. Even if its just a matter of installing a standard edition of the software and getting to grips with the syntax and format and quirks of the language. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 15:33 To: CF-Talk Subject: Re: Help please Personally, my advice is to learn everything. That way you can go one way or the other. Makes you available for multiple jobs, as well as some places that need multiple skills. At this point and time, most of the work appears to be in ASP, and there's a healthy chunk of Perl out there. Though you don't wait until you need to a job to learn these skills; it's hard to learn enough fast enough. Always think forwards. "Suggest a way out"? McDonald's is always hiring. :) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Venkata Ramakrishna wrote: Hi gang, Iam a Cf guy since 1.5 years.I changed my company expecting a assignment in US.As the market slowed down there,my new employer is making me sit at his place. The problem is that he don't have any CF work and the other teams wont allow me inside their domain. Should i stick with CF or change to some other domain?Whats the trend at US? Can someone suggest a way out until the US markets gear up again? Expecting some serious suggestions. Thank you. Ramakrishna ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HELP PLEASE! MS Access Trim Statement
#ListGetAt('[EMAIL PROTECTED]', 2, "@")#
Todd Ashworth --
Web Application Developer
Network Administrator
Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Troy M. Wussow" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:28 PM
Subject: OT: HELP PLEASE! MS Access Trim Statement
| I am trying to separate an e-mail address from the domain - everything to
| the right of the "@" symbol. I have 2 database fields named [Email] and
| [Domain] and I am trying to use either a MID or TRIM statement to copy
just
| the domain information into the [Domain] Field.
|
| Any suggestions would be greatly appreciated!!!
|
| Troy Wussow
| Web Developer - MIS
| National Seminars Group
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP PLEASE! MS Access Trim Statement
I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Trim just removes Spaces, nothing else Try; Mid(myEmail,InStr(Email,"@")+1,Len(myEmail)) Note, this will break if there isn't an @ Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP PLEASE! MS Access Trim Statement
Using Cold Fusion to do it, or in MSAccess itself? If Cold Fusion, here's a cool trick: cfset myUser = ListFirst(emailAddress,'@') cfset myDomain = ListLast(emailAddress,'@') I love using this :) Jeff Beer Senior Programmer Architect Hydrogen Media, Inc (727) 530-5500 x303 [EMAIL PROTECTED] -Original Message- From: Troy M. Wussow [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:28 PM To: CF-Talk Subject: OT: HELP PLEASE! MS Access Trim Statement I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Any suggestions would be greatly appreciated!!! Troy Wussow Web Developer - MIS National Seminars Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP PLEASE! MS Access Trim Statement
See page 1023 of SYBEX's "Mastering Cold Fusion" book for list of SQL functions and the databases they work with: Concatenate the following functions into a SQL statement with an AS statement and it should work... mLEN = Length(trim(str1)) -- returns the length of the trimed str1 which you can store in mAT = Instr(str1, str2) returns the numerical position in str1 where str2 begins. mKEEP = Right(TRIM(str1), mLEN - mAT) ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Troy M. Wussow [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:28 PM To: CF-Talk Subject:OT: HELP PLEASE! MS Access Trim Statement I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Any suggestions would be greatly appreciated!!! Troy Wussow Web Developer - MIS National Seminars Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help - Please
I've found SQL very case-sensitive is SKYFOCUS really skyfocus or SkyFocus. Because you hav asked to access an unknown database it may give a general login failure. I'm not sure as I haven't used MySQL before. Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Help - Please
I am not totally certain, but remove the [skyfocus.] that appears in your
WHERE statement of the first Query.
The query already knows that it is pulling from [skyfocus.] if your
datasource {focusadmin} is already pointing to [skyfocus.]
Hope this helps.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-Original Message-
From: Tony Turner -CFUG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 10:08 AM
To: CF-Talk
Subject: Help - Please
Hi
I have a question:
We have a customer who is going mad as he gets and error whe he runs two
types or queries.
I never do what he is trying to do and don't understand why?
Queries as below:
They both appear to have the same datasource name (fine) but then the first
explicitly
defines the database. (FROM SKYFOCUS.CC_DATA)
The database is MySQL 3.22.32 and the database in ColdFusion and MySQL both
have the same username and password on and localhost access in MySQL. The
database is called skyfocus in MySQL.
Should you be able to call a connection like this in test1 in this manner.
http://www.hotchilli.com/test1_tony.cfm --
Errors
cfquery name="GOT_CC" datasource="focusadmin"
SELECT CD_CC_NAME, CD_CC_ID, CD_CC_MSO_ID
FROM SKYFOCUS.CC_DATA
/CFQUERY
http://www.hotchilli.com/test2_tony.cfm--
No Error (would expect a blank page)
CFQUERY NAME="MSO" DATASOURCE="focusadmin"
SELECT md_mso_name
FROM mso_data
/CFQUERY
Please - Please if this is standard practice could someone point me to some
documentation on the Allaire site. I would in perl or php3/4 explicitly
define the database in the connection/query but ColdFusion? Whats the
benefit?
Thanks
Tony
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Help - Please
I've found SQL very case-sensitive is SKYFOCUS really skyfocus or SkyFocus. Because you hav asked to access an unknown database it may give a general login failure. I'm not sure as I haven't used MySQL before. I missed the first part of this discussion, and this may have already been covered, but most RDBMS will offer you the option of case sensitivity. Duane Boudreau Director of Web Techologies Ektron, Inc. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Help please with Date Parameter error message
Your value of July is OK, and your value of 2000 is OK, but your date value of 8-9 must be a single date such as 8 or 9 I used #articledate# = July 8, 2000 and your #Dateformat(articledate,"dd/mm/yy")# returns 08/07/00 But if you try and input two days at once it errors. Hope this helps H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 19, 1998 10:08 AM To: [EMAIL PROTECTED] Subject: Help please with Date Parameter error message This is a multi-part message in MIME format. --=_NextPart_000_000D_01BDCBD6.FBDDD120 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit when i look at cf generated output from a table on the isp's server i get the follwoing error message however if i view the same output locally on my computer through cf i do not get such a error message any ideas Parameter 1 of function DateFormat which is now "July 8-9,2000" must be a date/time value The error occurred while evaluating the expression: #Dateformat(articledate,"dd/mm/yy")# The error occurred while processing an element with a general identifier of (#Dateformat(articledate,"dd/mm/yy")#), occupying document position (16:121) to (16:156) in the template file D:\www\austaccom\citiecentre\citiecentresearchresults.cfm Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] --=_NextPart_000_000D_01BDCBD6.FBDDD120 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2 Pwhen i look at cf generated output from a table on the isp's server i = get the=20 follwoing error message however if i view the same output locally on my = computer=20 through cf i do not get such a error message any ideasnbsp; Pnbsp; PParameter 1 of function DateFormat which is now "July 8-9,2000" must = be a=20 date/time value=20 PThe error occurred while evaluating the expression:=20 PPRE#Dateformat(articledate,"dd/mm/yy")# /PRE P/P P/P P PThe error occurred while processing an element with a general = identifier of=20 (#Dateformat(articledate,"dd/mm/yy")#), occupying document position = (16:121) to=20 (16:156) in the template file=20 D:\www\austaccom\citiecentre\citiecentresearchresults.cfm/P/FONT/DIV= DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kind Regards/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Claude Raiola=20 (Director)BRAustralianAccommodation.com Pty. Ltd.BRWebsite: A=20 href=3D"http://www.AustralianAccommodation.com"www.AustralianAccommodati= on.com/ABREmail:=20 A=20 href=3D"mailto:[EMAIL PROTECTED]"Director@AustralianA= ccommodation.com/A/FONT/DIV/BODY/HTML --=_NextPart_000_000D_01BDCBD6.FBDDD120-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help please with Date Parameter error message
In order for the CF dateformat function to work you must have a valid date argument either created from the database or using another CF date function to create the date (i.e. CreateODBCDate() ). Sincerely, Shane Witbeck Webmaster mailto:[EMAIL PROTECTED] www.digitalsanctum.com -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 19, 1998 11:08 AM To: [EMAIL PROTECTED] Subject: Help please with Date Parameter error message This is a multi-part message in MIME format. --=_NextPart_000_000D_01BDCBD6.FBDDD120 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit when i look at cf generated output from a table on the isp's server i get the follwoing error message however if i view the same output locally on my computer through cf i do not get such a error message any ideas Parameter 1 of function DateFormat which is now "July 8-9,2000" must be a date/time value The error occurred while evaluating the expression: #Dateformat(articledate,"dd/mm/yy")# The error occurred while processing an element with a general identifier of (#Dateformat(articledate,"dd/mm/yy")#), occupying document position (16:121) to (16:156) in the template file D:\www\austaccom\citiecentre\citiecentresearchresults.cfm Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] --=_NextPart_000_000D_01BDCBD6.FBDDD120 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2 Pwhen i look at cf generated output from a table on the isp's server i = get the=20 follwoing error message however if i view the same output locally on my = computer=20 through cf i do not get such a error message any ideasnbsp; Pnbsp; PParameter 1 of function DateFormat which is now "July 8-9,2000" must = be a=20 date/time value=20 PThe error occurred while evaluating the expression:=20 PPRE#Dateformat(articledate,"dd/mm/yy")# /PRE P/P P/P P PThe error occurred while processing an element with a general = identifier of=20 (#Dateformat(articledate,"dd/mm/yy")#), occupying document position = (16:121) to=20 (16:156) in the template file=20 D:\www\austaccom\citiecentre\citiecentresearchresults.cfm/P/FONT/DIV= DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kind Regards/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Claude Raiola=20 (Director)BRAustralianAccommodation.com Pty. Ltd.BRWebsite: A=20 href=3D"http://www.AustralianAccommodation.com"www.AustralianAccommodati= on.com/ABREmail:=20 A=20 href=3D"mailto:[EMAIL PROTECTED]"Director@AustralianA= ccommodation.com/A/FONT/DIV/BODY/HTML --=_NextPart_000_000D_01BDCBD6.FBDDD120-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help please checking my poll works correctly ....
- Original Message - From: Deanna L. Schneider [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 03 April 2000 14:30 Subject: Re: Help please checking my poll works correctly Hiya Michael, I voted three times. No error message. No polite message. Apparently it accepted my vote three times. Haven't been following this thread too closely - but are you using cookies to ensure only one vote per remote PC? You need to set the cookie value for a length of time greater than the poll is online for. Adrian Cooper. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help please checking my poll works correctly ....
I voted 5 few times, and it seemed to accept my vote.. the vote counter went up by one each time. At least no error messages! Also - you may be better off using a regular form instead of cfform. Even with a high speed cable modem, it took a lot of time to download the java .. on a slow dial up connection, people may just quit. Sometimes it is worth it, but for simple radio buttons, why bother? Al Hiya Michael, I voted three times. No error message. No polite message. Apparently it accepted my vote three times. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help please checking my poll works correctly ....
actuall i disabled cookies and got the error. so the error might be happening to only those who don't accept cookies Quinn - Original Message - From: Michael Kear [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 02, 2000 9:29 PM Subject: Help please checking my poll works correctly This is not a troll for traffic through my poll, but I'd be grateful if some of you could check my poll works correctly please. We've been having intermittent problems with the routine to check if you've voted today or not. It's supposed to look to see if you've registered a vote today, and if so, politely deny you another vote. (but politely, showing you the results to date) But from some computers, we've found that it shows an error message instead, hiccupping and refusing to display the required page. I'm trying to work out what's happening, but from all my computers the poll works correctly. Therefore I can't reproduce the problem. And therefore also, I dont know for sure if I've fixed the problem. The poll is at http://www.choice.com.au/calculators/poll_merger1.cfm Please vote, then vote a second time. If all's working well, the second time you should get a polite message saying we've already registered a vote from you today and here's the results anyway. If you get an error, please let me know what kind of OS you're using, browser type, and when you voted. And if you can, cut and paste the error into your reply. Thanks in advance for your help everyone :) Cheers, Mike Kear AFP Web Development Windsor, NSW, Australia http://www.afp.zip.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help please checking my poll works correctly ....
also here is the error that i got:
Error Occurred While Processing Request
Error Diagnostic Information
Parameter 2 of function DateDiff which is now "" must be a date/time value
The error occurred while evaluating the expression:
(datediff("y", testvoter.latestvote ,now()) is '0')
The error occurred while processing an element with a general identifier of
(CFIF), occupying document position (19:2) to (19:60).
Date/Time: 04/03/00 15:41:23
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 209.191.127.143
HTTP Referer: http://www.choice.com.au/calculators/poll_merger1.cfm
Template: D:\CFCalcs\poll_merger2.cfm
- Original Message -
From: Michael Kear [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 02, 2000 9:29 PM
Subject: Help please checking my poll works correctly
This is not a troll for traffic through my poll, but I'd be grateful if
some of you could check my poll works correctly please.
We've been having intermittent problems with the routine to check if
you've voted today or not. It's supposed to look to see if you've
registered a vote today, and if so, politely deny you another vote. (but
politely, showing you the results to date)
But from some computers, we've found that it shows an error message
instead, hiccupping and refusing to display the required page.
I'm trying to work out what's happening, but from all my computers the
poll works correctly. Therefore I can't reproduce the problem. And
therefore also, I dont know for sure if I've fixed the problem.
The poll is at http://www.choice.com.au/calculators/poll_merger1.cfm
Please vote, then vote a second time. If all's working well, the second
time you should get a polite message saying we've already registered a
vote from you today and here's the results anyway.
If you get an error, please let me know what kind of OS you're using,
browser type, and when you voted. And if you can, cut and paste the
error into your reply.
Thanks in advance for your help everyone :)
Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia
http://www.afp.zip.com.au
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
