RE: RegEx to manipulate html tags

2005-04-27 Thread Pascal Peters
REReplace(str, '(img\s[^]*src=)image1\.jpg([^]*)', \1image2.jpg\2, all) Pascal -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 00:52 To: CF-Talk Subject: RegEx to manipulate html tags Does anyone know of a regex that I can use to replace

Re: delimited file upload and parse with JAVA

2005-04-27 Thread Massimo Foti
Massimo, Thanks. THis may be what I'm looking for or I can get enough out of it to do what I want. ps. If you click on sample there appears to be an error on the page. Thanks for the pointer! That's what I get for serving pages with an application/xhtml+xml mime-type to browsers that

Re: Using CF to connect to Windows fax

2005-04-27 Thread JediHomer
I cant seem to see anything obvious, you might want to try dropping the .1 in both cfobject calls, letting COM decide the object version. The other thing to try is to write a COM wrapper, where you can send all the details in say one call and get the wrapper to then talk to the Fax COM object

Re: SOT: HTTP 405 - Resource not allowed

2005-04-27 Thread JediHomer
Have you got something like IISLockDown running, this can be configured to stop posts heads etc? HTH On 4/27/05, Bryan Stevenson [EMAIL PROTECTED] wrote: I'm getting that eror as a result of a form post with an action like so action=/appwebroot/ IIS is logging the POST and the 405 error

Frames woes

2005-04-27 Thread Allan Cliff
Trying to get a set of frames centred on the page based on a 800x600 design for all possible resolutions http://www.cfugspain.org/test/ Why is the bottom frame in grey (IE) / white (Firefox) when it is the same file called in every frame? index.htm HTML HEAD/HEAD FRAMESET ROWS=*,550,*

RE: Frames woes

2005-04-27 Thread Pascal Peters
You have /frame instead of /frameset Pascal -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 11:33 To: CF-Talk Subject: Frames woes Trying to get a set of frames centred on the page based on a 800x600 design for all possible resolutions

Re: CFMX 7 won;t stay running

2005-04-27 Thread Scott Stroz
On 4/26/05, Cameron Childress [EMAIL PROTECTED] wrote: On 4/26/05, Scott Stroz [EMAIL PROTECTED] wrote: On 4/26/05, Connie DeCinko [EMAIL PROTECTED] wrote: How are your system resources? Any possibility you are running short on memory or some such? I don't think so. I have a gig

RE: Frames woes

2005-04-27 Thread Allan Cliff
You're a star! -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 11:44 To: CF-Talk Subject: RE: Frames woes You have /frame instead of /frameset Pascal -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 27 April 2005

Re: cfqueryparam and null values

2005-04-27 Thread Keith Gaughan
Pete Ruckelshaus wrote: OK, here's what I did, a bit more elegant than the first time. I added the following to my UDF library include file: snip Um... why not: function isNullNumeric(str) { return not isNumeric(str); } function isNullString(str) { return len(trim(str)) eq 0; }

cfoutput inside cfoutput with a string coming from a db

2005-04-27 Thread Uwe Degenhardt
Hi list, I have a db-field let us say string_field. Let us assume that this field contains the followingexpression inside the db-field: Hello, my name is cfoutput#form.name#/cfoutput... When I output that with: cfoutput#a#/cfoutput appears Hello, my name is #form.name# So it doesn't

RE: cfoutput inside cfoutput with a string coming from a db

2005-04-27 Thread Micha Schopman
You should store the contents of the form variable name, not the form variable call. CFMX has no known template parsing engines, but my feeling tells me that you have difficulties understanding the principles. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel

Re: cfoutput inside cfoutput with a string coming from a db

2005-04-27 Thread JediHomer
If you remove the cfoutput section from the DB field you can do something like cfoutput#Evaluate(DE(a))#/cfoutput The easier task would be to use a key and search and replace the string, we run a small newsletter app that allows users to embed variables in fields by using known keyword such as

Re: Sessions Across Domains / SSL

2005-04-27 Thread Bert Dawson
Passing cfid and cftoken in the URL to a separate domain on the same server will allow you to share sessions across domains, but only if the server is set NOT to use J2EE sessions (cfadmin server settings memory variables). If you *are* using J2EE sessions then passing the jsessionid in the URL

