RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
Not to argue with Ben, but I don't think that PreserveSingleQuotes() is the answer... That function prevents CF from automatically esacping single quotes (in this case you WANT CF to escape them for you). I think you're confused a little with what CF terms as escaping the single quotes It

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Philip Arnold - ASP wrote: I think you're confused a little with what CF terms as escaping the single quotes It converts all single quote types to their real single quote versions for SQL (used in WHERE and such), normally it won't always put the apostrophies in for the INSERT and UPDATE,

Re: Speed of Duplicate

2002-11-04 Thread Jeffry Houser
How are you getting your speeds? Have you done load testing? Or are you just loading a single page and using GetTickCount? At 12:04 AM 11/4/2002 -0500, you wrote: I have three different computers which are exhibiting drastically different speeds executing the Duplicate function. All

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
It is not the only way, and it isn't a guaranteed way unless you rewrite your replace statements for each RDBMS. Each RDBMS uses different escape characters/sequences and delimiters. Use cfqueryparam. This is of course impossible if you're building your SQL in a string first and then running

Converting ASCII characters

2002-11-04 Thread W Luke
Hi. I have a page which enters details via an array into a DB. At the moment, some of the items in the array contain ASCII characters which I need to convert to their proper symbols. For example: James#39; fear of spiders I presume this should read James' fear of spiders. I'd like to convert

RE: Converting ASCII characters

2002-11-04 Thread Robertson-Ravo, Neil (REC)
chr(number) should give you the appropriate character. -Original Message- From: W Luke [mailto:will;lukrative.com] Sent: 04 November 2002 12:18 To: CF-Talk Subject: Converting ASCII characters Hi. I have a page which enters details via an array into a DB. At the moment, some of the

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Philip Arnold - ASP wrote: It is not the only way, and it isn't a guaranteed way unless you rewrite your replace statements for each RDBMS. Each RDBMS uses different escape characters/sequences and delimiters. Use cfqueryparam. This is of course impossible if you're building your SQL in a

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
Not being able to use cfqueryparam (or cfprocparam, which is also a typed variable) is a very good reason not to do that. Apart from that, using TSQL already confines you to using one specific RDBMS, so the exception I mentioned applies. Although I still doubt that somebody not being a

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Philip Arnold - ASP wrote: Saying that, if you're building your systems to work on your hardware, I'd expect you to know the oddities of the RDMS I would expect that too. But experience tells me not many people know how their RDBMS handles the not everyday functionality. If you want true

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Robertson-Ravo, Neil (REC)
your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 12:59 To: CF-Talk Subject: Re: HELP!!

RE: Check Boxes - another NUG question

2002-11-04 Thread Kennerly, Rick H CIV
Worked! Thanks for the advice. What is a bit daunting about CF for newbies is the various valid approaches to accomplish the same task. Rick -Original Message- From: Kreig Zimmerman [mailto:kkz;foureyes.com] Sent: Friday, 01 November, 2002 10:54 To: CF-Talk Subject: Re: Check Boxes

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Stephen Moretti
I would expect that too. But experience tells me not many people know how their RDBMS handles the not everyday functionality. ~sigh~ This is the kind of thing it seems we have to put up with these days... Too many web designers trying to become web developers and making a right hash of it!

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
but if you want to do 50 small inserts in a row, in a row? Do you mean updates of one row of a table or subsequent inserts into a table? I mean inserting 50 rows into a table or multiple tables in the same database sending those requests as separate CFQuery tags is pretty much insane -

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Stephen Moretti wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Because that's 50 connect/deconnect to the database via your DB driver

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Robertson-Ravo, Neil (REC) wrote: your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. We are doing an exercise of the mind on a fictitious database schema here (right Philip?). As such, it is

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. I'm not talking about 50 fields, but 50 rows Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Robertson-Ravo, Neil (REC)
:-) yep, I noticed after your last few posts! :-) -Original Message- From: Philip Arnold - ASP [mailto:pra;aspmedia.co.uk] Sent: 04 November 2002 13:23 To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message your table really should not be 50 fields in size I think a

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Andy Ewings
shove this code at the top of your SP: SET QUOTED_IDENTIFIER OFF What happens? -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:23 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Robertson-Ravo, Neil (REC) wrote: your

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Robertson-Ravo, Neil (REC)
A database is designed to perform SQL queries. Yes, true but I can see what Phil is saying; if you are constantly looping and reconnecting to the DB Server to perform what essentially could be completed with say an SP or a SQL Block then let the SQL Server perform what it is good at SQL. I

