Re: Seeking RegEx help

2003-10-01 Thread Gyrus
At 17:33 01/10/2003 -0700, you wrote: >I have a URL I'm grabbing ... > >http://ww.mysite.com/VENTURA-435672_123-1.jpg > >I'm actually only interested in grabbing the "435672_123" part. > >REReplace(myURL, "([-])([0-9]{6,}[_][0-9]{3})([-])", "\2", "ONE") > >But all that does is drop the dashes from

RE: Display Records By a Certain Date - Here's What Worked

2003-10-01 Thread Matthew Walker
You might want to note then that anything involving dates and database functions will break when you switch. This will be something like: SELECT * FROM enrollments WHERE verify = 1 AND return_date > #DateAdd(d, -14, getdate())# ORDER BY enroll_num ASC Now() is a particular annoyance since i

Re:Bank Of America CC processing

2003-10-01 Thread Stan Winchester
Yes, I mean validating referrers in general. Can you show an example of how you would use cfheader or cfhttp? >>What's the best practise for validating a referrer >>other than from Bank Of America? > >You mean validating referrers in general?  As far as I know referrers >can be fairly easily fake

CFFTP Coding Question?

2003-10-01 Thread Nick Baker
I modified some CF Help Example code to get to the following, which works. However, when I omit the Chunk 2 code, I get the following error on Chunk 3 code "The error occurred while processing an element with a general identifier of (CFFTP), occupying document position (33:1) to (39:1)." I don

Re: Display Records By a Certain Date - Here's What Worked

2003-10-01 Thread Les Mizzell
OK, here's what worked SELECT * FROM enrollments WHERE verify = 'Yes' AND return_date > #DateAdd("d", -14, now())# ORDER BY enroll_num ASC Thanks to those that replied!!! This is using Access by the way. Switching to SQL Server in a few weeks... -- Les Mizzell - “Mihi

RE: SQL record retrieval problem

2003-10-01 Thread Mark Leder
Thank You Tony - I knew it had to be easy - I'm just brain dead tonight. Thanks, Mark -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 9:28 PM To: CF-Talk Subject: RE: SQL record retrieval problem mark select * from table where email like

Re: SQL record retrieval problem

2003-10-01 Thread Rizal Firmansyah
What database are you using? If you're using SQL server, you can do this: SELECT emailaddress FROM E1_EmailAdr WHERE right(emailaddress,7)='aol.com' if you're using Oracle,you can use substr function: SELECT emailaddress FROM E1_EmailAdr WHERE substr(emailaddress,len(emailaddress-7),7)='aol.com'

RE: SQL record retrieval problem

2003-10-01 Thread Tony Weeg
mark select * from table where email like '%aol.com' that should fix you right up ;) tw -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 9:26 PM To: CF-Talk Subject: SQL record retrieval problem I'm sure there's an easy way to do th

SQL record retrieval problem

2003-10-01 Thread Mark Leder
I'm sure there's an easy way to do this, I'm just can't see it. I have a db with email addresses, I only want to retrieve those with "AOL.com" domains. I've tried the function #right(emailaddress, 7)# in a query statement in the WHERE clause, and using the VARIABLE.emailext without success. Here's

RE: Bank Of America CC processing

2003-10-01 Thread Matt Robertson
Stan wrote: >What's the best practise for validating a referrer >other than from Bank Of America? You mean validating referrers in general?  As far as I know referrers can be fairly easily faked, so authentication using just that isn't something you can do and expect it to mean much.  CF can do i

RE: sql question pt 2

2003-10-01 Thread Tony Weeg
cool...ill try that out ;) thanks! tony -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:43 PM To: CF-Talk Subject: RE: sql question pt 2 Sorry, don't know how that "HAVING" got in there. SELECT count(tony) as tonysCount, sum(jayme)

RE: Display Records By a Certain Date