Re: cfoutput inside cfoutput with a string coming from a db

2005-04-27 Thread Bert Dawson
You could save the dB output to a file, then cfinclude the file. Depending on your particlular situation this could either be a good idea, or a bad one, and possibly anywhere in between. Cheers Bert On 4/27/05, Uwe Degenhardt [EMAIL PROTECTED] wrote: Hi list, I have a db-field let us say

RE: Client.LastVisit

2005-04-27 Thread Marcus Svensson
Well... there must be a way, because CFForums and PHP-forums have this feature. I tried with a JavaScript, but that one updated the cookie everytime I went to a new page on the webpage. ~| Logware (www.logware.us): a new and

RE: Client.LastVisit

2005-04-27 Thread Micha Schopman
What do you expect from lastvisit functionality? A cookie that is updated with each request for the specific domain exactly implements lastvisit functionality correctly. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK

ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
Is something like this possible in SQL? If so, how? cfquery name=getBlah datasource=#DSN# SELECT OrderID, listGetAt(FinalBillTo,2,~) FROM Orders WHERE CustID = 1234 /cfquery Thanks, Che ~| Find out how CFTicket can increase

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Aaron Rouse
I do it in Oracle through a couple of different ways but almost always narrows down to a UDF in Oracle. Comes down to use of the SUBSTR and INSTR functions to find positionings to pull out the data. On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: Is something like this possible in SQL? If

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
ugh, I knew this would be hard to do withbasic SQL... -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 9:53 AM To: CF-Talk Subject: Re: ListGetAt in a SQL Select Statement... is this possible? I do it in Oracle through a couple of different

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
Of course you could return the whole value and then preform the listGetAt on the column but like Aaron said, we normally use Oracle too for things like that. Pull the data correctly out of the DBMS and no fooling with later On 4/27/05, Aaron Rouse [EMAIL PROTECTED] wrote: I do it in Oracle

Re: RegEx to manipulate html tags

2005-04-27 Thread Claude Schneegans
Hi, This is an application for CF_REextract; see: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm?p=hf You could easily get all img tags in a recordset, then loop on the query and analyse them, still using CF_REextract. -- ___ REUSE

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Aaron Rouse
It should not be too hard, you take the value and put a ~ on the end of it. Then you use INSTR (or whatever function your DB has) to find the location of the first ~ then you use SUBSTR(or whatever function your DB has) to pull out the value. So something like this list: one~two would be

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
What DBMS do you have? Access? I'm sure they have similar functions On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: ugh, I knew this would be hard to do withbasic SQL... -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 9:53 AM To:

Re: cfoutput inside cfoutput with a string coming from a db

2005-04-27 Thread Adam Haskell
Uwe if you want to do this you would have to use New Atlanta's Blue Dragon. They have a new function (version 6.2) called Render. It should perform exactly as you are expecting cfoutput#bob#/cfoutput. Adam H On 4/27/05, Micha Schopman [EMAIL PROTECTED] wrote: You should store the contents of

RE: CFMX 7 won;t stay running

2005-04-27 Thread Mark W. Breneman
It seems that the inverse may be true too. Giving CF too much memory can lead to CFMX failing to start under load. http://www.sargeway.com/blog/index.cfm?mode=entryentry=27 I have not seen this problem on CFMX 7 *yet* but about every 4-6 months I would be forced to delete all of the java byte

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
Aaron/Greg... I have M$ SQL Server 2000. I understand the premise of what you say... unfortunately, my CF skills are much better than my MS SQL skills. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:07 AM To: CF-Talk Subject: Re:

CfChart question

2005-04-27 Thread Calvin Ward
Here's the test scenario. Both of the below files live in the same directory. Result: An error which states, Not text elements left If I remove the style attribute, it works fine. If I change the style attribute to yellow, it works fine. If I move the mypie.xml file to the styles

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Aaron Rouse
I was once told that dealing with a list of data in MSSQL was easier than in Oracle. Perhaps someone well versed in MSSQL could chime in with a solution. It probably is not as hard as you think it will be to get done. On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: Aaron/Greg... I have M$