RE: Speed of Duplicate

2002-11-04 Thread Mark A. Kruger - CFG
If both duplicate and modules are slow on that computer your issue will probably boil down to memory and swapping. What else is running on that first server? An RDBMS perhaps? -mk -Original Message- From: Christopher P. Maher [mailto:lists;modotech.com] Sent: Sunday, November 03, 2002

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Andy Ewings
I agree with Phil too - let the DB do the work As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Stephen Moretti
Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? Doesn't make any difference As Phil says, you're blitzing your DB connection with 50 queries in a very short period. as opposed to one connect/disconnect and letting your DB do the job it was

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Philip Arnold - ASP wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Basically as you're blitzing the connector, whether it's ODBC or

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Andy Ewings wrote: As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Robertson-Ravo, Neil (REC) wrote: I would say that you would not find that much difference in peformace on basic Select, Insert, Update or Deletes (the standard CF/SQL Combos) but for more complex Joins etc you may find certain degredation in peformance.. Exactly. However, we are

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Andy Ewings
I'm not sure I follow this response? What I was saying/implying is that yes connection pooling would prevent you from having to reconnect from scratch each time but you would still be having to execute multiple SQL queries against the database which, if you got the DB to do it in one hit, would

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Robertson-Ravo, Neil (REC)
then... its one of those things you have to decide on the move... if there is no real degredation then stick with a loop.. all things being equal, the SQL Server and the CF Server should be 100% optimised to handle load... :-p -Original Message- From: Jochem van Dieten

RE: Speed of Duplicate

2002-11-04 Thread Christopher P. Maher
How are you getting your speeds? Have you done load testing? Or are you just loading a single page and using GetTickCount? CF debug option to Show Detailed Processing Time Breakdown. ~| Archives:

RE: last day of month

2002-11-04 Thread Everett, Al
DaysInMonth(Now()) -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: Monday, November 04, 2002 12:56 AM To: CF-Talk Subject: last day of month is there an easy way to generate a lastDayofMonth kinda number, knowing the month/year? want to give the user the

RE: Speed of Duplicate

2002-11-04 Thread Christopher P. Maher
If both duplicate and modules are slow on that computer your issue will probably boil down to memory and swapping. What else is running on that first server? An RDBMS perhaps? The other two computers are running SQL Server but the first is just running IIS, CF5 and pcAnywhere plus whatever

Re: Converting ASCII characters

