Re: Dreamweaver - split document
Using F10, you can the Code Inspector as a seperate window showing the same document. You can then dock that window underneat, above or beside your code view and there you are! Thanks, Calvin - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Tuesday, February 24, 2004 4:20 AM Subject: RE: Dreamweaver - split document It doesnt exists in DWMX2004 AFAIK. N _ From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 22:47 To: CF-Talk Subject: Dreamweaver - split document Does anybody know how to get DW to split a document the way HomeSite does? I really miss that feature. Walt _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dreamweaver - split document
As I said...its doesnt exist as function.Thats a workaround ;-) _ From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 10:36 To: CF-Talk Subject: Re: Dreamweaver - split document Using F10, you can the Code Inspector as a seperate window showing the same document. You can then dock that window underneat, above or beside your code view and there you are! Thanks, Calvin - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Tuesday, February 24, 2004 4:20 AM Subject: RE: Dreamweaver - split document It doesnt exists in DWMX2004 AFAIK. N _ From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 22:47 To: CF-Talk Subject: Dreamweaver - split document Does anybody know how to get DW to split a document the way HomeSite does? I really miss that feature. Walt _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Is the word type a reserved word in CFMX
Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 124 122 : CFPARAM name=form.type default=t 123 : CFPARAM name=form.compid default=#gc.id# 124 : CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid 125 :/CFIF 126 :CFIF ParameterExists(sta) eq 'true' [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL
Thanks, I discovered that as well shortly after my post.. Works well so far. Yves On Mon, 23 Feb 2004 16:35:53 -0500, Pete Freitag [EMAIL PROTECTED] wrote: Yves Arsenault wrote: I entered the username and password that I created. I got an error.. (sorry didn't write it down), it couldn't connect to the DB. make sure you have the postmaster service running with the -i option to allow incomming TCP connections, they are turned off by default on PostgreSQL for security reasons. __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is the word type a reserved word in CFMX
From: Steven Sharko Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. That's a database error, not a CF error It's a reserved word in Access [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
total newbe question
Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid At 08:36 AM 2/25/2004, you wrote: From: Steven Sharko Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. That's a database error, not a CF error It's a reserved word in Access -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: total newbe question
Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid A nice place to start with SQL: http://www.w3schools.com/sql/default.asp Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: total newbe question
Massimo, You are the Dreamweaver Guru!I can not help if I have never written a insert statement.I was just looking for a quick example using CF.You still write all those tags for MM Dreamweaver.Last time I went to the extension board it did not appear you were still doing that. I was just looking for an example.i guess I will open the book.Hum now where is my MasterCF book? At 08:55 AM 2/25/2004, you wrote: Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid A nice place to start with SQL: http://www.w3schools.com/sql/default.asp Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: total newbe question
basically cfquery datasource=blah insert into clntnote (thisdate,subject,note,type,compid) values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) /cfquery You will need to debug it of course. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 7:54 AM To: CF-Talk Subject: total newbe question Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid At 08:36 AM 2/25/2004, you wrote: From: Steven Sharko Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. That's a database error, not a CF error It's a reserved word in Access -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: total newbe question
cfquery name=myQuery datasource=#application.db# SELECT thisdate,subject,note,type,compid FROM clntnote /cfquery - Original Message - From: Steven Sharko To: CF-Talk Sent: Wednesday, February 25, 2004 8:53 AM Subject: total newbe question Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid At 08:36 AM 2/25/2004, you wrote: From: Steven Sharko Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. That's a database error, not a CF error It's a reserved word in Access -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
problems accessing variables with components
We have built a content site using components.The site tested fine in development, but has been acting peculiar under load.This site is broken down into roughly 12 markets, and each market has it's own content that we deliver to the user.We have a market component that stores all the information in an array on each market.This array is hidden in the cfc and we perform a get routine to deliver the array when necessary.We randomly get these errors that the market array is undefined, yet when we access the site it works fine.Additionally, we check our cfc's (through an admin tool) and the array is there.Any ideas on why this may happen?Do we need to lock the get routine? Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: total newbe question
I was just looking for a quick example using CF.You still write all those tags for MM Dreamweaver.Last time I went to the extension board it did not appear you were still doing that. I still develop DW extensions, but most of them are for internal/personal use only. If you would like to check what's available, better to go on my website instead than MM's Exchange (the same is true for many extension developers out there) Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: total newbe question
Sorry about that, looked very quickly, skipped by the insert.My query would work for a select. From: Michael Hodgdon To: CF-Talk Sent: Wednesday, February 25, 2004 9:10 AM Subject: Re: total newbe question cfquery name=myQuery datasource=#application.db# SELECT thisdate,subject,note,type,compid FROM clntnote /cfquery - Original Message - From: Steven Sharko To: CF-Talk Sent: Wednesday, February 25, 2004 8:53 AM Subject: total newbe question Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid At 08:36 AM 2/25/2004, you wrote: From: Steven Sharko Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. That's a database error, not a CF error It's a reserved word in Access -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems accessing variables with components
Are you running CFMX 6 or 6.1? There were some serious issues with CFCs under load in 6 that were fixed in 6.1. Normally these involved queries, not arrays, but if your array is being generated from a query, it could be related. Either way - make sure you have 6.1. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: problems accessing variables with components
We are running version6,1,0,63958 - Original Message - From: Raymond Camden To: CF-Talk Sent: Wednesday, February 25, 2004 9:18 AM Subject: RE: problems accessing variables with components Are you running CFMX 6 or 6.1? There were some serious issues with CFCs under load in 6 that were fixed in 6.1. Normally these involved queries, not arrays, but if your array is being generated from a query, it could be related. Either way - make sure you have 6.1. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Its amazing!
I just want to say that this is the best talk board in the world.Where else can you get such great minds to share with a newbe like me.Ben Forta, Massimo Foti, Dave Watts, Robert Segal, Ray Camden, Steve Sherman, Jeffery Houser, Nate Weiss, Paul Hastings, Nate Popovich, Micheal Smith (tera tech) and Hal Helms. And people wonder why I like this language. Thanks Mark! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems accessing variables with components
Can you share the code then? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is the word type a reserved word in CFMX
122 : CFPARAM name=form.type default=t 123 : CFPARAM name=form.compid default=#gc.id# 124 : CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid 125 :/CFIF Something I keep on saying... Don't use CFINSERT, use a CFQUERY and you can control the name of the fields, as well as the data type (using CFQUERYPARAM) If you surround your field names in square brackets, you can call them whatever you want (including using spaces) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
still having a problem with insert
Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) You'll need to delimit non-numeric values with single quotes: INSERT INTO ... VALUES('#Form.subject#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
You need to put single or double quotes (I can't remember which in access) around string data in the query, so #form.note# should become '#form.note#', or for a better solution, use cfqueryparam cf_sql_type=cf_sql_varchar value=#form.note# for this and all other fields. -- marlon And Bobby you are right, I am being selfish, but the last time I checked, we don't have a whole lot of songs that feature the cowbell! -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDefined(CGI.foo) always returns YES
No problem, I know how it goes 8^). Thanks for the help though. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 6:59 PM To: CF-Talk Subject: RE: IsDefined(CGI.foo) always returns YES Sheesh.I'm readin' through the mail, and obviously missing stuff as I go.Sorry about that... - Jeff On 24 Feb 2004 at 17:06, Mosh Teitelbaum wrote: Jeff: Thanks, that's what I'm using as a work around: As a work around, I'm using StructKeyList() to get a list of variables in the CGI scope, but it's a kludge I'd rather not use. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 4:56 PM To: CF-Talk Subject: RE: IsDefined(CGI.foo) always returns YES Mosh - Take the decision out of CF's hands, so to speak: cfset lstCGIKeys = StructKeyList(cgi) cfoutput#ListFindNoCase(lstCGIKeys, foo)#/cfoutput How's that for an endorsement for ColdFusion Lists, Arrays, and Structures?!;) - Jeff On 24 Feb 2004 at 16:32, Mosh Teitelbaum wrote: Jamie: Thanks but that won't actually work for me.Even though it's suggested in the documentation. I'm trying to test for existence.I don't care if the variable has a value, just whether or not it exists.Some CGI variables are empty, so that test won't work. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 4:15 PM To: CF-Talk Subject: Re: IsDefined(CGI.foo) always returns YES isdefined(cgi.anything) is always true. use len(cgi.anything) instead. On Tue, 24 Feb 2004 15:42:54 -0500, in cf-talk you wrote: All: I ran into something unusual and I've never heard of it before.Through some quick testing, it seems as if trying to determine a variables existence within the CGI scope, whether using IsDefined() or StructKeyExists(), always returns YES.Even if the variable doesn't exist in that scope. So, for example, the following evaluate to YES even if they shouldn't: IsDefined(CGI.foo) StructKeyExists(CGI, foo) Doing a CFDUMP VAR=#CGI# shows that the variable does not exist in the scope. As a work around, I'm using StructKeyList() to get a list of variables in the CGI scope, but it's a kludge I'd rather not use. Has anyone else ever run into this?Know of a way to resolve it? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: still having a problem with insert
Steven, you may need to surrround some of your insert values with single quotes as it seems judging from variable names that they are strings. - Original Message - From: Steven Sharko To: CF-Talk Sent: Wednesday, February 25, 2004 9:37 AM Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: total newbe question
On Wed, 25 Feb 2004 08:14:35 -0600, in cf-talk you wrote: basically cfquery datasource=blah insert into clntnote (thisdate,subject,note,type,compid) values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) /cfquery You will need to debug it of course. -Mark Now that you've seen the simple solution, I'll transition you to the full version. Learn to use cfsqlparam NOW rather than retro-coding later. Look into the docs and DAGS on cfqueryparam. insert into clntnote (thisdate,subject,note,type,compid) values ( cfqueryparam value=#form.thisdate# cfsqltype=CF_SQL_DATE, cfqueryparam value=#form.subject# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#form.note# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#form.type# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#form.compid# cfsqltype=CF_SQL_INTEGER ) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: still having a problem with insert
like ppl keep saying the word type is a reserved word and WONT work u will have 2 rename that field in your database, no ands, ifs or buts about it. read this, straight from the mothership http://www.macromedia.com/support/ultradev/ts/documents/insert_into.htm Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({tsapos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Steven, You need single quotes around all char data... as in '#form.subject#'. You will need to correctly format the date as well. Try using #createodbcdate(form.thisdate)#for that item.Also - as has been suggested a couple of times - using CFQUERYPARAM would be a good idea - faster, and safer - like the promise of mass rail transit. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
I tried that and still got an error. Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\netpacq\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values (apos;{ts apos;2004-02-25 09:49:00apos;}apos;,apos;Service Ticket 3173 - apos;,apos;brSubmitted by apos;,apos;tapos;,) At 09:49 AM 2/25/2004, you wrote: Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) You'll need to delimit non-numeric values with single quotes: INSERT INTO ... VALUES('#Form.subject#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Steven, I would add one more thing. Rather than beat your head agains the wall in CF, get a quick book - the teach yourself SQL in24 hours would do nicely - and use the query analyzer or some other raw tool where you can pass in queries and view results. Take a half a day and learn SELECT , INSERT, UPDATE and possible JOIN - and a few other tricks. Simple SQL is not hard to grasp.It reads pretty easily... you can get what is happening in most queries pretty quickly. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDefined(CGI.foo) always returns YES
Well then I'm confused too because running that exact same code, I get the opposite result: using StructKeyExists(), foo exists in CGI using IsDefined(), foo exists in CGI Running ColdFusion 5.0.0.0 Enterprise. Anyone? -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 6:08 PM To: CF-Talk Subject: RE: IsDefined(CGI.foo) always returns YES So, for example, the following evaluate to YES even if they shouldn't: IsDefined(CGI.foo) StructKeyExists(CGI, foo) Doing a CFDUMP VAR=#CGI# shows that the variable does not exist in the scope. I don't get that behavior.If I run the following: !--- Begin --- cfif StructKeyExists(CGI,foo) using StructKeyExists(), foo exists in CGI cfelse using StructKeyExists(), foo doesn't exist in CGI /cfif brbr cfif IsDefined(CGI.foo) using IsDefined(), foo exists in CGI cfelse using IsDefined(), foo doesn't exist in CGI /cfif !--- End --- I get the following output: using StructKeyExists(), foo doesn't exist in CGI using IsDefined(), foo exists in CGI I am running CFMX 6.1 Enterprise with (I think) all the hotfixes. Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: still having a problem with insert
Yup, that's a mess alright. Looks like your form might be screwy as well, or had some html in a field, or something. Check your form, fix your text field values in the sql (wrap them with single quotes). And once you've done that, don't use that SQL :P Instead, use the cfqueryparam version that I added to your last thread, but adjust the sql types from my assumptions to the real datatypes of your DB's columns. Jamie On Wed, 25 Feb 2004 09:37:57 -0500, in cf-talk you wrote: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
JRun has closed connection
oi CF-Talk,!! We'verecently moved a couple of our applications from CF5 to MX. We are randomly, yet repeatedly gettingJRUNerrorsthatsaytherewasaninternalservererror. and JRUN has closed the connection. A refresh of the page, seems to clear the error sometimes any ideas / suggestions? /critz -- --- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Steven, yes... if you use createodbcdatetime() or createodbcdate() to massage the variable thisdate into something that looks like {ts '2004-02-25 09:49:00'}Then you must REMOVE the single quotes around that one... also, is the column name really thisdate?Remember the name of the column and the name of the variable don't have to match - that's a nuance of cfinsert (and a limitation).The name of the column is dictated by the table. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:50 AM To: CF-Talk Subject: RE: still having a problem with insert I tried that and still got an error. Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\netpacq\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values (apos;{ts apos;2004-02-25 09:49:00apos;}apos;,apos;Service Ticket 3173 - apos;,apos;brSubmitted by apos;,apos;tapos;,) At 09:49 AM 2/25/2004, you wrote: Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) You'll need to delimit non-numeric values with single quotes: INSERT INTO ... VALUES('#Form.subject#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Radio button check
How do I check whether a certain value is checked off on a radio button? The group name is send. The value I want checked is whether it is sendemail. If it is I want an alert to ask that the subject is required. Thx. Robert O. Here is part of what I have so far: if((form.send.value).checked (trim(form.subject.value).length == 0)) { alert(Email subject is required.); return false; [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: problems accessing variables with components
Before I dump all this code on you, I would like to mention that all of this logic works in development.In fact, it also works on the production server just fine.However, every 5 or 10 minutes or so we receive an error message stating sthcpinfo.amarkets from the hcp.cfc component cannot be found.It is on random templates, and does not appear to follow a pattern.The only thing that comes to mind is that under load, either memory becomes unavailable b/s it is being used, or, somehow memory is getting overwritten.Sort of at a loss here. I would like to ask two things: 1) Does anyone know of a good software package / utility for diagnosing load issues? 2) As requested, the code is below, check it out Thank you Okay, so say way run this object called hcp.cfc. !--- COLDFUSION COMPONENT: hcp.cfc --- cfcomponent displayname=hcp extends=main hint=I contain methods that load and access information for the entire hcp.com application. !--- METHOD: initializeObject() --- cffunction name=initializeObject access=public output=no hint=I prepare content, routines, and objects for hcp.com !--- Attempt to run the function code --- cftry !--- Obtain the top-level market topics from the database --- cfinvoke component=#server.database# method=selectTopics prefixFilter=m1 returnvariable=sthcpInfo.aMarkets !--- For each market returned by the database... --- cfloop from=1 to=#ArrayLen(sthcpInfo.aMarkets)# step=1 index=current_market cflock scope=SERVER type=EXCLUSIVE timeout=30 !--- Create a new topic object for this market in server memory--- cfset server.#sthcpInfo.aMarkets[current_market].topic# = CreateObject(component, cf_components.topic) !--- run the initializeObject routine to init this object--- cfset Evaluate(server.#sthcpInfo.aMarkets[current_market].topic#.initializeObject(sthcpInfo.aMarkets[current_market].topic)) /cflock /cfloop !--- If something went wrong with the function code... --- cfcatch type=Any !--- Run the error handling routine --- cfinclude template=/cf_includes/cfcatch.cfm /cfcatch /cftry /cffunction In the above hcp.cfc we have a routine that runs called initializeObject that prepares information to be stored in this object.One piece of info is market information, which we store in an array.hcp.cfc is created like so if the variable server.hcp does not exist (logic is in application.cfm): cfset server.hcp = CreateObject(component, hcp.cfc) cfset server.hcp.initializeObject() Inside this initialization routine it accessed server.database (another cfc created identical in design to hcp.cfc).We are accessing a method called selectTopics.SelectTopics looks like th cffunction name=selectTopics access=public output=no returntype=any hint=I get topic information from the topic table and return it as an array !--- Parameters associated with this method (Function-level variables are prefixed with var_) --- cfargument name=prefixFilter type=stringrequired=No default=0 cfargument name=columnSorter type=anyrequired=No default=topic cfargument name=sortTypetype=anyrequired=No default=ASC !--- Attempt to run the function code --- cftry cfquery name=qQuery datasource=#dsn# SELECTcol1, col2 FROMtable 1 LEFT JOIN table2 ON (table1.col1 = table2.col2 cfif arguments.prefixFilter NEQ 0 WHEREtable1.col1 LIKE '#arguments.prefixFilter#%' /cfif ANDLeft(table1.col4, 2) '99' ORDER BYtable1.#arguments.columnSorter# #arguments.sortType# /cfquery !--- return the information to the requester as an array of structures--- cfreturn qQuery !--- catch any errors that could have happened.--- cfcatch type=Any !--- Run the error handling routine --- cfinclude template=/cf_includes/cfcatch.cfm /cfcatch /cftry /cffunction we access this information using a get routine called getMarkets !--- Get the market list from the hcp.object --- cfset variables.aMarketList = server.hcp.getMarkets() getRoutine looks like this: cffunction name=getMarkets output=no access=public returntype=any hint=I get all market information and return it as an array !--- Attempt to run the function code --- cftry !--- return headlines --- cfreturn stHCPInfo.aMarkets !--- If something went wrong with the function code... --- cfcatch !--- Run the error handling routine --- cfinclude template=/cf_includes/cfcatch.cfm /cfcatch /cftry /cffunction - Original Message - From: Raymond Camden To: CF-Talk Sent: Wednesday, February 25, 2004 9:26 AM Subject: RE: problems accessing variables with components Can you share the code then? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRun has closed connection
depends on what the server is doing at the time... We get this quite a bit on a site where we are using cfx tags to do image manipulation and pop mail access, it usually happens on the pop mail access... the only thing to do is cycle the server (as it doesnt raise an event in the services panel so that it would cycle automatically) and check the mail box for any dodgy looking emails HTH -Original Message- From: Critter [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 14:54 To: CF-Talk Subject: JRun has closed connection oi CF-Talk,!! We'verecently moved a couple of our applications from CF5 to MX. We are randomly, yet repeatedly gettingJRUNerrorsthatsaytherewasaninternalservererror. and JRUN has closed the connection. A refresh of the page, seems to clear the error sometimes any ideas / suggestions? /critz -- --- [This E-mail scanned for viruses by Declude Virus] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Radio button check
-Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:56 AM To: CF-Talk Subject: OT: Radio button check How do I check whether a certain value is checked off on a radio button? The group name is send. The value I want checked is whether it is sendemail. If it is I want an alert to ask that the subject is required. I usually do something like this.Since radio buttons don't have the selectedIndex property, you have to look through the group to find out what was selected. var val; for (var x = 0; x formname.send.length; x++) { if (formname.send[x].checked) { val = formname.send[x].value; break; } } if (val == 'sendemail') alert('please provide a subject'); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems accessing variables with components
Please see my comments in the code below. !--- COLDFUSION COMPONENT: hcp.cfc --- cfcomponent displayname=hcp extends=main hint=I contain methods that load and access information for the entire hcp.com application. !--- METHOD: initializeObject() --- cffunction name=initializeObject access=public output=no hint=I prepare content, routines, and objects for hcp.com !--- Attempt to run the function code --- cftry !--- Obtain the top-level market topics from the database --- cfinvoke component=#server.database# method=selectTopics prefixFilter=m1 returnvariable=sthcpInfo.aMarkets First problem. Your method creates a variable called sthcpInfo.aMarkets. If this variable is only meant to last for the execution of this method, you should var scope it. Also, I'd called it bad practice to have cfinvoke return a variable named x.y. Yes, CF will automatically create a structure and member for you, but you should really just return the variable as aMarkets or something else. Assuming you return it as aMarkets, you should add cfset var aMarkets = at the top of your cffunction call. Ditto for any other variable you create, like current_market. Not var scoping your variables can defintely lead to issues under load. !--- For each market returned by the database... --- cfloop from=1 to=#ArrayLen(sthcpInfo.aMarkets)# step=1 index=current_market cflock scope=SERVER type=EXCLUSIVE timeout=30 !--- Create a new topic object for this market in server memory--- cfset server.#sthcpInfo.aMarkets[current_market].topic# = CreateObject(component, cf_components.topic) Why do you do this? You are already storing the CFC itself in server memory - why not store these values in the CFC itself - in the Variables scope. Then the values will exist as long as the CFC itself exists. !--- run the initializeObject routine to init this object--- cfset Evaluate(server.#sthcpInfo.aMarkets[current_market].topic#.in itializeObject(sthcpInfo.aMarkets[current_market].topic)) Not that it matters, but you don't need to use evaluate here. I'd change it to cfset server[sthcpinfo.amarkets[current_market]].topic.initializeObject() Again though, I'd move this stuff out of the server scope anyway. Thats all for now - I'd defintely add the var scoping. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
A trick I used in the my youth to help me learn: Since you are using Access, use the query builder in Access to build the query, then change the view to SQL view and copy the SQL code from there and paste into your Cold Fusion cfquery... tag.A few simple modifications to incorporate the form variables and you should be good to go. HTH, helped me a lot in the early days. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: freelancer
cf folks, A friend of mine (a designer) is working on a job site and needs a contractor. It's not the sort of project that we are interested in at the moment :)It's a job site - searches, job candidates and employers... subscription based I believe. I have no idea of the budget or anything else about it.If any of you have any interest let me know and I will get you in contact with her. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRun has closed connection
It seems to be caused by different things for different people.For us, it was the use of getPageContext.forward() although getPageContext.include() works fine. Walt -Original Message- From: Critter [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:54 AM To: CF-Talk Subject: JRun has closed connection oi CF-Talk,!! We'verecently moved a couple of our applications from CF5 to MX. We are randomly, yet repeatedly gettingJRUNerrorsthatsaytherewasaninternalservererror. and JRUN has closed the connection. A refresh of the page, seems to clear the error sometimes any ideas / suggestions? /critz -- --- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: problems accessing variables with components
Thanks Ray, I have made some additional comments to yours.Hope you get a chance to look again Michael S Hodgdon Web Development Project Manager 617 - 669 - 7183 [EMAIL PROTECTED] - Original Message - From: Raymond Camden To: CF-Talk Sent: Wednesday, February 25, 2004 10:14 AM Subject: RE: problems accessing variables with components Please see my comments in the code below. !--- COLDFUSION COMPONENT: hcp.cfc --- cfcomponent displayname=hcp extends=main hint=I contain methods that load and access information for the entire hcp.com application. !--- METHOD: initializeObject() --- cffunction name=initializeObject access=public output=no hint=I prepare content, routines, and objects for hcp.com !--- Attempt to run the function code --- cftry !--- Obtain the top-level market topics from the database --- cfinvoke component=#server.database# method=selectTopics prefixFilter=m1 returnvariable=sthcpInfo.aMarkets First problem. Your method creates a variable called sthcpInfo.aMarkets. If this variable is only meant to last for the execution of this method, you should var scope it. Also, I'd called it bad practice to have cfinvoke return a variable named x.y. Yes, CF will automatically create a structure and member for you, but you should really just return the variable as aMarkets or something else. Assuming you return it as aMarkets, you should add cfset var aMarkets = at the top of your cffunction call. Ditto for any other variable you create, like current_market. Not var scoping your variables can defintely lead to issues under load. {Michae Hodgdon} - These values are indeed persistant.This information rarely changes, so rather than make constant database hits, we are keeping the aMarkets array in a structure called sthcpInfo.stHcpinfo also holds other persistant information that we would like to keep persistance.So essentially, this information is designed to be read only, and set in memory only on initialization of this object.Access is received through the getRoutines that we have set. !--- For each market returned by the database... --- cfloop from=1 to=#ArrayLen(sthcpInfo.aMarkets)# step=1 index=current_market cflock scope=SERVER type=EXCLUSIVE timeout=30 !--- Create a new topic object for this market in server memory--- cfset server.#sthcpInfo.aMarkets[current_market].topic# = CreateObject(component, cf_components.topic) Why do you do this? You are already storing the CFC itself in server memory - why not store these values in the CFC itself - in the Variables scope. Then the values will exist as long as the CFC itself exists. {Michael Hodgdon} - Each market has many routines that it runs as well personal information about that market.So we are using the topic cfc as a blueprint, and then we create an object for each market using that blueprint.For easy access, we reference the aMarkets cfc to output all the markets we have (for instance, on the home page our markets are ).When you are on a market page itself, we access that markets objects to return more detailed and rich information. !--- run the initializeObject routine to init this object--- cfset Evaluate(server.#sthcpInfo.aMarkets[current_market].topic#.in itializeObject(sthcpInfo.aMarkets[current_market].topic)) Not that it matters, but you don't need to use evaluate here. I'd change it to {Michael Hodgdon} - Good point, noted ;-) cfset server[sthcpinfo.amarkets[current_market]].topic.initializeObject() Again though, I'd move this stuff out of the server scope anyway. {Michael Hodgdon} - interestingly so, that is something we have been questioning ourselves.Our initial intent was to minimize server load by keeping persisant read only memory on hand in the server scope.For instance, aMarkets rarely changes.In fact most of whats in the hcp.cfc rarely changes.Therefore, rather than constantly load these objects into local memory, we drop them into the server scope and access them there.Are you saying that because these objects are stored in server memory and all of our web users access that same object in server memory we could be creating problems?We are really concerned about server load and performance.If we are loading these objects into local memory rather than server, should we not be concerned with this? Thank you so much Ray Thats all for now - I'd defintely add the var scoping. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Radio button check
Thanks Matt. Your script and a few tweaks from me and everything looks good. Robert O. -Original Message- From: Plunkett, Matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 10:10 AM To: CF-Talk Subject: RE: Radio button check -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:56 AM To: CF-Talk Subject: OT: Radio button check How do I check whether a certain value is checked off on a radio button? The group name is send. The value I want checked is whether it is sendemail. If it is I want an alert to ask that the subject is required. I usually do something like this.Since radio buttons don't have the selectedIndex property, you have to look through the group to find out what was selected. var val; for (var x = 0; x formname.send.length; x++) { if (formname.send[x].checked) { val = formname.send[x].value; break; } } if (val == 'sendemail') alert('please provide a subject'); _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
From: [EMAIL PROTECTED] like ppl keep saying the word type is a reserved word and WONT work u will have 2 rename that field in your database, no ands, ifs or buts about it. read this, straight from the mothership http://www.macromedia.com/support/ultradev/ts/documents/insert _into.htm Not if you put square brackets around the field name: insert into clntnote (thisdate,subject,note,[type],compid) Does nobody read my emails? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems accessing variables with components
Please see my comments in the code below. Ditto. [deleted stuff] issues under load. {Michae Hodgdon} - These values are indeed persistant. This information rarely changes, so rather than make constant database hits, we are keeping the aMarkets array in a structure called sthcpInfo.stHcpinfo also holds other persistant information that we would like to keep persistance.So essentially, this information is designed to be read only, and set in memory only on initialization of this object.Access is received through the getRoutines that we have set. Ok - you still need to var scope any other variable, like current_market. !--- For each market returned by the database... --- cfloop from=1 to=#ArrayLen(sthcpInfo.aMarkets)# step=1 index=current_market cflock scope=SERVER type=EXCLUSIVE timeout=30 !--- Create a new topic object for this market in server memory--- cfset server.#sthcpInfo.aMarkets[current_market].topic# = CreateObject(component, cf_components.topic) Why do you do this? You are already storing the CFC itself in server memory - why not store these values in the CFC itself - in the Variables scope. Then the values will exist as long as the CFC itself exists. {Michael Hodgdon} - Each market has many routines that it runs as well personal information about that market.So we are using the topic cfc as a blueprint, and then we create an object for each market using that blueprint.For easy access, we reference the aMarkets cfc to output all the markets we have (for instance, on the home page our markets are ).When you are on a market page itself, we access that markets objects to return more detailed and rich information. Ok - but this still doesn't change my question. You have N CFCs, one for each market. Why not just store it in the main CFC itself? Referencing the server scope like this is - normally (and again, in my opinion) a bad idea. cfset server[sthcpinfo.amarkets[current_market]].topic.initializeObj ect() Again though, I'd move this stuff out of the server scope anyway. {Michael Hodgdon} - interestingly so, that is something we have been questioning ourselves.Our initial intent was to minimize server load by keeping persisant read only memory on hand in the server scope. Which is a good idea. For instance, aMarkets rarely changes.In fact most of whats in the hcp.cfc rarely changes.Therefore, rather than constantly load these objects into local memory, we drop them into the server scope Right - I'm not saying to NOT use the server scope, but to simply use a simpler model. If the A.cfc has N instances of B.cfc, you can simply have A.cfc keep these guys inside itself. Then when A.cfc is persisted, its local B CFCs are persisted as well. and access them there.Are you saying that because these objects are stored in server memory and all of our web users access that same object in server memory we could be creating problems?We are really concerned about server load and performance.If we are loading these objects into local memory rather than server, should we not be concerned with this? No, because the CFC that holds them itself is being persisted. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLocation with a dash of CFHTTP
I'm sure someone has wondered this exact same thing, and I'm sure it has been answered but I am going to ask anyway. cflocation is a very useful tag cfhttp is a very useful tag is there any easy way to perform a cflocation like redirect except posting data as if through a form? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
stored proc error with MX
hi, is there some reason why I can't add a date object via a stored proc in MX 6.1. example, cfset offRoadStart = CreateDateTime(Year(now()), month(now()), day(now()), hour(now()), minute(now()), 00) then, !---parameter passed with others, this is the only one giving me the problem--- CFPROCPARAM DBVARNAME=@OFFROADSTART VALUE=#offRoadStart# CFSQLTYPE=CF_SQL_DATE TYPE=IN I get this error, {Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented I had a look at JavaCast thinking I was'nt passing in a proper date object, even though I am, but javaCast has not data type support for date objects. any ideas, john. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: freelancer
Sure, Id like to hear more about this project. L Marcus Original message Date: Wed, 25 Feb 2004 09:33:08 -0600 From: Mark A. Kruger - CFG [EMAIL PROTECTED] Subject: OT: freelancer To: CF-Talk [EMAIL PROTECTED] cf folks, A friend of mine (a designer) is working on a job site and needs a contractor. It's not the sort of project that we are interested in at the moment :)It's a job site - searches, job candidates and employers... subscription based I believe. I have no idea of the budget or anything else about it.If any of you have any interest let me know and I will get you in contact with her. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: stored proc error with MX
John, Try CFSQLTYPE=CF_SQL_TIMESTAMP Steve -Original Message- From: John mccosker [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:57 AM To: CF-Talk Subject: stored proc error with MX hi, is there some reason why I can't add a date object via a stored proc in MX 6.1. example, cfset offRoadStart = CreateDateTime(Year(now()), month(now()), day(now()), hour(now()), minute(now()), 00) then, !---parameter passed with others, this is the only one giving me the problem--- CFPROCPARAM DBVARNAME=@OFFROADSTART VALUE=#offRoadStart# CFSQLTYPE=CF_SQL_DATE TYPE=IN I get this error, {Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented I had a look at JavaCast thinking I was'nt passing in a proper date object, even though I am, but javaCast has not data type support for date objects. any ideas, john. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX and CF5 on same server
Has anyone deployed a server with both CF5 and CFMX on it.I've got a live server with CF5 applications running on them.I haven't tested all the legacy apps on CFMX yet, but mgmt wants to test out a new CFMX app on the server.Any suggestions? Marlon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: freelancer
A friend of mine (a designer) is working on a job site and needs a contractor. It's not the sort of project that we are I've done a jobs site or two. Best example is probably: http://www.dpprofessionals.com/ Would be very interested in this. Thanks for your consideration. -- Les Mizzell -- Skill without imagination is craftsmanship and gives us many useful objects such as wickerwork picnic baskets. Imagination without skill gives us modern art. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and CF5 on same server
Run CFMX on a separate box. I am not sure about CF5 and MX on the same box, never tried it, but I bet it would require a lot of hacking around even to attempt it. Running MX on a different server than CF5 is much simpler and less time consuming solution. Use your workstation if you don't have a spare server. TK [Tom Kitta] -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 11:12 AM To: CF-Talk Subject: CFMX and CF5 on same server Has anyone deployed a server with both CF5 and CFMX on it.I've got a live server with CF5 applications running on them.I haven't tested all the legacy apps on CFMX yet, but mgmt wants to test out a new CFMX app on the server.Any suggestions? Marlon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: stored proc error with MX
John, Try CFSQLTYPE=CF_SQL_TIMESTAMP Steve -Original Message- From: John mccosker [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:57 AM To: CF-Talk Subject: stored proc error with MX hi, is there some reason why I can't add a date object via a stored proc in MX 6.1. example, cfset offRoadStart = CreateDateTime(Year(now()), month(now()), day(now()), hour(now()), minute(now()), 00) then, !---parameter passed with others, this is the only one giving me the problem--- CFPROCPARAM DBVARNAME=@OFFROADSTART VALUE=#offRoadStart# CFSQLTYPE=CF_SQL_DATE TYPE=IN I get this error, {Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented I had a look at JavaCast thinking I was'nt passing in a proper date object, even though I am, but javaCast has not data type support for date objects. any ideas, john. _ Thanks Steve, that worked for me. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and CF5 on same server
If you run them on separate ports it will work fine, but I wouldn't suggest it for a production server. Sam Blog http://www.rewindlife.com TeamMM http://www.macromedia.com/go/team -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 11:12 AM To: CF-Talk Subject: CFMX and CF5 on same server Has anyone deployed a server with both CF5 and CFMX on it. I've got a live server with CF5 applications running on them.I haven't tested all the legacy apps on CFMX yet, but mgmt wants to test out a new CFMX app on the server.Any suggestions? Marlon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Proper CF Insert of an array
Hello, First I would like to add to a comment that was made today and show my appreciation for the help that you all give so freely.I am new to coldfusion and just reading these e- mails have made me a diehard coldfusion fan. Thanks!now on to my question!! I am new to structures and arrays, and I need to insert the results of a cfloop on the array into my database. Can you insert a cfloop?Sample array output in below I have removed the table formating code: cfloop from=1 to=#ArrayLen(Session.Cart.productID)# index=ThisItem cfoutput cfoutput#Session.Cart.productID[ThisItem] #/cfoutput cfoutput#Session.Cart.productTitle[ThisItem] #/cfoutput cfoutput#Session.Cart.Qty[ThisItem]#/cfoutput cfoutput#Dollarformat(Session.itemTotal) #/cfoutput /cfoutput /cfloop Thanks for the assistance! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLocation with a dash of CFHTTP
Tyler, Have a look at getPageContext().forward('template.cfm'); This does a server side redirection, actually, it deletes the current page output buffer and starts a new one from the template you specify, as if issuing another request, but form and url variables are available on that next page. Call it either in cfscript or like cfset getpagecontext().forward(). -nathan strutz -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:52 AM To: CF-Talk Subject: CFLocation with a dash of CFHTTP I'm sure someone has wondered this exact same thing, and I'm sure it has been answered but I am going to ask anyway. cflocation is a very useful tag cfhttp is a very useful tag is there any easy way to perform a cflocation like redirect except posting data as if through a form? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proper CF Insert of an array
not sure what you want to do...but yes, you can have cfquery code inbetwixt cfloops, to perform inserts/updates/deletes based off of values you get from your loop process. tony -Original Message- From: David Berry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 11:27 AM To: CF-Talk Subject: Proper CF Insert of an array Hello, First I would like to add to a comment that was made today and show my appreciation for the help that you all give so freely.I am new to coldfusion and just reading these e- mails have made me a diehard coldfusion fan. Thanks!now on to my question!! I am new to structures and arrays, and I need to insert the results of a cfloop on the array into my database. Can you insert a cfloop?Sample array output in below I have removed the table formating code: cfloop from=1 to=#ArrayLen(Session.Cart.productID)# index=ThisItem cfoutput cfoutput#Session.Cart.productID[ThisItem] #/cfoutput cfoutput#Session.Cart.productTitle[ThisItem] #/cfoutput cfoutput#Session.Cart.Qty[ThisItem]#/cfoutput cfoutput#Dollarformat(Session.itemTotal) #/cfoutput /cfoutput /cfloop Thanks for the assistance! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX and CF5 on same server
On Wednesday 25 Feb 2004 16:22 pm, Samuel R. Neff wrote: If you run them on separate ports it will work fine, but I wouldn't suggest it for a production server. Why not ? We run legacy CF4.5 and MX6.1 on the same box. Different ports, obviously, but we proxy them both through a common Apache to make them appear to be the same URL. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfchart layered data
Hi All, I think I may be SOL here, but I thought I'd ask. I have a dataset that has %moisture on various dates. There are 4 lines of data. But, date samples vary between the four lines. It seems as though I can't get the chart to layer properly unless all the dates are the same. If they're not, I get really wonky results. Is this just a limitation of cfchart? If so, does anyone have a free alternative? (To see the kind of chart I'm trying to create, you can look at this page: http://www.cft.uwex.edu/ces/ag/silagedrydown/ Scroll down and pick a region and year 2003. The chart should be near the bottom of the page, under the table of data. This was down with a cfx tag long ago, and it won't work on linux.) -- Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFExecute and environment variables
I'm trying to call a Perl batch file in a CFML template on a Win server.The batch file works fine from the command line but Perl complains that the path is not set when using CFExecute: You do not have Perl in your PATH. The path to Perl exists from the command line but the path from CFMX looks like: e:\CFusionMX\runtime\..\lib;e:\CFusionMX\runtime\..\jintegra\bin;e:\CFusionMX\runtime\..\jintegra\bin\international;e:\CFusionMX\runtime\..\lib\_nti40\bin;E:\WINDOWS\system32;E:\WINDOWS;E:\WINDOWS\System32\Wbem Is there a way to add a path to Perl when using CFExecute? Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Proper CF Insert of an array
Hi David: First thing I'd like to address is the way way way WAY too many cfoutput tags :) Every time you use a cfoutput, it's like starting a car.A /cfoutput is like shutting the car down. So, for every iteration of your loop, you're starting and stopping the car far too many times just to get from point A to point B.one cfoutput/cfoutput surrounding your cfloop/cfloop would suffice. As far as your insert, the most straightforward way would be to loop over the array and do an INSERT statement for each item. cfloop from=1 to=#arrayLen(session.cart.productID)# index=i cfquery name=addItem datasource=myDSN INSERT INTO myTable (productID, qty) VALUES (#session.cart.productID[i]#, #session.cart.Qty[i]#) /cfquery /cfloop Also, for what it's worth, I didn't use cfqueryparam for the sake of keeping the example simple...but you should always be using cfqueryparam with your SQL. And finally...there's probably a better way to do the shopping cart.Right now it seems that you have 3 arrays (one for ID, one for description, one for qty).That means if you delete from one, you have to remember to delete from every other.Not a big deal, but not necessarily a good idea either. You might want to try one array of structures. session.cart = arrayNew(); session.cart[1] = structNew(); session.cart[1].prodID = 1234; session.cart[1].description = Fuzzy Underwear; session.cart[1].qty = 745; session.cart[2] = structNew(); session.cart[2].prodID = 4321; session.cart[2].description = Navel Lint Ball; session.cart[2].qty = 1; session.cart[3] = structNew(); session.cart[3].prodID = 666; session.cart[3].description = Preparation HoF; session.cart[3].qty = 123; now, if you cfdump var=#session.cart#, you can see everything consolidated into one variable.Granted, there are nested complex variables within...but the cart entity itself is one variable.I find it to be a bit simpler to manage.I'm a simple guy.: ) hth, Charlie - Original Message - From: David Berry [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:26 AM Subject: Proper CF Insert of an array Hello, First I would like to add to a comment that was made today and show my appreciation for the help that you all give so freely.I am new to coldfusion and just reading these e- mails have made me a diehard coldfusion fan. Thanks!now on to my question!! I am new to structures and arrays, and I need to insert the results of a cfloop on the array into my database. Can you insert a cfloop?Sample array output in below I have removed the table formating code: cfloop from=1 to=#ArrayLen(Session.Cart.productID)# index=ThisItem cfoutput cfoutput#Session.Cart.productID[ThisItem] #/cfoutput cfoutput#Session.Cart.productTitle[ThisItem] #/cfoutput cfoutput#Session.Cart.Qty[ThisItem]#/cfoutput cfoutput#Dollarformat(Session.itemTotal) #/cfoutput /cfoutput /cfloop Thanks for the assistance! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFExecute and environment variables
Nevermind - all I needed to do was add the path to the batch file (duh). Regards, Howie - Original Message - From: Howie Hamlin To: CF-Talk Sent: Wednesday, February 25, 2004 11:45 AM Subject: CFExecute and environment variables I'm trying to call a Perl batch file in a CFML template on a Win server.The batch file works fine from the command line but Perl complains that the path is not set when using CFExecute: You do not have Perl in your PATH. The path to Perl exists from the command line but the path from CFMX looks like: e:\CFusionMX\runtime\..\lib;e:\CFusionMX\runtime\..\jintegra\bin;e:\CFusionMX\runtime\..\jintegra\bin\international;e:\CFusionMX\runtime\..\lib\_nti40\bin;E:\WINDOWS\system32;E:\WINDOWS;E:\WINDOWS\System32\Wbem Is there a way to add a path to Perl when using CFExecute? Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfinvoke problem.
Hi All, I am getting an error on a cfinvoke if i change the method from square to squarex,add,sq1 or anything else. I am using cfmx 6.1 Any help would be appreciated. Pat error: === Web service operation squarex with parameters {num1={544},} could not be found. The error occurred in E:\apps\fl\pat\cfc_example\example2.cfm: line 13 11 : method=squarex 12 : returnVariable=var1 13 : cfinvokeargument name=num1 value=544 14 : /cfinvoke 15 : cfdump var=#var1# cfc = cfcomponent cffunction name=square returnType=string access=remote cfargument name=num1 type=string required=true cfset sum = arguments.num1 + arguments.num1 cfreturn sum /cffunction /cfcomponent cfm === cfinvoke webservice=http://usaflweb01/apps/fl/pat/cfc_example/example2.cfc?wsdl method=square returnVariable=var1 cfinvokeargument name=num1 value=544 /cfinvoke cfdump var=#var1# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX and CF5 on same server
I think Sam was suggesting that the standalone MX server not be deployed as a production server (not necessarily against CF4.5 (or CF5) and MX no the same box).His suggestion echos MM's own recommendations against doing so. MX's standalone server was provided to allow people to test/migrate their data from CF5 to MX on a single box.It wasn't intended to be robust enough to be used as a production server. - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:40 AM Subject: Re: CFMX and CF5 on same server On Wednesday 25 Feb 2004 16:22 pm, Samuel R. Neff wrote: If you run them on separate ports it will work fine, but I wouldn't suggest it for a production server. Why not ? We run legacy CF4.5 and MX6.1 on the same box. Different ports, obviously, but we proxy them both through a common Apache to make them appear to be the same URL. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Proper CF Insert of an array
You'll have to loop over single inserts (one row at a time): cfloop from=1 to=#ArrayLen(Session.Cart.productID)# index=i cfquery ... INSERT INTO yourTable (col1, col2, col3) VALUES ( cfqueryparam value=#session.var1[i]# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#session.var2[i]# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#session.var3[i]# cfsqltype=CF_SQL_VARCHAR ) /cfquery /cfloop On Wed, 25 Feb 2004 11:26:51 -0500, in cf-talk you wrote: Hello, First I would like to add to a comment that was made today and show my appreciation for the help that you all give so freely.I am new to coldfusion and just reading these e- mails have made me a diehard coldfusion fan. Thanks!now on to my question!! I am new to structures and arrays, and I need to insert the results of a cfloop on the array into my database. Can you insert a cfloop?Sample array output in below I have removed the table formating code: cfloop from=1 to=#ArrayLen(Session.Cart.productID)# index=ThisItem cfoutput cfoutput#Session.Cart.productID[ThisItem] #/cfoutput cfoutput#Session.Cart.productTitle[ThisItem] #/cfoutput cfoutput#Session.Cart.Qty[ThisItem]#/cfoutput cfoutput#Dollarformat(Session.itemTotal) #/cfoutput /cfoutput /cfloop Thanks for the assistance! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfinvoke problem.
You tried refreshing the WS in CFAdmin/Web Services? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proper CF Insert of an array
From: David Berry I am new to structures and arrays, and I need to insert the results of a cfloop on the array into my database. Can you insert a cfloop?Sample array output in below I have removed the table formating code: That's not a problem You can put a CFQUERY pretty much anywhere in code except for in another CFQUERY (and a few other tags) While within your loop you can just CFQUERY to insert your data cfloop from=1 to=#ArrayLen(Session.Cart.productID)# index=ThisItem cfquery datasource=myDSN name=insert insert into MyTable (ProductID, ProductTitle, Qty, Total) values ( cfqueryparam cfsqltype=CF_SQL_INTEGER value=#Session.Cart.productID[ThisItem]#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Session.Cart.productTitle[ThisItem]#, cfqueryparam cfsqltype=CF_SQL_INTEGER value=#Session.Cart.Qty[ThisItem]#, cfqueryparam cfsqltype=CF_SQL_MONEY value=#Session.itemTotal# ) /cfquery /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: CFTicket 2.0 Beta Test
Hey Folks, We just released the first beta of CFTicket 2.0. For those who don't know, CFTicket is a customer support, trouble ticket application. This new version uses CFC's and therefore requires CFMX. We are having an open beta test for anyone who wishes to test. Just download, install, and presto. We are looking for feedback on features and any bugs that people find. You can find more information at http://www.cornfeed.com/beta/ . If anyone has any other questions or has trouble installing CFTicket 2.0, feel free to contact me directly off-list. Thanks, Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDefined(CGI.foo) always returns YES
I just tested this on CF 5.0 and I get the same result you do, so this behavior was changed sometime after version 5, but I have no idea when. Andy -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:52 AM To: CF-Talk Subject: RE: IsDefined(CGI.foo) always returns YES Well then I'm confused too because running that exact same code, I get the opposite result: using StructKeyExists(), foo exists in CGI using IsDefined(), foo exists in CGI Running ColdFusion 5.0.0.0 Enterprise. Anyone? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: News Ticker?
http://www.thejmaker.com/scrollup.html Cheap and loaded with options.The demo is ugly but your implementation doesn't have to be.I use it cuz I can plant it into a table cell rather than giving it an absolute position. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JRun has closed connection
Crit, It can be a number of issues, usually when JRUN craps out its because the system has crapped out. Next time this happens check your processes and see what the CPU and RAM usage is like. If you are running multiple instances, you may have one too many. -Adam -Original Message- From: Critter [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 02:54 PM To: 'CF-Talk' Subject: JRun has closed connection oi CF-Talk,!! We'verecently moved a couple of our applications from CF5 to MX. We are randomly, yet repeatedly gettingJRUNerrorsthatsaytherewasaninternalservererror. and JRUN has closed the connection. A refresh of the page, seems to clear the error sometimes any ideas / suggestions? /critz -- --- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRun has closed connection
As others have pointed out, it could be a number of issues, I searched through a number of forums and found some people got this message when using COM objects, or when calling getPageContext.forward(). Also this can also appear if CF has just restarted due to reaching x amount of unresponsive threads. Finally I came across this Jrun technote http://www.macromedia.com/support/jrun/ts/documents/tn18176.htm Which appears to be a bit dated but reading up on the section Connection reset by peer highlighted that this can be caused when Jrun is waiting on a third party. Once it has waited a specified period (which can be changed in the xml config files) it returns a message to the peer (in this case the web server). In our case this message was caused by long running queries repeatedly being executed which resulted in the number of available simultaneous requests being used up. Jrun would give up waiting and return this error message. Finally this could also be related to the use of the odbc-bridge driver which should be disabled if not used. (which it shouldnt be in production anyway). HTH Kola -Original Message- From: Critter [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 14:54 To: CF-Talk Subject: JRun has closed connection oi CF-Talk,!! We've recently moved a couple of our applications from CF5 to MX. We are randomly, yet repeatedly getting JRUN errors that say there was an internal server er ror. and JRUN has closed the connection. A refresh of the page, seems to clear the error sometimes any ideas / suggestions? /critz -- --- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and CF5 on same server
Marlon If you're using IIS, this can be done quite easily by installing cf5, making a note of the dll the cf extensions map to and then installing cfmx. You can set up virtual directories and determine which version of the cf dll. Is used for each directory. Its explained in detail here http://www.sys-con.com/coldfusion/articleprint.cfm?id=647 and works like a charm. HTH Kola -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 16:12 To: CF-Talk Subject: CFMX and CF5 on same server Has anyone deployed a server with both CF5 and CFMX on it.I've got a live server with CF5 applications running on them.I haven't tested all the legacy apps on CFMX yet, but mgmt wants to test out a new CFMX app on the server.Any suggestions? Marlon _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Headers listing?
You should be able to find more information here http://livinginternet.com/e/em_rfc.htm or more specifically here http://www.faqs.org/rfcs/rfc2076.html HTH Kola -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 20 February 2004 20:30 To: CF-Talk Subject: RE: Email Headers listing? Not bad.I am curious though if there is some kind of a standard list that is handled by most email clients (Hotmail, yahoo, aol, outlook, etc)I'm especially curious when it comes to Priority and things like that. I'd like to use headers that are the most common and be able to see the possible values for those headers.I'm also considering doing a custom email program using CFPOP and want to know what headers and values to look for.Anyone with detailed information like that, please share.Thanks! John Burns -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 3:25 PM To: CF-Talk Subject: Re: Email Headers listing? Here's a page with some good info: http://www.stopspam.org/email/headers.html Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Burns, John To: CF-Talk Sent: Friday, February 20, 2004 3:18 PM Subject: Email Headers listing? Can anyone tell me where I can find a list of all of the standard and optional email headers?I'd like to know what all I can set by playing with those in CFMAIL.Thanks! John Burns _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: News Ticker?
There are some good ones here http://www.dynamicdrive.com/dynamicindex2/index.html rely on _javascript_ I've used this one a couple times and I dig it - it uses xml to populate the ticker so it pretty easy to integrate http://www.dynamicdrive.com/dynamicindex2/xmlticker2.htm On Wed, 2004-02-25 at 09:24, Matt Robertson wrote: http://www.thejmaker.com/scrollup.html That crashed my browser btw Cheap and loaded with options.The demo is ugly but your implementation doesn't have to be.I use it cuz I can plant it into a table cell rather than giving it an absolute position. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CSS
Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: bank of america processing
Hi Matt... I interface with Bank of America right now... What service are you using??? Inprocess or Redirect? BZaccheo On 2/24/04 2:12 PM, Matt Robertson [EMAIL PROTECTED] wrote: Barney Boisvert wrote: Does the interface involve sending a file to BofA? No, afraid not.Thx anyway.The problem is truly bizarre. Cfhttp sends the data to BofA.BofA gets it and processes it; incorrectly determining that the sending site is not on the approved referrers list (it is).Then there's this weird thing:BofA gets the data, right?However on my side of the fence cfhttp throws an error. If I use this excerpt to illustrate the problem, which is 9 lines long, an error will be thrown on Line 8 (its always on the last cfhttpparam, whatever it is; reordering them does nothing). cfhttp url=""> name=PaymentInfo method=POST port=443 redirect=no cfhttpparam type=FORMFIELD name=field1 value=blah cfhttpparam type=FORMFIELD name=field2 value=foo /cfhttp The error (from their debug site) is: Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and underscores.The column name html is invalid. If I post to the live payment site, I get the same error with The column name is invalid. I have yet to be able to find a way to dump out the complete BofA response during debugging.Something I'm doing or they're doing is not allowing this.Trying to use cfdump or cfhttp.filecontent to read the returned data is a waste of time: the error is occurring on line 8 which is before cfhttp is terminated... So no return variables.Or perhaps more accurately the return variable is causing the explosion? I'm frankly mystified, and so is BofA tech support.I had one of their tech guys on the phone for over an hour with me and neither of us could get anywhere with this. Bah.Humbug. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:44 AM To: CF-Talk Subject: RE: bank of america processing When using CFHTTP to interface with MediaLinq faxing service, it wouldn't accept the file uploads as valid.I ended up writing a function library that would build and send HTTP calls using HTTPClient (the same library that CFHTTP is built on), but using the right syntax for the uploaded files. No idea if that's relevant or not, but thought I'd throw it out there. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:33 AM To: CF-Talk Subject: bank of america processing Does anyone have B of A cc processing enabled on CF 6.1?If so can you share your (sanitized) cfhttp call with me?Mine has been working since Q3 last year, but suddenly seems to have stopped.I had a January 9 transaction work great, and one yesterday blew up (nothing in between... Hi-dollar lo-volume on this site). I've spent quite a bit of time trying to debug it, and a bunch of time on the phone with the BofA folks.The problem seems to be cfhttp itself.Before I give up I was hoping someone had a working example I could use to compare mine against. Thx, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: freelancer
Or you can direct him/her to: www.prohire.com Which will do everything he needs already, for about $100.00 a month ;) Pablo -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 25 Feb 2004 10:59:22 -0500 Sure, Id like to hear more about this project. L Marcus Original message Date: Wed, 25 Feb 2004 09:33:08 -0600 From: Mark A. Kruger - CFG [EMAIL PROTECTED] Subject: OT: freelancer To: CF-Talk [EMAIL PROTECTED] cf folks, A friend of mine (a designer) is working on a job site and needs a contractor. It's not the sort of project that we are interested in at the moment :)It's a job site - searches, job candidates and employers... subscription based I believe. I have no idea of the budget or anything else about it.If any of you have any interest let me know and I will get you in contact with her. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CSS
www.alistapart.com glish.com www.csszengarden.com http://www.westciv.com/style_master/house/cookbook/ http://css.maxdesign.com.au/index.htm -- dc -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 18:35 To: CF-Talk Subject: CSS Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ASP page using ColdFusion
I have a site done entirely in ASP (I am not the developer) and am taking it over to do some work. I know very little asp but am very fluent in ColdFusion. The update I need to make will require the use of graphs. I wanted to incorporate the graphing engine in ColdFusion on my asp page. But I am running into a problem of figuring out a way to display the CF made graphs on my ASP page. The ASP page is necessary because it has security settings and includes all display information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CSS
Whoops sorry, that was just a list of good css sites I found :-/ Might be some info on the sites anyway... -- dc -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 18:35 To: CF-Talk Subject: CSS Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX and CF5 on same server
You dont have to necessarily run on separate ports... You can assign different file extensions to process either server.. Like you can have: .cfm to run on CF 5 and .cfml to run on CFMX You can also map .cfc to the MX server, etc... then the same server will run either instance. Pablo -- Original Message -- From: Charlie Griefer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 25 Feb 2004 09:49:46 -0700 I think Sam was suggesting that the standalone MX server not be deployed as a production server (not necessarily against CF4.5 (or CF5) and MX no the same box).His suggestion echos MM's own recommendations against doing so. MX's standalone server was provided to allow people to test/migrate their data from CF5 to MX on a single box.It wasn't intended to be robust enough to be used as a production server. - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:40 AM Subject: Re: CFMX and CF5 on same server On Wednesday 25 Feb 2004 16:22 pm, Samuel R. Neff wrote: If you run them on separate ports it will work fine, but I wouldn't suggest it for a production server. Why not ? We run legacy CF4.5 and MX6.1 on the same box. Different ports, obviously, but we proxy them both through a common Apache to make them appear to be the same URL. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: problems accessing variables with components
Thanks Ray, I will let you know what we have come up with Michael S Hodgdon Web Development Project Manager 617 - 669 - 7183 [EMAIL PROTECTED] - Original Message - From: Raymond Camden To: CF-Talk Sent: Wednesday, February 25, 2004 10:46 AM Subject: RE: problems accessing variables with components Please see my comments in the code below. Ditto. [deleted stuff] issues under load. {Michae Hodgdon} - These values are indeed persistant. This information rarely changes, so rather than make constant database hits, we are keeping the aMarkets array in a structure called sthcpInfo.stHcpinfo also holds other persistant information that we would like to keep persistance.So essentially, this information is designed to be read only, and set in memory only on initialization of this object.Access is received through the getRoutines that we have set. Ok - you still need to var scope any other variable, like current_market. !--- For each market returned by the database... --- cfloop from=1 to=#ArrayLen(sthcpInfo.aMarkets)# step=1 index=current_market cflock scope=SERVER type=EXCLUSIVE timeout=30 !--- Create a new topic object for this market in server memory--- cfset server.#sthcpInfo.aMarkets[current_market].topic# = CreateObject(component, cf_components.topic) Why do you do this? You are already storing the CFC itself in server memory - why not store these values in the CFC itself - in the Variables scope. Then the values will exist as long as the CFC itself exists. {Michael Hodgdon} - Each market has many routines that it runs as well personal information about that market.So we are using the topic cfc as a blueprint, and then we create an object for each market using that blueprint.For easy access, we reference the aMarkets cfc to output all the markets we have (for instance, on the home page our markets are ).When you are on a market page itself, we access that markets objects to return more detailed and rich information. Ok - but this still doesn't change my question. You have N CFCs, one for each market. Why not just store it in the main CFC itself? Referencing the server scope like this is - normally (and again, in my opinion) a bad idea. cfset server[sthcpinfo.amarkets[current_market]].topic.initializeObj ect() Again though, I'd move this stuff out of the server scope anyway. {Michael Hodgdon} - interestingly so, that is something we have been questioning ourselves.Our initial intent was to minimize server load by keeping persisant read only memory on hand in the server scope. Which is a good idea. For instance, aMarkets rarely changes.In fact most of whats in the hcp.cfc rarely changes.Therefore, rather than constantly load these objects into local memory, we drop them into the server scope Right - I'm not saying to NOT use the server scope, but to simply use a simpler model. If the A.cfc has N instances of B.cfc, you can simply have A.cfc keep these guys inside itself. Then when A.cfc is persisted, its local B CFCs are persisted as well. and access them there.Are you saying that because these objects are stored in server memory and all of our web users access that same object in server memory we could be creating problems?We are really concerned about server load and performance.If we are loading these objects into local memory rather than server, should we not be concerned with this? No, because the CFC that holds them itself is being persisted. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CSS
Plum does this and a whole lot more, and it's a great way to learn advanced CSS techniques.If you want to be on the Private Beta Testers list then contact me offlist. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training: * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 1:34 PM Subject: CSS Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ASP page using ColdFusion
why not use an inline frame with the frame contents pointing to your cfm page? - Original Message - From: chad To: CF-Talk Sent: Wednesday, February 25, 2004 1:42 PM Subject: ASP page using ColdFusion I have a site done entirely in ASP (I am not the developer) and am taking it over to do some work. I know very little asp but am very fluent in ColdFusion. The update I need to make will require the use of graphs. I wanted to incorporate the graphing engine in ColdFusion on my asp page. But I am running into a problem of figuring out a way to display the CF made graphs on my ASP page. The ASP page is necessary because it has security settings and includes all display information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ASP page using ColdFusion
Just use an ASP include to include the contents of the CFM page. Scott -Original Message- From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 1:42 PM To: CF-Talk Subject: ASP page using ColdFusion I have a site done entirely in ASP (I am not the developer) and am taking it over to do some work. I know very little asp but am very fluent in ColdFusion. The update I need to make will require the use of graphs. I wanted to incorporate the graphing engine in ColdFusion on my asp page. But I am running into a problem of figuring out a way to display the CF made graphs on my ASP page. The ASP page is necessary because it has security settings and includes all display information. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ASP page using ColdFusion
CFCHART allows you to output the chart to a file.You could do that, and then just reference the file (it's an image or flash movie) from the ASP page. -Original Message- From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 10:42 AM To: CF-Talk Subject: ASP page using ColdFusion I have a site done entirely in ASP (I am not the developer) and am taking it over to do some work. I know very little asp but am very fluent in ColdFusion. The update I need to make will require the use of graphs. I wanted to incorporate the graphing engine in ColdFusion on my asp page. But I am running into a problem of figuring out a way to display the CF made graphs on my ASP page. The ASP page is necessary because it has security settings and includes all display information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and CF5 on same server
Thanks everyone for the help.Luckily, I've talked mgmt into ordering another server a few months in advance of the previous plans so that I can set it up correctly from the get go. -- marlon And Bobby you are right, I am being selfish, but the last time I checked, we don't have a whole lot of songs that feature the cowbell! -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 12:08 PM To: CF-Talk Subject: RE: CFMX and CF5 on same server Marlon If you're using IIS, this can be done quite easily by installing cf5, making a note of the dll the cf extensions map to and then installing cfmx. You can set up virtual directories and determine which version of the cf dll. Is used for each directory. Its explained in detail here http://www.sys-con.com/coldfusion/articleprint.cfm?id=647 and works like a charm. HTH Kola -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 16:12 To: CF-Talk Subject: CFMX and CF5 on same server Has anyone deployed a server with both CF5 and CFMX on it.I've got a live server with CF5 applications running on them.I haven't tested all the legacy apps on CFMX yet, but mgmt wants to test out a new CFMX app on the server.Any suggestions? Marlon _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMODULE with CFHTMLHEAD?
[Apologies if this occurs twice; I've sent it an hour ago but hasn't appeared on the list so I'm presuming it's gone down the blackhole route.] Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Include a CFMODULE with CFHTMLHEAD?
Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ASP page using ColdFusion
If it's an all ASP site then isn't it really better to stick with ASP for the whole site?Mixing ASP and CF seems like it's going to create a maintenance nightmare. If you want to display charts in ASP then you can look into Office Web Components on the low end and many available charting engines on the high end. My $0.02. Sam Blog http://www.rewindlife.com TeamMM http://www.macromedia.com/go/team -Original Message- From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 1:42 PM To: CF-Talk Subject: ASP page using ColdFusion I have a site done entirely in ASP (I am not the developer) and am taking it over to do some work. I know very little asp but am very fluent in ColdFusion. The update I need to make will require the use of graphs. I wanted to incorporate the graphing engine in ColdFusion on my asp page. But I am running into a problem of figuring out a way to display the CF made graphs on my ASP page. The ASP page is necessary because it has security settings and includes all display information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Include a CFMODULE with CFHTMLHEAD?
cfsavecontent variable=myvar cfmodule . / /cfsavecontent cfhtmlhead text=#myvar# / Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:06 AM To: CF-Talk Subject: Include a CFMODULE with CFHTMLHEAD? Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMODULE with CFHTMLHEAD?
One way to do it is to make cfhtmlhead work the way it should have been originally defined... with an end tag. Here's a work around; copy this code into a file called htmlhead.cfm in your customtags directory: cfswitch _expression_=#thistag.executionmode# cfcase value=start /cfcase cfcase value=end cfhtmlhead text=#thistag.generatedcontent# cfset thistag.generatedcontent= /cfcase /cfswitch Then do this: cf_htmlhead // js code here // cfmodule code here //etc /cf_htmlhead Steve Nelson [EMAIL PROTECTED] wrote: [Apologies if this occurs twice; I've sent it an hour ago but hasn't appeared on the list so I'm presuming it's gone down the blackhole route.] Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CSS
NP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 12:49 PM To: CF-Talk Subject: RE: CSS Whoops sorry, that was just a list of good css sites I found :-/ Might be some info on the sites anyway... -- dc -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 18:35 To: CF-Talk Subject: CSS Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Include a CFMODULE with CFHTMLHEAD?
Thanks barney, I'll give it a whirl. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 7:27 pm To: CF-Talk Subject: RE: Include a CFMODULE with CFHTMLHEAD? cfsavecontent variable=myvar cfmodule . / /cfsavecontent cfhtmlhead text=#myvar# / Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:06 AM To: CF-Talk Subject: Include a CFMODULE with CFHTMLHEAD? Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFLocation with a dash of CFHTTP
This is unfortunatly a bad thing for me because I am using fusebox so I need to beable to change things up from one page to the next.Plus after reading this page: http://www.sys-con.com/coldfusion/article.cfm?id=450 i feel there are too many draw backs associated with this for what I want to use it for.Is this all? Tyler Clendenin GSL Solutions - Original Message - From: Nathan Strutz To: CF-Talk Sent: Wednesday, February 25, 2004 11:30 AM Subject: RE: CFLocation with a dash of CFHTTP Tyler, Have a look at getPageContext().forward('template.cfm'); This does a server side redirection, actually, it deletes the current page output buffer and starts a new one from the template you specify, as if issuing another request, but form and url variables are available on that next page. Call it either in cfscript or like cfset getpagecontext().forward(). -nathan strutz -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:52 AM To: CF-Talk Subject: CFLocation with a dash of CFHTTP I'm sure someone has wondered this exact same thing, and I'm sure it has been answered but I am going to ask anyway. cflocation is a very useful tag cfhttp is a very useful tag is there any easy way to perform a cflocation like redirect except posting data as if through a form? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: bank of america processing
Butch, I'm using Redirect. The cfhttp call is erroring out for no apparent reason.Am using CF 6.1. --Matt-- -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 10:35 AM To: CF-Talk Subject: Re: bank of america processing Hi Matt... I interface with Bank of America right now... What service are you using??? Inprocess or Redirect? BZaccheo On 2/24/04 2:12 PM, Matt Robertson [EMAIL PROTECTED] wrote: Barney Boisvert wrote: Does the interface involve sending a file to BofA? No, afraid not.Thx anyway.The problem is truly bizarre. Cfhttp sends the data to BofA.BofA gets it and processes it; incorrectly determining that the sending site is not on the approved referrers list (it is).Then there's this weird thing:BofA gets the data, right?However on my side of the fence cfhttp throws an error. If I use this excerpt to illustrate the problem, which is 9 lines long, an error will be thrown on Line 8 (its always on the last cfhttpparam, whatever it is; reordering them does nothing). cfhttp url=""> name=PaymentInfo method=POST port=443 redirect=no cfhttpparam type=FORMFIELD name=field1 value=blah cfhttpparam type=FORMFIELD name=field2 value=foo /cfhttp The error (from their debug site) is: Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and underscores.The column name html is invalid. If I post to the live payment site, I get the same error with The column name is invalid. I have yet to be able to find a way to dump out the complete BofA response during debugging.Something I'm doing or they're doing is not allowing this.Trying to use cfdump or cfhttp.filecontent to read the returned data is a waste of time: the error is occurring on line 8 which is before cfhttp is terminated... So no return variables.Or perhaps more accurately the return variable is causing the explosion? I'm frankly mystified, and so is BofA tech support.I had one of their tech guys on the phone for over an hour with me and neither of us could get anywhere with this. Bah.Humbug. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:44 AM To: CF-Talk Subject: RE: bank of america processing When using CFHTTP to interface with MediaLinq faxing service, it wouldn't accept the file uploads as valid.I ended up writing a function library that would build and send HTTP calls using HTTPClient (the same library that CFHTTP is built on), but using the right syntax for the uploaded files. No idea if that's relevant or not, but thought I'd throw it out there. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:33 AM To: CF-Talk Subject: bank of america processing Does anyone have B of A cc processing enabled on CF 6.1?If so can you share your (sanitized) cfhttp call with me?Mine has been working since Q3 last year, but suddenly seems to have stopped.I had a January 9 transaction work great, and one yesterday blew up (nothing in between... Hi-dollar lo-volume on this site). I've spent quite a bit of time trying to debug it, and a bunch of time on the phone with the BofA folks.The problem seems to be cfhttp itself.Before I give up I was hoping someone had a working example I could use to compare mine against. Thx, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFLocation with a dash of CFHTTP
If it gets right down to it you can use _javascript_ - unless thats a no-no On Wed, 2004-02-25 at 11:54, Tyler Clendenin wrote: This is unfortunatly a bad thing for me because I am using fusebox so I need to beable to change things up from one page to the next.Plus after reading this page: http://www.sys-con.com/coldfusion/article.cfm?id=450 i feel there are too many draw backs associated with this for what I want to use it for.Is this all? Tyler Clendenin GSL Solutions - Original Message - From: Nathan Strutz To: CF-Talk Sent: Wednesday, February 25, 2004 11:30 AM Subject: RE: CFLocation with a dash of CFHTTP Tyler, Have a look at getPageContext().forward('template.cfm'); This does a server side redirection, actually, it deletes the current page output buffer and starts a new one from the template you specify, as if issuing another request, but form and url variables are available on that next page. Call it either in cfscript or like cfset getpagecontext().forward(). -nathan strutz -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:52 AM To: CF-Talk Subject: CFLocation with a dash of CFHTTP I'm sure someone has wondered this exact same thing, and I'm sure it has been answered but I am going to ask anyway. cflocation is a very useful tag cfhttp is a very useful tag is there any easy way to perform a cflocation like redirect except posting data as if through a form? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CSS
All that is necessary is to use link src="" media=print instead of link src="" media=screen (can also do this with import). What I tend to do is reverse the two when developing for print. so that the print version shows up on the screen.then set them back when I am satisfied. _ From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 1:35 PM To: CF-Talk Subject: CSS Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLocation with a dash of CFHTTP
If you're using fusebox, then you can probably convert the form fields to URL parameters and CFLOCATION to that URL, because they'll be 'attributes' on the other end either way. Cheers, barneyb -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 11:59 AM To: CF-Talk Subject: Re: CFLocation with a dash of CFHTTP If it gets right down to it you can use _javascript_ - unless thats a no-no On Wed, 2004-02-25 at 11:54, Tyler Clendenin wrote: This is unfortunatly a bad thing for me because I am using fusebox so I need to beable to change things up from one page to the next.Plus after reading this page: http://www.sys-con.com/coldfusion/article.cfm?id=450 i feel there are too many draw backs associated with this for what I want to use it for.Is this all? Tyler Clendenin GSL Solutions - Original Message - From: Nathan Strutz To: CF-Talk Sent: Wednesday, February 25, 2004 11:30 AM Subject: RE: CFLocation with a dash of CFHTTP Tyler, Have a look at getPageContext().forward('template.cfm'); This does a server side redirection, actually, it deletes the current page output buffer and starts a new one from the template you specify, as if issuing another request, but form and url variables are available on that next page. Call it either in cfscript or like cfset getpagecontext().forward(). -nathan strutz -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:52 AM To: CF-Talk Subject: CFLocation with a dash of CFHTTP I'm sure someone has wondered this exact same thing, and I'm sure it has been answered but I am going to ask anyway. cflocation is a very useful tag cfhttp is a very useful tag is there any easy way to perform a cflocation like redirect except posting data as if through a form? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: bank of america processing
I tried cfhttp and ended up going with a regular form post It works ok.. I am actually in the process of upgrading the same site to the SOAP option. Which I¹m told is the best solution... However, I haven¹t been able to get working yet... BZaccheo On 2/25/04 11:54 AM, Matt Robertson [EMAIL PROTECTED] wrote: Butch, I'm using Redirect. The cfhttp call is erroring out for no apparent reason.Am using CF 6.1. --Matt-- -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 10:35 AM To: CF-Talk Subject: Re: bank of america processing Hi Matt... I interface with Bank of America right now... What service are you using??? Inprocess or Redirect? BZaccheo On 2/24/04 2:12 PM, Matt Robertson [EMAIL PROTECTED] wrote: Barney Boisvert wrote: Does the interface involve sending a file to BofA? No, afraid not.Thx anyway.The problem is truly bizarre. Cfhttp sends the data to BofA.BofA gets it and processes it; incorrectly determining that the sending site is not on the approved referrers list (it is).Then there's this weird thing:BofA gets the data, right?However on my side of the fence cfhttp throws an error. If I use this excerpt to illustrate the problem, which is 9 lines long, an error will be thrown on Line 8 (its always on the last cfhttpparam, whatever it is; reordering them does nothing). cfhttp url=""> name=PaymentInfo method=POST port=443 redirect=no cfhttpparam type=FORMFIELD name=field1 value=blah cfhttpparam type=FORMFIELD name=field2 value=foo /cfhttp The error (from their debug site) is: Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and underscores.The column name html is invalid. If I post to the live payment site, I get the same error with The column name is invalid. I have yet to be able to find a way to dump out the complete BofA response during debugging.Something I'm doing or they're doing is not allowing this.Trying to use cfdump or cfhttp.filecontent to read the returned data is a waste of time: the error is occurring on line 8 which is before cfhttp is terminated... So no return variables.Or perhaps more accurately the return variable is causing the explosion? I'm frankly mystified, and so is BofA tech support.I had one of their tech guys on the phone for over an hour with me and neither of us could get anywhere with this. Bah.Humbug. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:44 AM To: CF-Talk Subject: RE: bank of america processing When using CFHTTP to interface with MediaLinq faxing service, it wouldn't accept the file uploads as valid.I ended up writing a function library that would build and send HTTP calls using HTTPClient (the same library that CFHTTP is built on), but using the right syntax for the uploaded files. No idea if that's relevant or not, but thought I'd throw it out there. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:33 AM To: CF-Talk Subject: bank of america processing Does anyone have B of A cc processing enabled on CF 6.1?If so can you share your (sanitized) cfhttp call with me?Mine has been working since Q3 last year, but suddenly seems to have stopped.I had a January 9 transaction work great, and one yesterday blew up (nothing in between... Hi-dollar lo-volume on this site). I've spent quite a bit of time trying to debug it, and a bunch of time on the phone with the BofA folks.The problem seems to be cfhttp itself.Before I give up I was hoping someone had a working example I could use to compare mine against. Thx, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]