Re: ColdFusion MX 6.1 and 7 on the same server

2005-04-27 Thread Thomas Chiverton
On Tuesday 26 Apr 2005 19:42 pm, wolf2k5 wrote: Can I install CFMX 7 Server Configuration on the same Linux server and use it only for a few Apache virtual hosts, while keeping using CFMX 6.1 for the other virtual hosts? Yes, run it on a different port. -- Tom Chiverton Advanced ColdFusion

RE: Client.LastVisit

2005-04-27 Thread Dave Watts
Well... there must be a way, because CFForums and PHP-forums have this feature. I tried with a JavaScript, but that one updated the cookie everytime I went to a new page on the webpage. I didn't say it couldn't be done, just that the method to do it cannot be guaranteed to be reliable. That

Re: Trouble with web services, complex return objects in 6.1

2005-04-27 Thread Thomas Chiverton
On Tuesday 26 Apr 2005 16:05 pm, Tom Jordahl wrote: Perhaps if this were controlled by a debug switch that could be turned on for development. cfinvoke refreshWSDL=bool ? -- Tom Chiverton Advanced ColdFusion Programmer

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
Hopefully... I asked this once before a couple of years ago, but frankly, the solution was a little difficult for me to figure out. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:17 AM To: CF-Talk Subject: Re: ListGetAt in a SQL Select

RE: CFMX 7 won;t stay running

2005-04-27 Thread Dave Watts
I have not seen this problem on CFMX 7 *yet* but about every 4-6 months I would be forced to delete all of the java byte code files to keep CFMX6 running. I think I tracked it down to a corrupted byte code file(s). I would see CFMX6 shutdown for seemingly no reason. After deleting the

RE: Client.LastVisit