2002-11-04 Thread W Luke
Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] wrote in message news:AFDBA0DE939BD41195290008C7A448A954D62B@RECCSDEXC2... chr(number) should give you the appropriate character. Hi Neil. That's what I had planned on using, but I'm not sure how I can loop round a string to detect *any* ASCII chr

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Gyrus
- Original Message - From: Jochem van Dieten [EMAIL PROTECTED] --snip-- And besides, I would still implement it without depending on TSQL: cfquery datasource=test cfloop from=1 to=3 index=i INSERT INTO test (testID) VALUEs (cfqueryparam cfsqltype=cf_sql_integer

Re: last day of month

2002-11-04 Thread Eric Dawson
in the days of lotus 123 I used to subtract one day from the first day of the next month e From: Howie Hamlin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: last day of month Date: Mon, 4 Nov 2002 01:02:54 -0500 Try this:

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Andy Ewings wrote: I'm not sure I follow this response? I was taking a wild stab because I had the same with your message :) What I was saying/implying is that yes connection pooling would prevent you from having to reconnect from scratch each time but you would still be having to execute

Server Error

2002-11-04 Thread Shahzad.Butt
Hi My server stopped responding our company's Intranet. I restarted IIS and CFMX services to make it working and it worked. Once restarted then from EVENT VIEWER I found following WARNING The data buffer created for the ColdFusion MX Application Server service in the

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
Gyrus wrote: Isn't it impossible to do this when you're using Access? I don't know. But Access was not really what I had in mind. It would probably have been better to say that it works with any database that adheres to standard X, Y, and Z. Or that it is less database dependent. Jochem

RE: Cfqueryparam and IN

2002-11-04 Thread Robert Everland
Yes this is very neat, thanks to all who posted, that fixed the issue. Very nice. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Friday, November 01, 2002 5:39 PM

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Richard Meredith-Hardy
Hold on a second guys, all Jason said was -This is representative some of the data being inserted. This was a NASTY 550 page file maker pro data base that I'm converting. Some fields are empty some are huge like this one. So I assume with these looped queries all he is trying to achieve is

RE: lists in cfcase

2002-11-04 Thread Brian Ledwith
Specify your list delimiter in the CFCASE, as below... cfoutput cfset variables.Foo=3 cfswitch expression=#variables.Foo# cfcase value=2,4 delimiters=, Do this... /cfcase cfcase value=1,3,5,7,8,10,12 delimiters=, Do that... /cfcase

Re: Converting ASCII characters

2002-11-04 Thread Stephen Moretti
Will, I have a page which enters details via an array into a DB. At the moment, some of the items in the array contain ASCII characters which I need to convert to their proper symbols. For example: James#39; fear of spiders I presume this should read James' fear of spiders. I'd like to

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Andrew Tyrone
This is one solution. The problem here is not that the SQL is being built dynamically -- somehow the thread got off track with that assumption. The real problem is, at least in CF 5.0 (which is the version Jason Kufner is using), single quotes are not escape in a complex variable for whatever

RE: Words

2002-11-04 Thread Ben Doom
Erk -- there wasn't supposed to be an 're' on that -- just a find(). *sigh* This is what I get for posting after my bedtime. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: S. Isaac Dealey [mailto:info;turnkey.to] : Sent: Sunday, November

Re: Converting ASCII characters

2002-11-04 Thread Jochem van Dieten
W Luke wrote: I have a page which enters details via an array into a DB. At the moment, some of the items in the array contain ASCII characters which I need to convert to their proper symbols. For example: James' fear of spiders I presume this should read James' fear of spiders. I'd like

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jim Davis
-Original Message- From: Philip Arnold - ASP [mailto:pra;aspmedia.co.uk] Sent: Monday, November 04, 2002 5:46 AM To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message Not to argue with Ben, but I don't think that PreserveSingleQuotes() is the answer... That function

UPS US Address Validation

2002-11-04 Thread Bryan F. Hogan
In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital

Passing anchor results to a template

2002-11-04 Thread FlashGuy
Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a

Re: UPS US Address Validation

2002-11-04 Thread William Wheatley
:) no attachments allowed to the list - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 10:37 AM Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS'

RE: UPS US Address Validation

2002-11-04 Thread Bryan F. Hogan
Since attachments are not allowed, see http://www.digitalbay.net/verifyaddress.zip Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL

what tag captures data from a web page?

2002-11-04 Thread Ed Gordon
If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon

RE: UPS US Address Validation

2002-11-04 Thread Nick McClure
I would like to know more about this, but you can't send attachments to the list. -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: Monday, November 04, 2002 10:38 AM To: CF-Talk Subject: UPS US Address Validation In case anyone is interested, here

RE: UPS US Address Validation

2002-11-04 Thread Kris Pilles
There is nothing attached. -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: Monday, November 04, 2002 10:38 AM To: CF-Talk Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS' Address

Re: UPS US Address Validation

2002-11-04 Thread Doug
Did you intend to send along a link? This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:doug;dwhite.ws - Original Message - From:

RE: Passing anchor results to a template

2002-11-04 Thread Adrian Lynch
What do you mean by results of the anchor? The name, the href or the text rapped in the tag? -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 15:43 To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor

RE: what tag captures data from a web page?

2002-11-04 Thread Adrian Lynch
cfhttp Ade -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: 04 November 2002 15:49 To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing

cfqueryparam and preservesinglequotes() was RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread S . Isaac Dealey
Of course a lot of this is academic anyway. Jochem is correct of course that much (perhaps all of this) of this is now handled (better) with CFQUERYPARAM. The PreserveSingleQuotes() function was one of the original functions (I believe all the way back to version 1.0). It made sense when