2003-10-01 Thread Barney Boisvert
check the syntax for your specific database, but it'll be something like one of these: where return_date >  dateAdd(d, -14, now()) where return_date > date_add(now(), interval -14 day) You'll also probably want to use midnight, not now(), so you do'nt cut the day in half. barneyb   -Origina

Seeking RegEx help

2003-10-01 Thread Owens, Howard
I have a URL I'm grabbing ... http://ww.mysite.com/VENTURA-435672_123-1.jpg I'm actually only interested in grabbing the "435672_123" part. REReplace(myURL, "([-])([0-9]{6,}[_][0-9]{3})([-])", "\2", "ONE") But all that does is drop the dashes from around the number I want ... how do I grab out

RE: [Stats] Cold Fusion Talk List Stats; September 2003

2003-10-01 Thread Ciliotta, Mario
Where are the stats. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 8:28 PM To: CF-Talk Subject: RE: [Stats] Cold Fusion Talk List Stats; September 2003 Bill Doerrfeld interested in CF-Talk stats? Has he abandoned Lasso and switche

RE: [Stats] Cold Fusion Talk List Stats; September 2003

2003-10-01 Thread Owens, Howard
Bill Doerrfeld interested in CF-Talk stats? Has he abandoned Lasso and switched to CF? ~~ Howard Owens Internet Operations Coordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~

Display Records By a Certain Date