2005-04-27 Thread Marcus Svensson
I don't care about the lastVisit anymore. It does what it's supposed to do. I just want to know if there is a way to do almost the same as lastVisit does, but only updates the parameter when the user has left the webpage. Since the function I'm looking for is used in CFForum and other forums,

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
I think you could use pretty much the same thing.. SQLServer has the substring funstion but uses the Charindex (I think) to find the start position.. So you might want to try something like : substring(mycol, charindex(mycol, '~'), len(mycol - charindex(mycol, '~')) this hasnt been tested, so it

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
I think you'll have th reverse the charindex to this.. charindex('~',mycol) not the way I have above. On 4/27/05, Greg Morphis [EMAIL PROTECTED] wrote: I think you could use pretty much the same thing.. SQLServer has the substring funstion but uses the Charindex (I think) to find the start

RE: Client.LastVisit

2005-04-27 Thread Micha Schopman
Yes you can, but you must think in terms of (and there are more to think off) - Set a time value, on each request reset the time value, if the time value expires the user either is asleep or gone, ergo lastvisit. - Call JavaScript onunload on each window blur, to notify the server of the

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Robertson-Ravo, Neil (RX)
You can do this easily in SQL Server...assumming you have SQL 2000 here is one way using a UDF. Usage: dbo.listGetAt(list, position, delimiter) This function returns the value at the position requested. Requesting a position that is larger than the length of the list will return NULL. Example:

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
would this be done in the select statement? the field type for the column is 'text' and not 'varchar'. i think there would be issues with using charindex on a 'text' field. ugh again... Che -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005

RE: Mozilla Problem with Secure Server

2005-04-27 Thread Damien McKenna
Try this: body onLoad=document.assignvalue.submit(); form name=assignvalue id=assignvalue action=page.html method=post *stuff* /form /body -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Adam Haskell
TEXT for an address? seems like that would be overkillanway it should cast easily enough. Adam H On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: would this be done in the select statement? the field type for the column is 'text' and not 'varchar'. i think there would be issues with

Re: RegEx to manipulate html tags

2005-04-27 Thread Howie Hamlin
Thanks for all of the replies but what I really need to do is append some text in the SRC value. What I mean is to change this: img src=image1.jpg to img src=/root/images/image1.jpg I would like to do this for all images in the text and account for both single and double quotes. Thanks,

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
its way more than just an address. and yes, it is probably overkill. i'm working with someone else's code. -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:39 AM To: CF-Talk Subject: Re: ListGetAt in a SQL Select Statement... is this

Convert to PDF using CFMX or Java

2005-04-27 Thread Ciliotta, Mario
Hi, Does anyone know if it is possible to convert a word doc or a ppt to a PDF on the fly. I need to create an application where the end-users upload either a word or ppt and the system needs to convert it to a PDF. I know how to create PDF on the fly using iText but I have no idea how to

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Robertson-Ravo, Neil (RX)
Dunno...TEXT datatypes don't cast that well - well not implicitly they don't. -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 15:39 To: CF-Talk Subject: Re: ListGetAt in a SQL Select Statement... is this possible? TEXT for an address? seems like

Re: cfqueryparam and null values

2005-04-27 Thread Al Everett
On 4/27/05, Al Everett [EMAIL PROTECTED] wrote: On 4/26/05, Bryan Stevenson [EMAIL PROTECTED] wrote: cfqueryparam value=#Trim(FORM.txtFirstName)# cfsqltype=cf_sql_varchar null=#YesNoFormat(Len(Trim(FORM.txtFirstName))# This is also the technique I use. Of course I put EQ 0 at the end

Re: cfqueryparam and null values

2005-04-27 Thread Al Everett
On 4/26/05, Bryan Stevenson [EMAIL PROTECTED] wrote: cfqueryparam value=#Trim(FORM.txtFirstName)# cfsqltype=cf_sql_varchar null=#YesNoFormat(Len(Trim(FORM.txtFirstName))# This is also the technique I use. -- a href=http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1;Get Firefox!/a

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
Neil, this may work. Are SQL UDF's hard to set up? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:26 AM To: CF-Talk Subject: RE: ListGetAt in a SQL Select Statement... is this possible? You can do this easily in SQL

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Robertson-Ravo, Neil (RX)
Even so, it is not likely to be over 2 Billion Characters in length is it? -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 15:42 To: CF-Talk Subject: RE: ListGetAt in a SQL Select Statement... is this possible? its way more than just an address. and

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
No, there shouldnt be. charindex just returns the position of a character.. the name doesnt imply that it works with varchar only. And yes you'd use it within the select statement.. Select name, substring(mycol, charindex( '~',description), len(mycol - charindex( '~',description)) as descr from

Re: HTTP 405 - Resource not allowed

2005-04-27 Thread Bryan Stevenson
If you post to a URL that doesn't explicitly accept POST requests, you'll get that message. Dave Watts, CTO, Fig Leaf Software Well that much I knowbut I have no idea where to change that setting?? ;-) I wouldn't recommend a file-less post even it worked, personally. Has this ever

RE: Client.LastVisit

2005-04-27 Thread Andy Ousterhout
Look at application.cfc onSessonEnd() Andy -Original Message- From: Marcus Svensson I don't care about the lastVisit anymore. It does what it's supposed to do. I just want to know if there is a way to do almost the same as lastVisit does, but only updates the parameter when the user

Re: cfqueryparam and null values

2005-04-27 Thread Bryan Stevenson
arrrgg...listen to Barney (and me and Dave W)...just do it in the null attributeno silly JS neededyou're making it WAY too complicated and it will be a monster to maintain. sorry for the rantit just pains me to see these kinds of solutions ;-) Bryan Stevenson B.Comm. VP

Build SQL Statement and cfqueryparam

2005-04-27 Thread Tom McNeer
Hi, I need to build a SQL update statement dynamically, based on what form fields are being passed in at a particular time. The database is MS SQL Server. Many of the fields are longish text fields, which may have single quotes within them. I can determine the datatype of each passed field by

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
i agree. while i got ya replying to my emails, what would be the easiest way to find the longest length of characters within this field and then convert the 'text' column to a 'varchar' column with a predetermined max length? -Original Message- From: Robertson-Ravo, Neil (RX)

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Robertson-Ravo, Neil (RX)
Nope they are just like SP's run it in to the system and you can call it: dbo.listGetAt(list, position, delimiter) i.e. dbo.listGetAt(@mylist, 5, ,) -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 15:43 To: CF-Talk Subject: RE: ListGetAt in a SQL