deleteclientvariable on mx not working?

2002-11-04 Thread Smith, Matthew P -CONT(DYN)
I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But

RE: what tag captures data from a web page?

2002-11-04 Thread Ben Doom
cfhttp --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Ed Gordon [mailto:NetDr;callptc.com] : Sent: Monday, November 04, 2002 10:49 AM : To: CF-Talk : Subject: what tag captures data from a web page? : : : If you would, please direct me

RE: Passing anchor results to a template

2002-11-04 Thread Kevin Graeme
How about passing it as a url variable? -Kevin -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 9:43 AM To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is

Re: Passing anchor results to a template

2002-11-04 Thread S . Isaac Dealey
Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a If you're using url

RE: what tag captures data from a web page?

2002-11-04 Thread Mosh Teitelbaum
CFHTTP allows you to retrieve the contents of a webpage. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: Monday, November 04, 2002 10:49 AM

RE: what tag captures data from a web page?

2002-11-04 Thread Gene Kraybill
cfhttp... and then work with the resulting variable, cfhttp.filecontent. Gene Kraybill -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: Monday, November 04, 2002 10:49 AM To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to

RE: Passing anchor results to a template

2002-11-04 Thread FlashGuy
The name On Mon, 4 Nov 2002 15:50:45 -, Adrian Lynch wrote: What do you mean by results of the anchor? The name, the href or the text rapped in the tag? -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 15:43 To: CF-Talk Subject: Passing

RE: what tag captures data from a web page?

2002-11-04 Thread Pascal Peters
cfhttp -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: maandag 4 november 2002 16:49 To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an

Re: what tag captures data from a web page?

2002-11-04 Thread Fregas
are talking about a page from another website? You could use CFHTTP which acts like a web browser and returns all the HTML. Craig - Original Message - From: Ed Gordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:48 AM Subject: what tag captures data

Re: Passing anchor results to a template

2002-11-04 Thread Trishan Singh
Do this a name=test1 id=test1 href=template.cfm?varAnchor=test1test1/a a name=test2 id=test2 href=template.cfm?varAnchor=test2test2/a a name=test3 id=test3 href=template.cfm?varAnchor=test3test3/a then test for which varAnchor was clicked.. would that work it really depends on what you need

Re: UPS US Address Validation

2002-11-04 Thread Trishan Singh
no attachment... i dont think you can post an attachment ... copy past code into msg.. this would be interesting - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:37 AM Subject: UPS US Address Validation In case

CFXML newbie needs help

2002-11-04 Thread SMR
Just trying to do a simple CFXML outputbut the webpage just hangs and doesn't error out or anything.. like its running in a never ending loop..The code below is based on an example from the CFMX New Riders book.. Here is my xsd: ?xml version=1.0 encoding=UTF-8? !-- edited with XMLSPY v5

RE: UPS US Address Validation

2002-11-04 Thread Bryan F. Hogan
Here it is http://www.digitalbay.net/verifyaddress.zip Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original

RE: deleteclientvariable on mx not working?

2002-11-04 Thread Adrian Lynch
I use DeleteClientVariable() alot and it works ok. Try out putting the var after you delete it. cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer)

Re: cfqueryparam and preservesinglequotes() was RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jochem van Dieten
S. Isaac Dealey wrote: cfqueryparam can't perform this function, because a sql variable can't be used as a portion of this query -- without first trapping it in something within the db like sp_executesql mystatement or exec(mystatement) ... So queryparam doesn't change the purpose or

Query works fine in Access, Fails in CF

2002-11-04 Thread Andy Ousterhout
I get the following error on the query, but when cut and past the select into Access, it works fine. The problem appears to be with my Format statements. When I change the 3 instances to Month() it works fine. However, I need 2-digit months for sorting purposes. Any ideas what might be wrong?

Replace in string

2002-11-04 Thread FlashGuy
Hi, I need to output the results as a comma-delimited string. An example of the output from the below code would be like: dir1 dir2 dir3 dir4 dir5 I would like to have: dir1,dir2,dir3,dir4,dir5 Whats wrong with my below syntax? cfdirectory action=LIST directory=d:\books name=DirList

