RE: ValueList() Error

2004-06-11 Thread Robertson-Ravo, Neil (RX)
Hi Dave, Yes this the strangest thing, I am on SQL Server 2000 and its happening on 4 out of 5 servers - the settings on all are the same?! N _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: 10 June 2004 20:32 To: CF-Talk Subject: RE: ValueList() Error Steve, Theoretically, it

RE: REFind alternative?

2004-06-11 Thread Pascal Peters
You cant do it all in once: You will need two passes. Here is a function that will do what you want: cfscript function REFindAndReplace(string,regexp,substring){ var caseSensitive = true; var scope = one; var returnSubexpressions = false; var stReturn = StructNew(); var stTmp = StructNew();

Re: UTF-8 Encoding on CF5

2004-06-11 Thread Paul Hastings
cfscript JObj = createobject(java, java.lang.String); jObj.getBytes(UTF-8); testString = My test string. /cfscript probably should be (though that test string will be indistinguishable from ASCII.): cfscript testString = My test string.; JObj = createobject(java,

Re: Re[2]: OT: how to view client abortions ?

2004-06-11 Thread Mark Drew
Back to the topic ... Depending on the machine setup (with multiple virtual hosts) you can have different logfiles. *I have using apache* does this help? or is it all going into one file? MD On Thu, 10 Jun 2004 22:27:43 +0200, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: oops. sorry. I hope I

RE: Reliably stripping out only the email address?

2004-06-11 Thread Pascal Peters
Bryan, If you want to strip all email addresses like below, use this: REReplaceNoCase(str,[EMAIL PROTECTED],}?,,all) If you want to extract the email address: REReplaceNoCase(str,^.*([EMAIL PROTECTED],}).*$,\1) Pascal -Original Message- From: Bryan F. Hogan [mailto:[EMAIL

Re: UTF-8 Encoding on CF5

2004-06-11 Thread dr
probably should be (though that test string will be indistinguishable from ASCII.): cfscript testString = My test string.; JObj = createobject(java, java.lang.String).init(testString); jObj.getBytes(UTF-8); /cfscript cfdump var=#jObj# in mx you can do: testString.getBytes(UTF-8); if this an

RE: Using cflock and when under different circumstances

2004-06-11 Thread Hoe
ok...thats helped a little but all I see locking around are cfset. What about a cfloop thats calling in a SESSION.varaible like below. Does it also get wrapped with cflock? I'm really confused. cflock timeout=10 type=EXCLUSIVE scope=SESSION cfloop index=List list=#SESSION.name# /cfloop /cflock

CFComet.com

2004-06-11 Thread Buddy Langston
Anyone know if it's coming back and/or what happened to it? http://www.cfcomet.com Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: OT: Page design Contact work

2004-06-11 Thread Rick Root
Andy Ousterhout wrote: I am looking for contractor who could build a page that prints an invoice. Specifically I need to the page to: 1.When called, create a print-formatted invoice that isn't displayed and automatically open windows print dialog.Environment is IE 6.0, _javascript_ enabled

Re: OT: Page design Contact work

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 13:12 pm, Rick Root wrote: a solution, I'd be curious to know what it is =) Open a very small (or off screen, depending on IE version) pop-up window with the invoice in, and invoke the print requestor in normal way. Hidden frame/iframe may work too, I guess. -- Tom

Re: OT: Page design Contact work

2004-06-11 Thread Rick Root
Thomas Chiverton wrote: On Friday 11 Jun 2004 13:12 pm, Rick Root wrote: a solution, I'd be curious to know what it is =) Open a very small (or off screen, depending on IE version) pop-up window with the invoice in, and invoke the print requestor in normal way. Hidden frame/iframe may

RE: OT: Page design Contact work

2004-06-11 Thread Tony Weeg
you can send a pdf to a printer without a printer dialog box popping up, cant you? so, do the reports in pdf, forget about html pages. tw -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 8:28 AM To: CF-Talk Subject: Re: OT: Page design Contact

Finding the current directory of a script

2004-06-11 Thread Mark Drew
Is there a reliable way of finding the current directory that a script is running in? I want to be able to then use a cffile write . My current (misguided) throughts are working along the lines of reverese the CGI.PathTranslated, remove the chars up to the first ocurrance of \ and then

RE: Finding the current directory of a script

2004-06-11 Thread Raymond Camden
getCurrentTemplatePath() will do it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: ValueList() Error

2004-06-11 Thread alexander sicular
I have also just come across this problem only yesterday. I was using valuelist inside a listfind like so : listfind(valuelist(query.booleancolumn),1) I had to change 1 to true to get it to work as expected. This only happens with bit column from mssql2k. when dumping the query that contains

Re: Finding the current directory of a script

2004-06-11 Thread Mark Drew
Thanks for that, I am using CF5 tho hence the silly question :) On Fri, 11 Jun 2004 08:06:11 -0500, Raymond Camden [EMAIL PROTECTED] wrote: getCurrentTemplatePath() will do it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: OT: Page design Contact work

2004-06-11 Thread Hugo Ahlenius
Another alternative: have a nice thank you bla bla message displayed with the css/media/screen and the invoice with the css/media/print (then hide the thank you) -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer

RE: Using cflock and when under different circumstances

2004-06-11 Thread Raymond Camden
As Barney said, it matters how you are using the variable. Don't worry about cfset, cfloop, or ANY cf tag. Ask yourself - when I use this variable, do I care if another request modifies it? So, consider cfloop. Let's say you want to loop over session.name and display the results. Maybe it is

Character encoding - CFMX and SQL

2004-06-11 Thread Mark A. Kruger - CFG
Folks, I have an international customer who was running on Access and we moved from cfmx 6.0 to cfmx 6.1 and from access to MsSQL 2000. Prior to the move when he updated a table on access it worked fine. After the move when he updates and uses language specific characters (Italian) it changes the

RE: ValueList() Error

2004-06-11 Thread Robertson-Ravo, Neil (RX)
Thanks, I was going to do the same - I think I will also...this is worrying as value in the database is 0 or 1 and NOT true or false (note the use of quotes).Yes you can argue that 0 and 1 is true and false but the data held in the DB states 0 and 1 explicitly and it should stay that way. N

CF Hosting for non-profits

2004-06-11 Thread Sparrow-Hood, Walter
Walt Does anyone know of any CF hosting providers that provide reduced pricing for non-profits, i.e. a church.It will be a small site but I want to provide some CF functionality. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Character encoding - CFMX and SQL

2004-06-11 Thread Mark Drew
you have to create the columns in MS SQL as nVarchar so that they can cope with international chraracters... Regards On Fri, 11 Jun 2004 08:22:31 -0500, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Folks, I have an international customer who was running on Access and we moved from cfmx

Can a spider create a session?

2004-06-11 Thread Bryan F. Hogan
If I create a page that sets a value in the session or in a cookie, which one if any can be read by a spider somehow? I'm not talking about a spider reading the page, I'm talking about a spider reading the request, headers or something to retrieve the values of cookies and sessions if thats

cfdump the cfcatch variable struct

2004-06-11 Thread Tony Weeg
if I run this code, with a c:\cfusion\runtime\servers\lib path present on my server cftry cfquery name=tony datasource=#usersDSN# select * from companyTables /cfquery cfcatch type=any cfdump var=#cfcatch# /cfcatch /cftry I get this response... [unknown type] however, if I remove the

Re: Can a spider create a session?

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 14:29 pm, Bryan F. Hogan wrote: Anyone know? Of course it is - cookies are just set in the HTTP stream like anything else. If you're going to ask if any spiders are currently actualy doing this, I dunno :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel:

RE: ValueList() Error

2004-06-11 Thread Robertson-Ravo, Neil (RX)
I have the gripe that its not happening on one server.SQL2K, CFMX 6.1 etc...i.e. the same settings all around _ From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 14:18 To: CF-Talk Subject: RE: ValueList() Error Thanks, I was going to do the same - I think

Re: Can a spider create a session?

2004-06-11 Thread Philip Arnold
On Fri, 11 Jun 2004 09:29:25 -0400, Bryan F. Hogan wrote: If I create a page that sets a value in the session or in a cookie, which one if any can be read by a spider somehow? I'm not talking about a spider reading the page, I'm talking about a spider reading the request, headers or

Dumb UDF quesiton with local variables

2004-06-11 Thread C. Hatton Humphrey
Okay, I know that I'm guilty of not scoping variables here when it comes to what I consider local internal variables... things like a temp. date to be used or something along those lines.However is there something that I am missing when it comes to UDF's and reusing variable names? I just ran

RE: ValueList() Error

2004-06-11 Thread Robertson-Ravo, Neil (RX)
I have the gripe that its not happening on one server.SQL2K, CFMX 6.1 etc...i.e. the same settings all around _ From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 14:18 To: CF-Talk Subject: RE: ValueList() Error Thanks, I was going to do the same - I think

Re: Can a spider create a session?

2004-06-11 Thread Bryan F. Hogan
Ok, the reason I ask is because I was asked if sensitive information should be hashed before they set it in a session. I said yes. Thanks for confirming my suspicions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Dumb UDF quesiton with local variables

2004-06-11 Thread Raymond Camden
Yep, to localize a variable, just use the var scope: function jedisDoItWithTheForce(x,y) { var theDate = ; var whatever = 1; //code } 2 rules: Var scope declarations MUST come before any other lines of code. So, they have to be on top. You MUST declare a value for the variable, even if you

Re: SSHA hash checking

2004-06-11 Thread Tony Pimm
SSHA stands for Secure Salted Hashing Algorithm, and can be used in LDAP to hash user passwords. Using your code below, how can I use this to hash a value? Tony What's SSHA?If you means just SHA, you can get a SHA hasher direct from the JRE: cfset shaHasher = createObject(java,

chars not accepted in SQL?

2004-06-11 Thread Robert Orlini
I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as John's in the input field: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax near 's'. SQL = INSERT INTO itemsordered Is

RE: Dumb UDF quesiton with local variables

2004-06-11 Thread C. Hatton Humphrey
Yep, to localize a variable, just use the var scope: Okay, I'm confused even more now... I thought that UDF's in CF5 were done inside of CFScript and in MX are done using CFFunction - that's how I've been doing it. Here's the UDF that was causing the problem - cffunction name=SetDefaultValues

Re: Dumb UDF quesiton with local variables

2004-06-11 Thread Philip Arnold
On Fri, 11 Jun 2004 09:45:38 -0400, C. Hatton Humphrey wrote: Yep, to localize a variable, just use the var scope: Okay, I'm confused even more now... I thought that UDF's in CF5 were done inside of CFScript and in MX are done using CFFunction - that's how I've been doing it. MX can do

Re: chars not accepted in SQL?

2004-06-11 Thread Philip Arnold
On Fri, 11 Jun 2004 09:36:26 -0400, Robert Orlini wrote: I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as John's in the input field: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10:

RE: Dumb UDF quesiton with local variables

2004-06-11 Thread Raymond Camden
On Fri, 11 Jun 2004 09:45:38 -0400, C. Hatton Humphrey wrote: Yep, to localize a variable, just use the var scope: Okay, I'm confused even more now... I thought that UDF's in CF5 were done inside of CFScript and in MX are done using CFFunction - that's how I've been doing it.

RE: Page design Contact work

2004-06-11 Thread Sparrow-Hood, Walter
Check out ScriptX - it gives additional format control for printing. http://www.meadroid.com/scriptx/index.asp Walt -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 9:32 PM To: CF-Talk Subject: OT:Page design Contact work I am looking

RE: Character encoding - CFMX and SQL

2004-06-11 Thread Mark A. Kruger - CFG
Yes - I know that one. In fact, the old data is stored, retrieved anddisplayed correctly.All the character columns are unicode columns (nvarchar - ntext). -mark -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 8:28 AM To: CF-Talk Subject: Re:

Evaluate error in update multiple records

2004-06-11 Thread Spectrum WebDesign
Hi all.This is my simple dynamic form fields: TR TD INPUT type=hidden name=deptID value=0550EA15-795D-1267-36B0D328F38698EEBR INPUT class=fields maxLength=30 size=50 name=dept_0550EA15-795D-1267-36B0D328F38698EE value=New YorkBR INPUT type=hidden name=deptID

RE: chars not accepted in SQL?

2004-06-11 Thread Pascal Peters
Use cfqueryparam!! -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 15:36 To: CF-Talk Subject: chars not accepted in SQL? I get this error when I click SUBMIT in a form where I have an

RE: Evaluate error in update multiple records

2004-06-11 Thread Burns, John D
One thing I noticed is that in your dept_#x# input, you don't have a TYPE defined for that input.Not sure if that's the problem or not.I know I've run into problems before with using dashes - in my form field names.That could be it. John -Original Message- From: Spectrum WebDesign

Re: Can a spider create a session?

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 14:39 pm, Bryan F. Hogan wrote: Ok, the reason I ask is because I was asked if sensitive information should be hashed before they set it in a session. I said yes. Thanks for NaP. General rule of 'don't trust the client' applies. -- Tom Chiverton Advanced ColdFusion

RE: Evaluate error in update multiple records

2004-06-11 Thread Pascal Peters
- is not allowed in a var name. Treat the form scope as a struct and it will work (it's not a good idea to use evaluate anyway). CFIF IsDefined('form.deptID') cfoutput cfloop list = #Form.dept_ID# index = ID cfset thisField = dept_ ID ThisField= #ThisField#BR Right = #ID#br #Form[thisfield]#

RE: Using cflock and when under different circumstances

2004-06-11 Thread Hoe
Yes. I'm using CF5. On Fri, 11 Jun 2004 08:13:13 -0500, Raymond Camden wrote: As Barney said, it matters how you are using the variable. Don't worry about cfset, cfloop, or ANY cf tag. Ask yourself - when I use this variable, do I care if another request modifies it? So, consider cfloop. Let's

RE: chars not accepted in SQL?

2004-06-11 Thread Robert Orlini
I have an apostrophe in the input filed before I submit yes. How does this CFQUERYPARAM go into the Insert? The sample code I got below confused me. Sorry folks I'm a newbie at this, but I'm doing my best to try. SELECT STATEMENT WHERE column_name = cfqueryPARAM value = parameter value

Ot: 200 meg log file

2004-06-11 Thread Kristopher Pilles
Anyone have any ideas as to how we can read and extract some data form a 200 meg log file I'm not sure if our cf server can handle this Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher

Re: Can a spider create a session?

2004-06-11 Thread Bryan F. Hogan
NaP. General rule of 'don't trust the client' applies. What is NaP? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: How does CFmail work? Under the hood.

2004-06-11 Thread Mark W. Breneman
Anyone have an idea?? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 3:56 PM To: CF-Talk Subject: How does CFmail work? Under the

Re: Ot: 200 meg log file

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 15:12 pm, Kristopher Pilles wrote: Anyone have any ideas as to how we can read and extract some data form a 200 meg log file I'm not sure if our cf server can handle this Extract what ? grep / tail / head / sed / awk is the default answer :-) -- Tom Chiverton

Re: chars not accepted in SQL?

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 15:07 pm, Robert Orlini wrote: CFQUERYPARAM go into the Insert? The sample code I got below confused me. In most cases instead of dbFieldName=#thing# you write dbFieldName=cfqueryparam value=#thing# (If the query is in a loop,) it'll execute much faster too. -- Tom

Re: Can a spider create a session?

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 15:12 pm, Bryan F. Hogan wrote: NaP. What is NaP? As in a NaN (Not A Number) error, Not A Problem. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5

Re: Dumb UDF quesiton with local variables

2004-06-11 Thread Philip Arnold
On Fri, 11 Jun 2004 08:52:49 -0500, Raymond Camden wrote: cffunction name=SetDefaultValues returntype=query access=private output=false cfargument name=UseDate required=yes cfset var DateStart = CreateDate(Year(UseDate), Month(UseDate), 1) cfset var NumDays = DaysInMonth(DateStart) cfset var

Re: CF Hosting for non-profits

2004-06-11 Thread Doug White
we do == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == - Original Message - From:

RE: Finding the current directory of a script

2004-06-11 Thread Pascal Peters
Why? This even works in CF4! -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 15:10 To: CF-Talk Subject: Re: Finding the current directory of a script Thanks for that, I am using CF5 tho hence the silly question :) On Fri, 11 Jun

RE: Evaluate error in update multiple records - RESOLVED

2004-06-11 Thread Spectrum WebDesign
Thanx Pascal... works fine now Great job... Thanx once more again. - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 11 Jun 2004 16:09:10 +0200 To: CF-Talk [EMAIL PROTECTED] Subject: RE: Evaluate error in update multiple records - is not allowed in a var name.

Re: How does CFmail work? Under the hood.

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 15:13 pm, Mark W. Breneman wrote: Anyone have an idea?? Nope, doesn't look like it. You can probably figure out the answer by dumping the port 25 traffic though (tetheal/tcpdump/etc.). -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL

Message Board

2004-06-11 Thread CFDEV
Hi All, I know it's been discuss many time but in the archive, I can't satisfy myself with the answers. Could someone suggest a good forum/message board in CF for a good price? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: chars not accepted in SQL?

2004-06-11 Thread Philip Arnold
On Fri, 11 Jun 2004 10:07:15 -0400, Robert Orlini wrote: I have an apostrophe in the input filed before I submit yes. How does this CFQUERYPARAM go into the Insert? The sample code I got below confused me. Sorry folks I'm a newbie at this, but I'm doing my best to try. insert into table

RE: chars not accepted in SQL?

2004-06-11 Thread Pascal Peters
INSERT INTO tbl(col) VALUES(cfqueryparam cfsqltype=CF_SQL_CHAR value=#myvar#) Whenever you have a value, use cfqueryparam with the appropriate cfsqltype Pascal -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 16:07 To: CF-Talk Subject:

CFMail Limit?

2004-06-11 Thread Janine Jakim
I have a conference application. On the admin page the user can send an email to notify the presenter on if their proposal has been accepted.It then shows in the database if the person was notified and the date. This piece doesn't seem to be working properly. What is working: The query pulls all

Re: Character encoding - CFMX and SQL

2004-06-11 Thread Paul Hastings
language specific characters (Italian) it changes the characters to a question mark in the DB.Note, the old data in the db is stored and displayed correctly (wiht the right characters) since you're using N datatypes, are you using unicode hinting (for instance VALUES (N'Nel cominciare

RE: chars not accepted in SQL?

2004-06-11 Thread Robert Orlini
Thanks. I have it down as: CFQUERY name=addPO datasource=purchaseorders INSERT INTO itemsordered (item) VALUES ('cfqueryparam value=#Trim(session.item[i][2])# cfsqltype=CF_SQL_CHAR') /cfquery It still gives a incorrect syntax error. How do I correctly incorporate that into the above

cffunction help needed (re performance issue)

2004-06-11 Thread bbetts
I have inherited a CFMX application where there is a huge page of queries that are each wrapped in a function.That udf file is then included in every page.We've got resource and performance issues but I've got the problem that management wants to forge ahead with things as is (while dealing with

RE: Message Board

2004-06-11 Thread Tangorre, Michael
Could someone suggest a good forum/message board in CF for a good price? http://www.fusetalk.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: chars not accepted in SQL?

2004-06-11 Thread Philip Arnold
On Fri, 11 Jun 2004 10:22:57 -0400, Robert Orlini wrote: I have it down as: CFQUERY name=addPO datasource=purchaseorders INSERT INTO itemsordered (item) VALUES ('cfqueryparam value=#Trim(session.item[i][2])# cfsqltype=CF_SQL_CHAR') /cfquery It still gives a incorrect syntax error.

RE: Dumb UDF quesiton with local variables

2004-06-11 Thread C. Hatton Humphrey
Note the use of var in the cfset statement. But it comes down to code typing then Excellent, thanks for the answers! Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.699 / Virus Database: 456 - Release Date: 6/4/2004

RE: chars not accepted in SQL?

2004-06-11 Thread Robert Orlini
Thanks all. I'm slowlly...getting the hang of everything. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 10:21 AM To: CF-Talk Subject: Re: chars not accepted in SQL? On Fri, 11 Jun 2004 10:07:15 -0400, Robert Orlini wrote: I have an

RE: chars not accepted in SQL?

2004-06-11 Thread Pascal Peters
No need for ' with cfqueryparam: VALUES (cfqueryparam value=#Trim(session.item[i][2])# cfsqltype=CF_SQL_CHAR) -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 16:23 To: CF-Talk Subject: RE: chars not accepted in SQL? Thanks. I have

RE: chars not accepted in SQL?

2004-06-11 Thread Tangorre, Michael
CFQUERY name=addPO datasource=purchaseorders INSERT INTO itemsordered (item) VALUES ('cfqueryparam value=#Trim(session.item[i][2])# cfsqltype=CF_SQL_CHAR') /cfquery It still gives a incorrect syntax error. How do I correctly incorporate that into the above insert? Get

Re: Dumb UDF quesiton with local variables

2004-06-11 Thread Calvin Ward
I'm pretty sure you can do cfset var myVariable = 1 in cfmx as well - Calvin -Original Message- From:Philip Arnold Date:6/11/04 9:49 am To:CF-Talk Subj:Re: Dumb UDF quesiton with local variables On Fri, 11 Jun 2004 09:45:38 -0400, C. Hatton Humphrey wrote: Yep, to localize a

Re: CFMail Limit?

2004-06-11 Thread Thomas Chiverton
On Friday 11 Jun 2004 15:23 pm, Janine Jakim wrote: Any ideas?? Check the CF mail log. Check the mailserver mail log. Look in the CF mail spool. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey

Re[4]: OT: how to view client abortions ?

2004-06-11 Thread Uwe Degenhardt
Hi Mark, yes we have IIS, but I don't see, which one I could take. Status-Code 200 doesn't give me the right information. How would you do this on your Apache ? Infact we have more than one virtual log as well, so that shouldn't be the problem. Uwe MD Back to the topic ... MD Depending on the

On Error Resume Next

2004-06-11 Thread Asim Manzur
In ASP we use On Error Resume Next What is the replacement statement in Coldfusion cftry --- cfcatch type=exception /cfcatch /cftry I mean i have to cut/paste codes in both blocks, cftry and cfcatch? So, if error comes it will still run the codes in

Re[2]: Ot: 200 meg log file

2004-06-11 Thread Uwe Degenhardt
Can you import them to MS-Access or another database ? I did that once with a 30 Meg-raw log file. The delimiter should then be the space (space-key) between the columns. Uwe -- Best regards, Uwe mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

RE: Character encoding - CFMX and SQL

2004-06-11 Thread Mark A. Kruger - CFG
Paul, THAT is the answer I'm looking for -thanks! -Mark -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 9:28 AM To: CF-Talk Subject: Re: Character encoding - CFMX and SQL language specific characters (Italian) it changes the characters to

RE: cffunction help needed (re performance issue)

2004-06-11 Thread Calvin Ward
I would think that true instead of yes would be fine. I actually prefer it.If the functions are not actually being invoked it may not be an issue on the queries.. -Original Message- From:[EMAIL PROTECTED] [EMAIL PROTECTED] Date:6/11/04 10:32 am To:CF-Talk Subj:cffunction help needed (re

Re: cffunction help needed (re performance issue)

2004-06-11 Thread Dain Anderson
I would personally turn that UDF file into a CFC, then invoke it with CreateObject() instead of including it. Unfortunately, you'd have to prefix your function calls with the object name you give it, but I think this would be much less intensive on server load. -Dain [EMAIL PROTECTED] [EMAIL

cfdump issue (could hotfixes do this?)

2004-06-11 Thread Tony Weeg
if I run this code, with a c:\cfusion\runtime\servers\lib path present on my server cftry cfquery name=tony datasource=#usersDSN# select * from companyTables /cfquery cfcatch type=any cfdump var=#cfcatch# /cfcatch /cftry I get this response... [unknown type] however, if I remove the

RE: On Error Resume Next

2004-06-11 Thread Dave Watts
In ASP we use On Error Resume Next What is the replacement statement in Coldfusion cftry --- cfcatch type=exception /cfcatch /cftry I mean i have to cut/paste codes in both blocks, cftry and cfcatch? So, if error comes it will still run the codes in cfcatch

Re: Finding the current directory of a script

2004-06-11 Thread Mark Drew
Tis true! I hang myself in shame for not knowing that funciton!. My actual question was is there a quick (like the previous function) way to get the actual directory, so that I can appent my own filename etc. how I solved it is something along the lines of: cfscript rev =

RE: OT: Page design Contact work

2004-06-11 Thread Ian Skinner
To have a different display and print screens I would do something like this. html head style media=screen .screen {display: block;} .print {display: none;} /style style media=print .screen {display: none;} .print {display: block;} /style /head body div class=screen This content will

Right() and string manipulation help

2004-06-11 Thread cf coder
Hello everybody, Please can someone show me how to do this. I have a comma separated list. cfset itemList = item_id1, item_id2, item_id3, item_id11, item_id12, item_id13. I want to loop through this list and get the character(s) after the item_id (in this case: 1,2,3,11,12,13) Here is the code

Re: Right() and string manipulation help

2004-06-11 Thread Mark Drew
cfloop list=#itemList# index=thisItem cfset itemNo = Replace(thisItem, item_id,) cfoutput#itemNo#/cfoutput /cfloop On Fri, 11 Jun 2004 08:30:51 -0700 (PDT), cf coder [EMAIL PROTECTED] wrote: Hello everybody, Please can someone show me how to do this. I have a comma separated list. cfset

Re: Right() and string manipulation help

2004-06-11 Thread Dain Anderson
You could use a little RegEx to do that: CFLOOP LIST=#itemList# INDEX=i DELIMITERS=, #REReplace(i, [^0-9], , ALL)# /CFLOOP -Dain cf coder wrote: Hello everybody, Please can someone show me how to do this. I have a comma separated list. cfset itemList = item_id1, item_id2, item_id3,

RE: Finding the current directory of a script

2004-06-11 Thread Raymond Camden
getDirectoryFromPath() [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Flushing CFCACHE

2004-06-11 Thread Robert Shaw
Is there a method for flushing individual pages from trusted cache within CFMX? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Right() and string manipulation help

2004-06-11 Thread cf coder
I don't want to replace it. I want everything after item_id cfloop list=#itemList# index=thisItem cfset itemNo = Replace(thisItem, item_id,) cfoutput#itemNo#/cfoutput /cfloop On Fri, 11 Jun 2004 08:30:51 -0700 (PDT), cf coder [EMAIL PROTECTED] wrote: [Todays Threads] [This Message]

RE: Finding the current directory of a script

2004-06-11 Thread Tim Blair
My actual question was is there a quick (like the previous function) way to get the actual directory How about: getDirectoryFromPath(getCurrentTemplatePath()) Tim. -- --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED -

Re: Right() and string manipulation help

2004-06-11 Thread George Abraham
Is that better performance/resource-wise? Using regular expressions, that is? George At 11:39 AM 6/11/2004, Dain Anderson wrote: You could use a little RegEx to do that: CFLOOP LIST=#itemList# INDEX=i DELIMITERS=, #REReplace(i, [^0-9], , ALL)# /CFLOOP -Dain cf coder wrote: Hello everybody,

Re: Finding the current directory of a script

2004-06-11 Thread Mark Drew
I reutrn to my hole shaking my head in disgust at my useless self. Call myself a CF developer?! TUT! Thanks for your (elegant) help! On Fri, 11 Jun 2004 16:36:11 +0100, Tim Blair [EMAIL PROTECTED] wrote: My actual question was is there a quick (like the previous function) way to get the

Re: Right() and string manipulation help

2004-06-11 Thread cf coder
Sorry Mark... my bad, your code was right. Thanks Dain [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Flushing CFCACHE

2004-06-11 Thread Tony Weeg
restart server ;) -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 11:40 AM To: CF-Talk Subject: Flushing CFCACHE Is there a method for flushing individual pages from trusted cache within CFMX? TIA, Robbie [Todays Threads] [This Message]

RE: Flushing CFCACHE

2004-06-11 Thread Dave Watts
Subject: Flushing CFCACHE Is there a method for flushing individual pages from trusted cache within CFMX? Yes, you can flush pages from trusted cache: 1. Disable Trusted Cache. 2. Run the page. 3. Enable Trusted Cache. It's worth pointing out that Trusted Cache isn't the same as CFCACHE.

Re: Right() and string manipulation help

2004-06-11 Thread Dain Anderson
This is a pretty simple _expression_, and I would doubt the additional processing needed is noticeable. The reason I suggested it is because it's the only sure-fire way of grabbing just the number, irregardless of the preceeding value, respectfully. George Abraham wrote: Is that better

Re: Right() and string manipulation help

2004-06-11 Thread George Abraham
Ah, just curious. Thanks! George At 11:53 AM 6/11/2004, Dain Anderson wrote: This is a pretty simple _expression_, and I would doubt the additional processing needed is noticeable. The reason I suggested it is because it's the only sure-fire way of grabbing just the number, irregardless of the

Re: Message Board

2004-06-11 Thread Mark Drew
Beaten to the post! On Fri, 11 Jun 2004 10:36:22 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: Could someone suggest a good forum/message board in CF for a good price? http://www.fusetalk.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Re: Right() and string manipulation help

2004-06-11 Thread Claude Schneegans
If it is alway item_id, then what you want is always after the 7th character, then how about cfset itemNo = mid(thisItem, 8, ) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this

Re: Re[4]: OT: how to view client abortions ?

2004-06-11 Thread Mark Drew
an alternative idea would be to have an image at the bottom of the first page, that tracks users... I have used this for some sites using PHP (can be done with CF) just by linking to a CF script that logs the requests... not sure how many people stop loading a page and how fast this is because of

Trusted Cache

2004-06-11 Thread Robertson-Ravo, Neil (RX)
Anyone currently using Trusted Cache?Good/Bad? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be

  1   2   >