RE: Client.LastVisit

2005-04-27 Thread Dave Watts
I don't care about the lastVisit anymore. It does what it's supposed to do. I just want to know if there is a way to do almost the same as lastVisit does, but only updates the parameter when the user has left the webpage. Since the function I'm looking for is used in CFForum and other

referrer

2005-04-27 Thread Daniel Kessler
I have a WHY menuitem that needs to make a db call depending on the page that brought the user to that WHY page. In javascript, I can use document.referrer to get the url that brought me to the page. How do I do that in CF? -- Daniel Kessler Department of Public and Community Health

RE: CFMX 7 won;t stay running

2005-04-27 Thread Mark W. Breneman
Thanks Dave, I give that a try. Come to think of it, I'm sure it will help our performance on one of our servers. We have 65-70 very low traffic sites on it with tons of cfm files. The server would always run faster after deleting the class files. I feared my performance would drop if I

RE: referrer

2005-04-27 Thread Ian Skinner
Generally cgi.HTTP_REFERER -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005

OT: old MM software installs?

2005-04-27 Thread Damien McKenna
Due to what believe is CDs sprouting legs and running off, we're in need of install files for the following: ColdFusion Studio 5.0 evaluation Studio MX Plus evaluation I can't find them on Macromedia's website and my boss is in need of them having just reinstalled his laptop. Any leads would

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Robertson-Ravo, Neil (RX)
To be safe, just change it to varchar 8000 As for the UDF... they are just like SP's run it in to the system and you can call it: dbo.listGetAt(list, position, delimiter) i.e. dbo.listGetAt(@mylist, 5, ,) -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 27

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
does SQLServer have the aggregate fuction max()? if so.. this will work. select max(len(mycol)) as maxlen from my_table this returns the longest value in that column On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: i agree. while i got ya replying to my emails, what would be the easiest way

RE: Client.LastVisit

2005-04-27 Thread Dave Watts
Look at application.cfc onSessonEnd() Well, actually, that won't track when a user leaves your site. It will only tell you when their session ends, which may be some time later. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber

RE: referrer

2005-04-27 Thread Dave Watts
I have a WHY menuitem that needs to make a db call depending on the page that brought the user to that WHY page. In javascript, I can use document.referrer to get the url that brought me to the page. How do I do that in CF? You can reference that value using the variable CGI.HTTP_REFERER.

RE: old MM software installs?

2005-04-27 Thread Robertson-Ravo, Neil (RX)
I have Studio EvalStudio MX Plus? You can certainly get that onlineyou mean MX 2004? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 16:06 To: CF-Talk Subject: OT: old MM software installs? Due to what believe is CDs sprouting legs and

cfmail bounce

2005-04-27 Thread Kerry
I have a client who has requested a mass email system that will detect email addresses that bounce. Am I right in thinking that this would involve writing code that will login to a pop3 account and scan the headers of each email to discover which addresses have bounced? or is there a simpler way?

Re: Convert to PDF using CFMX or Java

2005-04-27 Thread Bryan Stevenson
I think iText (Java package found at SourceForge) can suck in and convert a Word doc Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com

RE: HTTP 405 - Resource not allowed

2005-04-27 Thread Dave Watts
Well that much I knowbut I have no idea where to change that setting?? You can't change that setting, I don't think. Why would you want to? Why not just specify the correct URL in your form? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest

Re: cfqueryparam and null values

2005-04-27 Thread Bryan Stevenson
This is also the technique I use. Of course I put EQ 0 at the end there. as Dave W corrected me yesterday : null=#YesNoFormat(NOT Len(Trim(FORM.txtFirstName))# I like the use of NOT instead of EQ 0 ...1 less keystroke ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
nope... that does not work... -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:10 AM To: CF-Talk Subject: Re: ListGetAt in a SQL Select Statement... is this possible? does SQLServer have the aggregate fuction max()? if so.. this will

Opinions on Verity?