RE: Passing anchor results to a template

2002-11-04 Thread Adrian Lynch
I don't think you need to have the name in there, make it a url variable. Or do you have something else in mind? Ade -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 16:04 To: CF-Talk Subject: RE: Passing anchor results to a template The name On

RE: Passing anchor results to a template

2002-11-04 Thread Douglas.Knudsen
What doth thou mean by 'results'. You can use JavaScript for passing anything you want to another script. Doug -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 10:43 AM To: CF-Talk Subject: Passing anchor results to a template Hi, How can

Re: what tag captures data from a web page?

2002-11-04 Thread cf-talk
Take a look at the CFHTTP tag. -Novak - Original Message - From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 8:05 AM Subject: RE: what tag captures data from a web page? cfhttp -Original Message- From: Ed Gordon

RE: Passing anchor results to a template

2002-11-04 Thread Douglas.Knudsen
ah, so you could do something like this...and this maybe off a little in synatx script function sendDaData(obj) { document.sendform.name.value = obj.name; document.sendform.submit(); } /script form name=sendform action=foo.cfm method=post input type=hidden

RE: CFXML newbie needs help

2002-11-04 Thread Bryan F. Hogan
Looks like you have an extra space, change this line xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd to xsi:noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd Bryan F. Hogan Director of Internet Development Macromedia Certified

OT: Bind 8.1 (on Windows) Gurus?

2002-11-04 Thread Lee Fuller
Have a question (that probably will take all of 3 mins) about Bind 8.1 that I can't seem to resolve. Any gurus around that can contact me off-list? TTAIA Lee ~| Archives:

OT: Autonomy/CF/Clearance

2002-11-04 Thread Timothy Heald
Hi, Do you know something about Autonomy, ColdFusion and are you a current holder of a Secret or above clearance. If so please mail me off list. Thanks, Tim ~| Archives:

RE: Replace in string

2002-11-04 Thread Ben Forta
You are making it too complicated, just use the ListChangeDelims() function. CFSET l=dir1 dir2 dir3 dir4 dir5 CFOUTPUT #ListChangeDelims(l, ,, )# /CFOUTPUT -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 11:24 AM To: CF-Talk Subject:

RE: permission Issue

2002-11-04 Thread Brook Davies
Bobby thanks you. At 12:57 AM 04/11/02 -0500, you wrote: I think the problem might be that Bobby doesn't have permission to read files in the directory above the protected one. And since Bobby is not IUSER, he doesn't have access to the directory above the protected one. ColdFusion is probably

RE: cfqueryparam and preservesinglequotes() was RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Jim Davis
Of course a lot of this is academic anyway. Jochem is correct of course that much (perhaps all of this) of this is now handled (better) with CFQUERYPARAM. The PreserveSingleQuotes() function was one of the original functions (I believe all the way back to version 1.0). It made

RE: Replace in string

2002-11-04 Thread Timothy Heald
Try valueList(dirList.name) Tim -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 11:24 AM To: CF-Talk Subject: Replace in string Hi, I need to output the results as a comma-delimited string. An example of the output from the below code

HTML E-mails with CFMAIL

2002-11-04 Thread Thane Sherrington
I'm trying to create an HTML e-mail that is readable in Eudora. I created an HTML page that works in a browser, but Eudora drops all the formatting. Is there a way to make an HTML e-mail that is readable in Eudora, or can I create the page as a file that I can attach with CFMAIL? Thanks, T

Persistent CFC's in the client scope

2002-11-04 Thread Brook Davies
Can any one explain how you would use client variables and persistence with a CFC? Raymond Camden said it was possible, but I'm not sure how it would work. Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported? Is

RE: Replace in string

2002-11-04 Thread Bryan F. Hogan
Try this CFPARAM NAME=VARIABLES.DIRECTORYLIST DEFAULT= CFDIRECTORY ACTION=LIST DIRECTORY=D:\BOOKS NAME=DirList SORT=name ASC CFLOOP QUERY=DirList CFIF TYPE IS DIR AND FINDNOCASE('.',NAME) IS 0 CFSET VARIABLES.DIRECTORYLIST=VARIABLES.DIRECTORYLIST','NAME /CFIF