2003-10-01 Thread Les Mizzell
Trying to display all records from a database where the RETURN_DATE is never more than two weeks ago.. Select * from enrollments Where RETURN_DATE < (#Now() - 15) Except that ain't it I've been awake way too long. Pointers in the right direction please? -- Les Mizzell ---

RE: Bank Of America CC processing

2003-10-01 Thread Barney Boisvert
There isn't really a good way to do it.  HTTP_REFERER is the only way to get the data, but many browsers let you turn off sending that header, and I remember seeing one that actually let you provide your own, though I don't know what it was. barneyb   -Original Message-   From: Stan Winche

RE: session variables and shopping cart

2003-10-01 Thread mayo
thx dennis, I was trying to avert a server call -- but it's probably not worth the trouble. You're probably right, I was never getting this error with CF. glm   -Original Message-   From: Dennis Powers [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01, 2003 7:10 PM   To: CF-Talk  

Re:Bank Of America CC processing

2003-10-01 Thread Stan Winchester
What's the best practise for validating a referrer other than from Bank Of America? >You need to put your web site into the validated referers list.  They >check the referer value and bounce anything not coming from a recognized >location (as if the referer is a valid way of determining this). [T

RE: session variables and shopping cart

2003-10-01 Thread Dennis Powers
>> I'm storing a product id as a session variable >> and am using a _javascript_ >> to allow the users to select the qty of items. As a rule of thumb I never use _javascript_ for anything that is used in a transaction, commerce calculation or query against a Database.  I have seen way too many ti

Re:sql question pt 2

2003-10-01 Thread lee
Hey, thanks - I learned something! Worth more than 2cents; just bill me... >My 2cents, > >Having accesses "derived" data - meaning a result set is first built >then winnnowed out.  In that case aggregate >functions are not used in the where clause because the where clause >filters in advance. > >

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread Ben Arledge
Okay, here's what I've been working with... probably should have posted this to begin with. UPDATE  ZipCodeTable as m SET  m.CityID = (SELECT CityID     FROM  (SELECT TOP 1 CityID, DistanceAssistant(m.latitude,m.longitude,c.Latitude,c.Longitude) as Distance  

Re:SQL - Zip Code/Nearest City

2003-10-01 Thread lee
OK, here's what I'm seeing; please correct me - -- The Zip table does not have the corners (need four corners) of counties or whatever specified, it has ONE SET of lat/longs, correct? -- This single set of data says where the center of the Zip is. If I'm correct (see below), it's either a trig pr

RE: CF-Talk: Digest every hour

2003-10-01 Thread
What happens if two cities are equidistant to the same zip code? i.e. ZipCodes Table ZipCodeLatitudeLongitudeCityID 9021050    80   NULL Cities Table CityIDLatitude   Longitude 9 51 81 10    49  

Re: SQL - Zip Code/Nearest City

2003-10-01 Thread Paul Hastings
> What I need to do is match a CityID with a ZipCode.  I'd need to select a > zipcode record, then loop through and calculate the distance of each of the > 400 cities based on the lat/lon of selected zip code, take the nearest/top > CityID and update the ZipCode table. these sorts of problems are

Re: sql question pt 2

2003-10-01 Thread Jochem van Dieten
Casey C Cook wrote: > I have never been able to reference a name I have assigned to a column in > the where clause. WHERE runs before aggregation, HAVING runs after aggregation. > Also, In an SQL book I have it says "The use of a > HAVING clause without a corresponding GROUP BY clause is almos

RE: sql question pt 2

2003-10-01 Thread Mark A. Kruger - CFG
My 2cents, Having accesses "derived" data - meaning a result set is first built then winnnowed out.  In that case aggregate functions are not used in the where clause because the where clause filters in advance. More to the point, the example you give is not useful without a group by clause. It s

Re:Breadcrumbs in Cold Fusion

2003-10-01 Thread Deetra Whatley
Hi Randell, I tried using your code. I tried to change it to a database format.  It would not loop.  Can you take a look.   SELECT DISTINCT ID, heading, subheading, subsubheading, webpage FROM LeftNavHeadings WHERE heading = 'PGCAC' ORDER BY ID #ATTRIBUTES.heading# >      

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread Ben Arledge
Looks like my post got cut off... The Cities table has just the 400 major cities in the US and Canada, the ZipCode table has every zip code and postal code for every corner of the two countries. The ZipCode table has Longitude and Latitude coordinates for each zip code (basically each city).  T

Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Joe Tartaglia
Thanks to everyone who offered help on this one. Short term solution was to increase size of registry.  Long term solution will be to set up a datasource for client variables. Joe Tartaglia High Caliber Solutions 212-684-5553 [Todays Threads] [This Message] [Subscription] [Fast Unsubscri

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread Ben Arledge
Thanks for the response Ed. The Cities table has just the 400 major cities in the US and Canada, the ZipCode table has every zip code and postal code for every corner of the two countries. The ZipCode table has Longitude and Latitude coordinates for each zip code (basically each city).  The Cit

Re: [Stats] Cold Fusion Talk List Stats; September 2003

2003-10-01 Thread Calvin Ward
Yeps, those stats look a bit low...   - Original Message -   From: Bryan Stevenson   To: CF-Talk   Sent: Wednesday, October 01, 2003 5:31 PM   Subject: Re: [Stats] Cold Fusion Talk List Stats; September 2003   looks like the line monster got that post ;-)   Bryan Stevenson B.Comm.   V

Re: [Stats] Cold Fusion Talk List Stats; September 2003

2003-10-01 Thread Bryan Stevenson
looks like the line monster got that post ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com ---

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread
Hi Ben, I notice that both tables have a cityName column.  Could you join on these: select  * fromzipcodes z inner join cities c on z.cityname = c.cityname ?  Or is this field null as well? It would seem to me that your cities should have more then one set of long/lat coordinates, i

[Stats] Cold Fusion Talk List Stats; September 2003

2003-10-01 Thread Bill Doerrfeld
Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re:sql question pt 2

2003-10-01 Thread lee
I agree with Casey - something is wrong with this query and thread (any SQL Ninjas out there). Let's simplify: On MS SQL Server v7, the following trivial query DOES work - SELECT count(author_id) as myCounter FROM author HAVING count(author_id) > 0 The following (same DB etc), DOES NOT WORK: SE

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread Ben Arledge
Yes, I have all US Zip Codes and Canadian Postal Codes...  the exact number is actually a bit less than 900k records.  The data is structured the same... I've just got all the Postal Codes in the ZipCode column. Ben   _   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: October 1, 2

RE: CFC Question

2003-10-01 Thread Barney Boisvert
you can only return a single value from a method in a CFC.  IF you need to return multiple values, then you have to package them into a complex value (a struct) and then return the struct.  So rather than this:       you'd do something like this (this is foolish, because you could just return t

RE: CFC Question

2003-10-01 Thread Andy Ousterhout
Yes.  But you also exited the program at the end of the first loop.   -Original Message-   From: Ben Densmore [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01, 2003 3:42 PM   To: CF-Talk   Subject: RE: CFC Question   I don't follow completely. If I set  a variable inside the loop t

RE: CFC Question

2003-10-01 Thread Andy Ousterhout
That's because The return command sends you back to the calling program.  Why not just return session.cart at the end of your script and deleted the imbedded loops. Andy   -Original Message-   From: Ben Densmore [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01, 2003 3:19 PM   To: CF

RE: CFC Question

2003-10-01 Thread Ben Densmore
I don't follow completely. If I set  a variable inside the loop to contain the structure then try to return that I get the same result. Ben -Original Message- From: Aunger, Mitch [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:36 PM To: CF-Talk Subject: RE: CFC Questi

RE: CFC Question

2003-10-01 Thread Aunger, Mitch
With a CFC, you only 'return' once... you don't return within a loop... (in your case you are only getting the last item) what you want to do is build a structure of names and then outside the loop, return the structure. make sense? Mitch Shameless plug for my wife's business: http://www.mygc

RE: Bank Of America CC processing

2003-10-01 Thread Stacy Young
That's very likely...that's how our payment gateways work. Either that or they just haven't enabled the account yet. Stace   _   From: McGill, Eric [mailto:[EMAIL PROTECTED] Sent: October 1, 2003 2:01 PM To: CF-Talk Subject: RE: Bank Of America CC processing Ryan, Maybe BoA just n

CFC Question

2003-10-01 Thread Ben Densmore
I'm just starting to play with CFC's to get familiar with them and was trying to write some play code to see if it would work. I got it to work but it only displays 1 record out of a loop I'm doing. How would I go about getting all records to display? Here is the code I'm playing with: CFC: ret

RE: sql question pt 2

2003-10-01 Thread Casey C Cook
I have never been able to reference a name I have assigned to a column in the where clause.  Also, In an SQL book I have it says "The use of a HAVING clause without a corresponding GROUP BY clause is almost never seen in practice". (LAN TIMES Guide to SQL) I would agree with J E VanOver with th

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread Kennerly, Rick H CIV
zip code + 4? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 01 October, 2003 16:09 To: CF-Talk Subject: Re: SQL - Zip Code/Nearest City Just curious... why are there 900,000 records in the zip codes table? There's only a little over 42,000 zip co

Re: SQL - Zip Code/Nearest City

2003-10-01 Thread cf-talk
Just curious... why are there 900,000 records in the zip codes table? There's only a little over 42,000 zip codes in the United States.  The only thing I could think of is that you've included all of the alternate city names... or that you're not really using zip codes from the USA.  Canadian posta

RE: sql question pt 2

2003-10-01 Thread J E VanOver
Sorry, don't know how that "HAVING" got in there. SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount from orders WHERE Abs((count(tony)-sum(jayme))/count(tony)) > 0 This is the form I use all the time.  Works. As I said at first, I work just with SQL Server and that is how it is done th

SQL - Zip Code/Nearest City

2003-10-01 Thread Ben Arledge
Hey CF SQL'ers, My SQL skills are failing me so I need your help in creating some SQL I can use in CF or run through Query Analyzer (using SQL Server). I have two tables as follows: ZipCodes (900,000 records, CityID column is currently null) - ZipCode (varchar) - CityName (varchar) - Country (

Re: Where can I download the Pet Market Application Files?

2003-10-01 Thread Troy Simpson
Thanks Ben, but still no go. In both cases I get sent to this URL and http://www.macromedia.com/bin/petmarket.cgi Which sends me to an "Error: Page Not Found". Anybody got a phone number for Macromedia?  LOL Troy Ben Densmore wrote: > Try this one. > > > > http://www.macromedia.com/devnet/mx/

RE: sql question pt 2

2003-10-01 Thread Tony Weeg
that doesn't jive. why? because the values of those two things arent calculated until you get down into the where clause qualifiers. isnt there just a way to use those calculated values, referenced in the beginning of the query, later on down in the query? ...tony tony weeg senior web applicat

Re: Data Returned from XmlSearch()

2003-10-01 Thread Matt Liotta
> I'm using XmlSearch() to query an XML document in CFMX 6.1.  I want to > store the resulting data in a another variable that is an XML > object.  I'm having some difficulty because the XmlSearch() function > returns an array of the XML nodes that match the XPath search > criteria.  I tried us

Re:Breadcrumbs in Cold Fusion

2003-10-01 Thread cf
heres 2 snippets from massimo that work good http://www.dwfaq.com/Snippets/cat_listing.asp?CatID=13 or if you are using dreamweaver, there are a few REALLY EASY extentions that you can use. go search macromedias exchange >> >> [Todays Threads] [This Message] [Subscription] [F

RE: Where can I download the Pet Market Application Files?

2003-10-01 Thread Ben Densmore
Try this one. http://www.macromedia.com/devnet/mx/blueprint/instructions_cfhtml.html Ben -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:12 PM To: CF-Talk Subject: Where can I download the Pet Market Application Files? Whe

Where can I download the Pet Market Application Files?

2003-10-01 Thread Troy Simpson
Where can I download the Pet Market Application Files? The link on Macromedia's Web site appears to be broken. Try it out: http://www.macromedia.com/devnet/mx/blueprint/instructions_cf.html Troy -- Troy Simpson   Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University

RE: Data Returned from XmlSearch()

2003-10-01 Thread Ian Skinner
We ran into a problem that sounds similar to what you are talking about, we where parsing a large XML document, and what we wanted was three smaller XML documents created from the desired parts of the large one.  The conclusion is that we didn't want to use XmlSearch(), because as you said, it retu

RE: Bank Of America CC processing

2003-10-01 Thread Ryan Roskilly
I have tried both the domain name and the IP address. What is your fix?   -Original Message-   From: Matt Robertson [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01, 2003 2:04 PM   To: CF-Talk   Subject: RE: Bank Of America CC processing   You need to put your web site into the val

Data Returned from XmlSearch()

2003-10-01 Thread Tim Haak
Hello, I'm using XmlSearch() to query an XML document in CFMX 6.1.  I want to store the resulting data in a another variable that is an XML object.  I'm having some difficulty because the XmlSearch() function returns an array of the XML nodes that match the XPath search criteria.  I tried using t

RE: sql question pt 2

2003-10-01 Thread J E VanOver
I just work with SQL Server and there you DON'T use calculated values in the HAVING clause.  You have to re-compute SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount from orders WHERE tony = tony HAVING Abs((count(tony)-sum(jayme))/count(tony)) > 0 -Original Message- From: Tony

sql question pt 2

2003-10-01 Thread Tony Weeg
question: how does one use calculated variable names(not sure if this is what they are called) in queries, later on in the query? ie. select count(tony) as tonysCount, sum(jayme) as jaymesCount from orders where tony = tony HAVING Abs((tonysCount-jaymesCount)/tonysCount) > 0 the problem is im g

Re:parsing txt file - seems unparsable

2003-10-01 Thread Jerry Johnson
Is this CF 5 or earlier? If so, it is probably actually a NULL chr(0) character. Notepad will get rid of it when you open and save the file. CF 5 and earlier have trouble with strings containing NULLs, since it uses NULLs to mark the end of strings (I think). The data is still in the string, bu

Re: parsing txt file - seems unparsable

2003-10-01 Thread Ben Doom
I've run into this before.  CF is actually opening the file correctly, but there's a null character, and CF uses null terminated strings, so it sees that and thinks the string is done. At least, that's my best guess. I've never found a way to fix this in CF, unfortunately. --Ben Stephenie Ham

Re:parsing txt file - seems unparsable

2003-10-01 Thread lee
This sounds line an end -f line or carriage return character (or both) Do a replace of each [chr(10) & chr(13); replace with white space or some marker for your illumination "~~~" or whatever ] in the variable and see if that helps. Are you SURE it's not in the database, as well? Just kicked down

RE: Bank Of America CC processing

2003-10-01 Thread Matt Robertson
You need to put your web site into the validated referers list.  They check the referer value and bounce anything not coming from a recognized location (as if the referer is a valid way of determining this). If that still doesn't work and they are refusing a listed poster, you've hit a bug in thei

sql question pt 2

2003-10-01 Thread Tony Weeg
how does one use calculated variable names(not sure if this is what they are called) in queries, later on in the query? ie. select count(tony) as tonysCount, sum(jayme) as jaymesCount from orders where tony = tony HAVING Abs((tonysCount-jaymesCount)/tonysCount) > 0 the problem is im getting an

RE: Bank Of America CC processing

2003-10-01 Thread McGill, Eric
Ryan, Maybe BoA just needs to explicitly allow the IP or domain of the server posting the transactions? Eric -Original Message- IOC_reject_description=The site that originated the order request is not authorized to POST transactions. But according to all the setting I can find I do have

RE: Breadcrumbs in Cold Fusion

2003-10-01 Thread Brad Roberts
I've posted an example and download here: http://www.agentvow.com/traverseTree/ Let me know if you have any thoughts or improvements. -Brad   -Original Message-   From: Deetra Whatley [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01, 2003 1:07 PM   To: CF-Talk   Subject: Re:Breadcr

Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread S . Isaac Dealey
Not sure about the rest of it, but I'll support more prominent cf resources. :) It's not like there's a lack of material for the category -- there's 74 titles if you search and they show 10 per page, so ... wouldn't that be like nearly 10 pages of results like the other subcategories there like ASP

RE: Settle an argument for me

2003-10-01 Thread Mark Leder
Cutter, Another great idea. Thanks for your suggestion. Thanks, Mark -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 1:09 PM To: CF-Talk Subject: Re: Settle an argument for me Mark, I can't see how they could reverse engineer it (

Re:parsing txt file - seems unparsable

2003-10-01 Thread Stephenie Hamilton
If i open the file in notepad, then save it (without making any changes) it works fine. h...wonder how/if i can use cfexecute to have notepad open the file and then save it? other than that, i can't think of anything else... Steph [Todays Threads] [This Message] [Subscription] [Fast Un

Re: Settle an argument for me

2003-10-01 Thread Cutter (CF-Talk)
Mark, I can't see how they could reverse engineer it (though spammers are known to get notoriously industrious.) A technique I've used in the past is to set up a dynamic listing of contacts, which brings up a custom (branded no less) form for the message, then sends the contactID and message d

Re:Breadcrumbs in Cold Fusion

2003-10-01 Thread Deetra Whatley
Hi Brad Roberts, I am interested in your two tags for breadcrumbs. If possible, I would like to have them. Thanks. Deetra Whatley [EMAIL PROTECTED] >For a tree view, I built a tag based off of Piet Niederhausen's >cf_traverseTree, which uses Joe Celko's algorithim from his book "SQL for >Sm

Bank Of America CC processing

2003-10-01 Thread Ryan Roskilly
I'm trying to test processing of credit cards on a test account using Bank Of America. In the return code I'm getting this. IOC_reject_description=The site that originated the order request is not authorized to POST transactions. But according to all the setting I can find I do have it set up co

RE: Settle an argument for me

2003-10-01 Thread Mark Leder
Thanks, I'll give it a whirl. Thanks, Mark -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 12:22 PM To: CF-Talk Subject: RE: Settle an argument for me Loop over the HTTP_USER_AGENT.        Call the _javascript_ function

RE: Compressing Javascript

2003-10-01 Thread Barney Boisvert
The simplest way is to just remove any whitespace that follows a semicolon. That's where most of the extra characters are, especially if you have more than a level or two of indentation.  You can also remove spaces from around these characters:   = + - { } ( ) Those the the biggest culprits of whi

Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Jim Campbell
With the sheer amount of money I funnel into Jeff Bezos' Amateur Pilot Tuition Fund, hopefully my words will carry some weight.  Any site where I can buy a Gorilla Biscuits CD, Clie stylus refills, discontinued Dreamcast games and a hardcover copy of "Coraline" in one session *and* have them de

SQL Error

2003-10-01 Thread Andy Ousterhout
This parameter value:  (param 15) = [type='IN', class='java.lang.Double', value='44.5', sqltype='CF_SQL_MONEY'] is creating the following error:  Error Executing Database Query. Invalid data for CFSQLTYPE CF_SQL_DOUBLE. This is storing a value to a MS Access DB field that has data type of currency

Re:parsing txt file - seems unparsable

2003-10-01 Thread Stephenie Hamilton
it does not display the whole file. it stops when it gets to the little square on the first line. i can't even get to the part of inserting into db because i get only part of the first line. Stephenie >if you output the content of the file in your cf template (prior to db >insert) does it disp

Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread S . Isaac Dealey
Heh... Thanks Jim... You know I'm always too beligerant to be nice. :) > Done, but I said it in a nice way :) > - Jim > S. Isaac Dealey wrote: >> They definately don't belong there... It's funny, I've >> never seen them >> anywhere but in the programming section next to C++ ... >> (Not popular

Re: parsing txt file - seems unparsable

2003-10-01 Thread S . Isaac Dealey
if you output the content of the file in your cf template (prior to db insert) does it display the whole thing? If so, are you using cfqueryparam? > I am trying to use CFFILE to parse a text file, put the > contents in a > var and then insert that into a db. > However, the file only gets parsed h

RE: Settle an argument for me

2003-10-01 Thread cfhelp
Loop over the HTTP_USER_AGENT.        Call the _javascript_ function to launch the mailto: link           Give them a way to close this window. Close Window   _   From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, Octo

parsing txt file - seems unparsable

2003-10-01 Thread Stephenie Hamilton
I am trying to use CFFILE to parse a text file, put the contents in a var and then insert that into a db. However, the file only gets parsed halfway through the first line. I couldn't at first figure out why it would stop. If I opened the file in notepad, added a space, then deleted the space, the

Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Jim Campbell
Done, but I said it in a nice way :) - Jim S. Isaac Dealey wrote: > They definately don't belong there... It's funny, I've never seen them > anywhere but in the programming section next to C++ ... (Not popular > enough to be on the end-cap next to XML for Dummies I guess.) But then > it's been a

RE: session variables and shopping cart

2003-10-01 Thread mayo
CFID and CFTOKEN are being passed:   sessionmanagement="Yes"   setclientcookies="Yes" The funny part about it is that it happens at random. Why would session.item be passed twice sometimes and not others?  Why is session.item passed twice and not session.itemQty? Unable to solve this. Gil   --

RE: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread S . Isaac Dealey
They definately don't belong there... It's funny, I've never seen them anywhere but in the programming section next to C++ ... (Not popular enough to be on the end-cap next to XML for Dummies I guess.) But then it's been a little while since I've seriously been in a book store looking for CF books.

Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread S . Isaac Dealey
I'd recommend using includes... Assuming you use directories to delineate sections fo the site, each include (breadcrumb.cfm) would look something like this:   > The advantage of this is that if you change any given breadcrumb link it will automagically update all pages in your site without

Re: sql question

2003-10-01 Thread Andrea Galmacci
test subscription - Original Message -   From: Eric Creese   To: CF-Talk   Sent: Wednesday, October 01, 2003 4:59 PM   Subject: RE: sql question   I do not think you need the SELECT   -Original Message-   From: Tony Weeg [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01

RE: CFTRANSACTION problem

2003-10-01 Thread Douglas.Knudsen
You have to have the same DSN, including all UID/PWDs, in all your queries in a cftransaction. Doug -Original Message- From: Ramesh Deva [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 11:45 AM To: CF-Talk Subject: CFTRANSACTION problem Hi, Suddenly I am getting followin

CFTRANSACTION problem

2003-10-01 Thread Ramesh Deva
Hi, Suddenly I am getting following error in cfm page. Data source Ora8 verification failed. The root cause was that: java.sql.SQLException: Usernames and Passwords for all the database tags within CFTRANSACTION must be the same. Really that will be greatly appreciate f

RE: Breadcrumbs in Cold Fusion

2003-10-01 Thread Brad Roberts
For a tree view, I built a tag based off of Piet Niederhausen's cf_traverseTree, which uses Joe Celko's algorithim from his book "SQL for Smarties". http://www.niederhausen.net/piet/dev/customtags/index.html  The code is a lot simpler... it took me hours to figure it out.  And, instead of taking a

RE: sql question

2003-10-01 Thread Eric Creese
I do not think you need the SELECT -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 9:56 AM To: CF-Talk Subject: RE: sql question something like this? but im getting this error... ===error text== Server: Msg

RE: Settle an argument for me

2003-10-01 Thread Mark Leder
I like this idea, as the email addresses are already in a db.  I guess I'm trying figure out how I would write to check for the browser in this scenario. Thanks, Mark -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 11:09 AM To: CF-Talk Subjec

RE: Compressing Javascript

2003-10-01 Thread Daniel Mackey
Hi, Have a look at ColdFusion Compactor: http://free.cftagstore.com/index.cfm/page/viewtag/tagId/14 Regards, Dan.   -Original Message-   From: Brook Davies [mailto:[EMAIL PROTECTED]   Sent: Wednesday, October 01, 2003 16:30   To: CF-Talk   Subject: Compressing _javascript_   Does anyon

RE: Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Mike Brunt
Joe, where are you storing Client Variables? If it’s the Registry that may be your problem.  Check it in ColdFusion Administrator.  I strongly recommend if it is the Registry you change it to a Database as soon as possible because if the Registry gets corrupted it is not just CF that will be affect

RE: Settle an argument for me

2003-10-01 Thread Jim Davis
Basically any method for obfuscation will eventually become useless. perhaps this one has. The only reason it worked at all, or as long as it did, was because spam-bots are so stupid. but they are only as stupid as they can be. Since you're still using a mailto: tag even the dumbest bot would kno

Compressing Javascript

2003-10-01 Thread Brook Davies
Does anyone know of a UDF or customtag that will compress _javascript_ to cut down on file size? I know there are apps that do this, and I would like to include this functionality with some of our dynamically generated pages. Thanks! Brook Davies [Todays Threads] [This Message] [Subscrip

Re: Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Ubqtous
Joe, On 10/1/2003 at 11:09, you wrote: JT> We just started getting reports that the error shown below has JT> been cropping up on all sites built with ColdFusion on one of JT> our servers.  The server is running ColdFusion 4.0 and NT4.5 JT> I have not been able to recreate the error but I have h

RE: ot: sql question

2003-10-01 Thread Tony Weeg
thank you jochem, that makes sense, I was close, but forgot about the abs function, which I presume is for absolute number anyway, now I get this Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'ReportsInDatabase'. Server: Msg 207, Level 16, State 1, Line 1 Invalid column name

Re: Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Howie Hamlin
By default CF stores client vars in the system registry.  You should probably consider using an ODBC datasource instead. For now, you should try increasing the max size of the system registry in your server settings. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. -

Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread Randell B Adkins
You could use the same style, just tweak the HTML that is built around it. Such as:   href=""> (ATTRIBUTES.ItemName,i)# Or something like that. Did not test it but if you build the variables as needed, you can display the menu anyway you want with proper coding. >>> [EMAIL PROTECTED] 1

  1   2   >