2005-04-27 Thread Ken Dunnington
I'm spec'ing a new project where we will be archiving, databasing and hopefully indexing/searching around 1,000 PDF files. Obviously, the first thing that comes to mind is Verity. I've only used it to index database text fields up until this point, and wasn't that impressed with it (though my own

Re: RegEx to manipulate html tags

2005-04-27 Thread Claude Schneegans
what I really need to do is append some text in the SRC value. Since CF_REextract also returns the exact position and length of every string in the text searched, these strings can easily be changed, replaced or appended. The trick is to loop backward in the query to make sure the positions of

RE: cfmail bounce

2005-04-27 Thread Damien McKenna
I'm doing exactly that right now. I already have a system for sending newsletters, I'm currently finishing off the part for processing bounces. It is a bit of a PITA. What you need to do is build up a list of what identifies different types of emails - junk, bounced due to an invalid address,

RE: Client.LastVisit

2005-04-27 Thread Marcus Svensson
Found this when googling: Forcing session expiration on browser close. use the following cookies to force sessions to expire a session @ browser close, instead of letting the cookies persist for the length of the session timeout. cfcookie name=CFID value=#Session.CFID# cfcookie name=CFTOKEN

RE: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Che Vilnonis
i got it... needed to convert the text column... -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:17 AM To: CF-Talk Subject: RE: ListGetAt in a SQL Select Statement... is this possible? nope... that does not work... -Original

Re: HTTP 405 - Resource not allowed

2005-04-27 Thread Bryan Stevenson
You can't change that setting, I don't think. Why would you want to? Why not just specify the correct URL in your form? To learn something new ;-) I've read online that it can be changed (but that was not specific to any webserver) I already changed the code to point at a real file and not

Re: RegEx to manipulate html tags

2005-04-27 Thread Howie Hamlin
OK, I'll take a look at this. I read the info on your site and it seems a bit daunting to a non-regex person :) Thanks, Howie --- On Wednesday, April 27, 2005 11:18 AM, Claude Schneegans scribed: --- what I really need to do is append some text in the SRC value. Since CF_REextract also

Re: cfqueryparam and null values

2005-04-27 Thread Barney Boisvert
I'd say that's a slightly kludgy hack that I only mention because the 'right' solution was proposed and overruled. You're implicitly coercing the numeric result returned by 'len' into a boolean value, which works, because of the typeless nature of CF. By using a numeric comparison that returns

RE: old MM software installs?

2005-04-27 Thread Damien McKenna
I found CF Studio, thanks anyway. And its Studio MX Plus, not Studio MX 2004, the first MX one. I guess the plus part meant it came with extras, I really can't say myself. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014

RE: cfmail bounce

2005-04-27 Thread Kerry
use CFX_POP (spend the $20, you won't reget it) Cheers for the tip I *may* open-source some of my code if it takes a lot of work off my hands, I might be able to convince the boss to send a few bucks your way. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: 27

RE: cfqueryparam and null values

2005-04-27 Thread COLLIE David
I'd say that's a slightly kludgy hack that I only mention because the 'right' solution was proposed and overruled. You're implicitly coercing the numeric result returned by 'len' into a boolean value, which works, because of the typeless nature of CF. By using a numeric comparison that

Re: cfqueryparam and null values

2005-04-27 Thread Bryan Stevenson
bah! ;-) yes I do occasionally get the good old cannot convert to boolean but those are sorted before going to prod ;-) I've been doing it since '98...little set in my ways...but I hear ya.. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone:

Password-protecting CFMX web services

2005-04-27 Thread Ben Mueller
Again, sorry if this has been asked and answered, but I scoured the web and this list as best I could, and didn't find a suitable answer. I would like to apply a username and password to some web services I'm creating in CFMX 6.1. I naively assumed that either the cfcomponent or cffunction

RE: cfqueryparam and null values

2005-04-27 Thread Russ
Actually this kind of stuff has been used in C, and as far as I remember c++ and possibly java. In c, there are no Boolean values, so 0 is false, and everything else is true, and I don't remember if C++ introduced Booleans, and I believe java does have Booleans, but in any of those languages, 0

Re: Providers Ignoring DNS TTL?

2005-04-27 Thread Thomas Chiverton
On Friday 22 Apr 2005 19:06 pm, Phill B wrote: how long it will be for some one like AOL to update their DNS? AOL will almost never update their DNS. Why ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover

Re: RegEx to manipulate html tags

2005-04-27 Thread Claude Schneegans
I read the info on your site and it seems a bit daunting to a non-regex person It may looks so, but on the contrary, it is based on the principle that it may sometimes be much easier to find a string based on context before and after than using only one single regex. Then it actually makes

CFCs and CFModule

2005-04-27 Thread Chris Berg
Hello, I am trying execute a CFModule from inside a CFC and having quite a time. When I execute the CFMODULE with an absolute path (from the webroot -- /projects/ASF/index.cfm), I receive an error saying that index.cfm doesn't exist at that location. When I turn execute the CFMODULE with

Re: CFCs and CFModule

2005-04-27 Thread Chris Berg
Additional info: I am calling the CFC via an event gateway. When I call it from the browser, the CFMODULE call isn't a problem. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start

Re: ColdFusion MX 6.1 and 7 on the same server

2005-04-27 Thread wolf2k5
On 4/27/05, Thomas Chiverton [EMAIL PROTECTED] wrote: Yes, run it on a different port. What about the JRun module name conflict reported by Jared? Thanks. ~| Find out how CFTicket can increase your company's customer support

RE: Password-protecting CFMX web services

2005-04-27 Thread Dave Watts
Again, sorry if this has been asked and answered, but I scoured the web and this list as best I could, and didn't find a suitable answer. I would like to apply a username and password to some web services I'm creating in CFMX 6.1. I naively assumed that either the cfcomponent or

RE: cfqueryparam and null values

2005-04-27 Thread Dave Watts
I'd say that's a slightly kludgy hack that I only mention because the 'right' solution was proposed and overruled. You're implicitly coercing the numeric result returned by 'len' into a boolean value, which works, because of the typeless nature of CF. By using a numeric comparison that

RE: HTTP 405 - Resource not allowed

2005-04-27 Thread Dave Watts
To learn something new ;-) I've read online that it can be changed (but that was not specific to any webserver) I already changed the code to point at a real file and not just the dir.but I like answers not questions ;-) It seems to me that you have learned something - explicit URLs

Re: cfqueryparam and null values

2005-04-27 Thread Bryan Stevenson
is marginal at best. But at this point, we might as well be arguing about how many angels can dance on the head of a pin. 5..I counted... Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830

RE: Client.LastVisit

2005-04-27 Thread Dave Watts
Found this when googling: Forcing session expiration on browser close. use the following cookies to force sessions to expire a session @ browser close, instead of letting the cookies persist for the length of the session timeout. cfcookie name=CFID value=#Session.CFID# cfcookie

Re: HTTP 405 - Resource not allowed

2005-04-27 Thread Bryan Stevenson
It seems to me that you have learned something - explicit URLs are better when specifying a form's ACTION attribute. touche! ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail:

Re: Using Java Classes rather than CFC's?

2005-04-27 Thread Bob Jacoby
Thanks, Isaac. I appreciate your help in clarifying this for me. You were also absolutely right that I was missing the scopes part. I forgot that CF looks for unscoped/prefixed variables in numerous scopes. I'm obviously used java where there is only one scope (local) if something isn't

Fusebox dir structure so sensative stuff not web accessable

2005-04-27 Thread gabriel l smallman
Im trying to figure out how in a production environment you would build your folder structure and choose a webroot so that the view and parsed etc. folders are not web accessible. So right now Controller Model View Parsed Plugins And I would think making the controller the web root. Only issue

OT: Is this possible with CSS

2005-04-27 Thread Andy Jarrett
Hi, I am having a nightmare trying to replicate a 3 column site with CSS - it nearly make me want to use table's (did i say that out loud) To see what i am trying to create go to http://andyjarrett.co.uk/css.gif For those of you who you can i am trying to create a 3 column site with a header

RE: Password-protecting CFMX web services

2005-04-27 Thread Ben Mueller
Thanks for the help. I admit I still don't completely understand the username/password fields in the CF Admin--I *am* invoking this test web service from another CF installation. However, I don't want to waste anybody's time teaching the basics to me. Anyway, I sort of suspected that the way

  1   2   3   >