RE: deleteclientvariable on mx not working?

2002-11-04 Thread Smith, Matthew P -CONT(DYN)
That's what gets me: If I try to output it immediately afterwards in that section of code, it throws an undefined error, as it should. But on the recursive call, even though the delete was run on the client variable, it is defined. Here's some more code so you can get an idea what I'm trying to

strange error

2002-11-04 Thread Will Swain
Hi, Apologies for the double posting firstly. A client has moved over to a new hosting company, and has started getting this error on a fairly standard page that never threw an error before: Corrupt form data: no leading boundary: != -7d21a0e60332 Any ideas what

RE: Autonomy/CF/Clearance

2002-11-04 Thread Adrian Lynch
I know a secret :OD -Original Message- From: Timothy Heald [mailto:healdt;dsmail.state.gov] Sent: 04 November 2002 16:45 To: CF-Talk Subject: OT: Autonomy/CF/Clearance Hi, Do you know something about Autonomy, ColdFusion and are you a current holder of a Secret or above

RE: Server Error-Urgent

2002-11-04 Thread Janine Jakim
Mark, Generally I'd agree with you about queries needing to do the work/calculations...However, this is just basic selects. And so each student has 60+ per quarter. I don't see how to get it to print out one student per page if there are 60+ entries per student. Putting it all in one query makes

Re: CFXML newbie needs help

2002-11-04 Thread SMR
Didn't solve the problem. - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 11:38 AM Subject: RE: CFXML newbie needs help Looks like you have an extra space, change this line xsi:

RE: Persistent CFC's in the client scope

2002-11-04 Thread Everett, Al
Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported? Is the client variable method of maintaining state being replaced by J2EE sessions? Is J2EE sessions even the right term for this new way of storing session

CFMX architecutre question

2002-11-04 Thread Douglas.Knudsen
Ok, so in CFMX when a cfm is called up, a Java Class file is created and blah...blah.blah. What happens to those class files? Are they deleted at some point? When I build out a box, I put CF on the C drive which sits pretty on its own SMALL partition. I don't want to run out of disk

Re: Persistent CFC's in the client scope

2002-11-04 Thread S . Isaac Dealey
Can any one explain how you would use client variables and persistence with a CFC? Raymond Camden said it was possible, but I'm not sure how it would work. Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported?

Re: Persistent CFC's in the client scope

2002-11-04 Thread S . Isaac Dealey
Or you could just store the CFC's properties each in individual client variables and use them to instantiate the component. No wddx overhead -- doable on each page request if desireable. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Can any one explain

RE: deleteclientvariable on mx not working?

2002-11-04 Thread Adrian Lynch
I guess the think to do is step through your code with cfoutput#CLIENT.wddxFormBuffer#/cfoutputcfabort and trace down the offending bit of code. I doubt it will be a cfmx bug, but then again. :OP Ade -Original Message- From: Smith, Matthew P -CONT(DYN)

RE: CFXML newbie needs help

2002-11-04 Thread Bryan F. Hogan
Ok then, sorry I could not help :) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: SMR

RE: CFMX architecutre question

2002-11-04 Thread Adrian Lynch
I think you have to edit the web.xml file in wwwroot\WEB-INF\web.xml I just opened it up and it looks like this bit context-param param-namecoldfusion.compiler.outputDir/param-name param-value/WEB-INF/cfclasses/param-value descriptionThis is the directory where we

Re: HTML E-mails with CFMAIL

2002-11-04 Thread S . Isaac Dealey
I'm trying to create an HTML e-mail that is readable in Eudora. I created an HTML page that works in a browser, but Eudora drops all the formatting. Is there a way to make an HTML e-mail that is readable in Eudora, or can I create the page as a file that I can attach with CFMAIL? Thanks,

RE: Replace in string

2002-11-04 Thread Jim Davis
Hi, I need to output the results as a comma-delimited string. An example of the output from the below code would be like: dir1 dir2 dir3 dir4 dir5 I would like to have: dir1,dir2,dir3,dir4,dir5 Whats wrong with my below syntax? cfdirectory action=LIST directory=d:\books

  1   2   3   >