RE: SQL HELP!

2004-05-21 Thread Pascal Peters
Ascension day. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 mei 2004 3:07 To: CF-Talk Subject: RE: SQL HELP! what holiday? tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

XPath Help

2004-05-21 Thread Tony Pimm
Hi, I'm trying to get some XPath to work with respect to a navigation tree. ?xml version=1.0 encoding=utf-8 ? tree node objectid=3456 title=Informationa node objectid=2134 title=Contact / node objectid=5656 title=Top 1.2 / node objectid=5672 title=Top 1.3 / node objectid=123 title=Top

Homesite Resource Window

2004-05-21 Thread Tangorre, Michael
My resource window in homesite became undocked somehow.. anyone know how to dock it? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Homesite Resource Window

2004-05-21 Thread Nando
Try View Resource Tab? -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:08 PM To: CF-Talk Subject: Homesite Resource Window My resource window in homesite became undocked somehow.. anyone know how to dock it? Thanks, Mike [Todays

Selecting by row or CurrentRow

2004-05-21 Thread Nando
Could someone remind me of the syntax to select by row? I don't remember where to find that. Thanx Select * From qProduct Where CurrentRow = #theRowIWant# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Homesite Resource Window

2004-05-21 Thread d.a.collie
My resource window in homesite became undocked somehow.. anyone know how to dock it? Double clicking the title bar works in CF Studio if you undock any of tabs, if that helps -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Homesite Resource Window

2004-05-21 Thread Tangorre, Michael
Nope... That won't re-dock it.:-( It is so annoying. It would be nice if you dragged it to the edge and it snapped in place, but that is just wishful thinking. Mike -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:09 AM To: CF-Talk Subject:

RE: Homesite Resource Window

2004-05-21 Thread Tangorre, Michael
Double clicking the title bar works in CF Studio if you undock any of tabs, if that helps Nope. That does not work either.:-( [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Homesite Resource Window

2004-05-21 Thread Nando
It's happened to me several times ... i got it back somehow. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:17 PM To: CF-Talk Subject: RE: Homesite Resource Window Nope... That won't re-dock it.:-( It is so annoying. It would be nice if

RE: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
Could you give an example? On Thu, 20 May 2004 15:08:40 -0400, Philip Arnold wrote: From: Nathan R. Jessop I don't want to use a database because of oeverhead. In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list

RE: Homesite Resource Window (SOLVED)

2004-05-21 Thread Tangorre, Michael
Left click in the floating window. Hold down shift while right clicking... Select the move to option (top, bottom, left, right). Do that for each resource tab What a stupid way of doing it!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Ignoring duplicates in select

2004-05-21 Thread d.a.collie
In which case, keep a list of items as you write them out, and before you do the next one, check that it's not in the list Jumping in here so ignore if this does help you cfset noDupsList = cfloop list=dupsList index=anything cfif not listFindNoCase(noDupsList, anything) cfset

RE: CSS 'focus' in IE

2004-05-21 Thread Sandy Clark
IE6 doesn't support focus in CSS.However Dean Edwards Beta of IE7 (Internet Extensions) which is a set of behaviors for IE6 to make it more CSS 2 compliant does support it.You can find the behaviors at http://dean.edwards.name/IE7/ _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:

Re: SOT - Last nights NYCFUG meeting.

2004-05-21 Thread Cutter (CF-Talk)
This is a bit unfair to those of us who live in remote enough locations that there are no close MMUGs and our seasonal work environments don't allow much travel during this time of year... Cutter Ben Forta wrote: No, that was not specifically mentioned. I can't comment on this feature

RE: CSS 'focus' in IE

2004-05-21 Thread d.a.collie
IE6 doesn't support focus in CSS.However Dean Edwards Beta of IE7 (Internet Extensions) Cheers, will look into it... users wanting the input boxes to change color and you know how it goes, gotta get it working for them Cheers everyone :-) -- dc [Todays Threads] [This Message]

CF in montreal (quebec) ?

2004-05-21 Thread CFDEV
Hi there, does anyone of you knows if there is a big community of CF programmer in montreal... I always see on this list conference and stuff in the States and in Toronto for Canada.. Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: XPath Help

2004-05-21 Thread Ian Sheridan
I found this site to be an excellent eye opener for xPath. http://www.zvon.org/xxl/XPathTutorial/General/examples.html Ian - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ian Sheridan [EMAIL PROTECTED] http://www.savagevines.com - - - - - - - - - - - - - - - - - - - - - - - - - - -

Re: XPath Help

2004-05-21 Thread Ian Sheridan
I shot that off to fast here is a more focused link. the site is a little confusing. http://www.zvon.org/xxl/XPathTutorial/Output/example1.html On May 21, 2004, at 7:56 AM, Ian Sheridan wrote: I found this site to be an excellent eye opener for xPath.

RE: SOT - Last nights NYCFUG meeting.

2004-05-21 Thread Ben Forta
We're planning an online Breeze based sessions for user groups not visited, but I don't have the details yet. I'll post them as soon as I do. --- Ben _ From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:50 AM To: CF-Talk Subject: Re: SOT - Last nights NYCFUG

Re: XPath Help

2004-05-21 Thread Alexander Sherwood
At 07:04 AM 5/21/2004, you wrote: Hi, I'm trying to get some XPath to work with respect to a navigation tree. ?xml version=1.0 encoding=utf-8 ? tree node objectid=3456 title=Informationa node objectid=2134 title=Contact / node objectid=5656 title=Top 1.2 / node objectid=5672 title=Top 1.3 / node

Re: oracle unique id or identity

2004-05-21 Thread Deanna Schneider
Daniel, Can you create the sequence and then just run a test on it outside the trigger. In other words, just try this: SELECT uniqueNum_s.nextval FROM dual; Does this work? Here's an example of a trigger that I use for updates/inserts. On insert, it auto-increments the id field. On update, it

new member: web fetching

2004-05-21 Thread techmike
Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.How would

RE: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
I added the list attribute to my cfloop and now I get an error. What am I doing wrong? Here is my code: select name=filelistselect size=15 multiple class=dirlinks cfloop LIST=duplist INDEX=i FROM=1 TO=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option

RE: new member: web fetching

2004-05-21 Thread Whittingham, P
cfhttp. Pat -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:39 AM To: CF-Talk Subject: new member: web fetching Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but

Selecting records from form fields

2004-05-21 Thread Spectrum WebDesign
Hi all our application have an form with dynamic fields... like this... After user choices that options i need to select Form Fields: CHECK_QUESTIONID=8,11,10 STEP=1 FIELDNAMES=STEP2,CHECK_QUESTIONID,SELECT_ATRIB_8,SELECT_ATRIB_11,SELECT_ATRIB_10,SUBMIT SELECT_ATRIB_10=4 SELECT_ATRIB_11=5

RE: new member: web fetching

2004-05-21 Thread Monique Boea
More specifically please... :) -Original Message- From: Whittingham, P [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: new member: web fetching cfhttp. Pat -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Friday,

RE: Ignoring duplicates in select

2004-05-21 Thread Adkins, Randy
What error are you getting? -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: Ignoring duplicates in select I added the list attribute to my cfloop and now I get an error. What am I doing wrong? Here is my

RE: Ignoring duplicates in select

2004-05-21 Thread Adkins, Randy
Actually now I look at it when you do a LIST the syntax is: CFLOOP INDEX=Z LIST=#MyListName# There is no from and to attributes -Original Message- From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: Ignoring duplicates in

RE: new member: web fetching

2004-05-21 Thread Tangorre, Michael
A good link to bookmark is that of the livedocs at Macromedia's website. It comes in very handy and even has examples, although I'd take them with a grain of salt.:-) http://livedocs.macromedia.com/coldfusion/6.1/index.html Welcome aboard and I think you will find this list more useful than

Re: CF in montreal (quebec) ?

2004-05-21 Thread Claude Schneegans
Hi there, does anyone of you knows if there is a big community of CF programmer in montreal... YEHHH ! ;-) -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL

RE: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
CFLOOP INDEX=i LIST=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupList = listAppend(noDupList,i) /cfif /CFLOOP After making the change to the CFLOOP I get the

RE: new member: web fetching

2004-05-21 Thread techmike
I thought cfhttp would be the correct route, but was skeptical after reading the man page for it.. -mike -Original Message- From: Monique Boea [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Fri, 21 May 2004 08:51:52 -0400 Subject: RE: new member: web fetching More specifically

RE: Ignoring duplicates in select

2004-05-21 Thread d.a.collie
You are looping over an array, you will need to set your values within the loop, it would be something like this cfset noDupList = CFLOOP INDEX=i LIST=#ArrayLen(arPages)# cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList =

RE: Ignoring duplicates in select

2004-05-21 Thread Philip Arnold
From: Nathan R. Jessop CFLOOP INDEX=i LIST=#ArrayLen(arPages)# cfset noDupList = cfif not listFindNoCase(i, duplist) option value=#sValNoComma#Seq: #sValNoComma#nbsp;nbsp;Folio: #sDisp##spacer1#/option cfset noDupList = listAppend(noDupList,i) /cfif /CFLOOP The LIST attribute

Re: Ignoring duplicates in select

2004-05-21 Thread d.a.collie
Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) option value=#sValNoComma#Seq:

excel files

2004-05-21 Thread George Abraham
Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? Thanks, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: excel files

2004-05-21 Thread Ray Champagne
I don't know if this would help, but if you can export the files to a csv file via Excel, you could then read the file using cffile (read) - no datasource But, you would have to change the file, and I don't know if that is possible for you or not. Ray At 09:20 AM 5/21/2004, George

Re: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
It's now displaying my list but its still duplicating. I think it has something to do with the extra lines of code that I stripped out before I posted this. Something is conflicting. I'm reading in an external file that looks like this: 001folio:2201 . . . 274.00 points free 002folio:2251 . . .

Re: excel files

2004-05-21 Thread George Abraham
I toyed with that idea, but the users really shouldn't be saddled with something like that. Besides, the querying of Excel files using SQL is easier to code and debug. George At 09:26 AM 5/21/2004, Ray Champagne wrote: I don't know if this would help, but if you can export the files to a csv

Re: excel files

2004-05-21 Thread Rick Root
George Abraham wrote: Hi, I asked a question sometime back about reading excel files with CFMX without using a defined datasource. No answers yet, but is there another forum I could be asking this question? There may be an easier solution, but the Jakarta POI project allows you to read and

Re: excel files

2004-05-21 Thread George Abraham
Rick, Ultimately that is probably what I will end up doing. Before asking the forum, I did some research into POI and decided as a long-term solution, that is probably what is best for manipulating Word and Excel Files. I was hoping for an easier solution though, as you said. :-) By the way,

What causes this sporadic error?

2004-05-21 Thread Mark Leder
Hi all, This appears every once in a while when clicking a link or using the browser's back button.I have cookies enabled on my Win XP machine, using IE 6.Do I have a setting wrong in the cfapplication tag?I presently do not have a #URLSessionFormat()# or other similar function on the links, and

Re: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
I just noticed the matching is being done on the ValNoComma but it should be on the sDisp On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote: Oops as Philip said it would need to be cfset noDupList = CFLOOP from=1 to=#ArrayLen(arPages)# index=i cfset sValNoComma = arPages[i] cfif

RE: Ignoring duplicates in select

2004-05-21 Thread Philip Arnold
That's because you're checking on the Seq number, not the Folio cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) Should be cfif not listFindNoCase(noDupList, sDisp) cfset noDupList = listAppend(noDupList,sDisp) -Original Message-

RE: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
Doh...yea...I got it to work. On Fri, 21 May 2004 09:54:37 -0400, Philip Arnold wrote: That's because you're checking on the Seq number, not the Folio cfif not listFindNoCase(noDupList, sValNoComma) cfset noDupList = listAppend(noDupList,sValNoComma) Should be cfif not

RE: What causes this sporadic error?

2004-05-21 Thread Paul Vernon
You generally get this error if you have the CFID and CFTOKEN in your URL querystring twice. This can happen if you have not set addtoken=no in a cflocation and you are manually adding the CFID and CFTOKEN to your url eg cflocation url="" - can cause this problem cflocation url=""

RE: excel files

2004-05-21 Thread Nathan C. Smith
How many people will be querying the excel file? Could you create an Excel DSN with a file of a given name, but copy the active file to the DSN file and name as it was being used? Somebody else may be able to jump in here, but I think there is a way to stop and restart a DSN

RE: excel files

2004-05-21 Thread George Abraham
I did the DSN thing, but I was not aware that you could restart a DSN programmatically. If that is possible, whew, it would save me some work for the time being at least! George At 10:00 AM 5/21/2004, you wrote: How many people will be querying the excel file? Could you create an Excel DSN

RE: CF in montreal (quebec) ?

2004-05-21 Thread Stacy Young
- Montreal !!:) -Stace _ From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 7:53 AM To: CF-Talk Subject: CF in montreal (quebec) ? Hi there, does anyone of you knows if there is a big community of CF programmer in montreal... I always see on this list conference and stuff in

Re: SOT - Last nights NYCFUG meeting.

2004-05-21 Thread Don
Thanks, this is good to know.If you've tried BD yourself probably you would have an idea about the following questions: *) Could BD co-exist with CFMX and/or preCFMX on a same win OS box for dev? *) Does BD support both CFMX and preCFMX or only CFMX? Of course, I'll look into more detail about BD

RE: Ignoring duplicates in select

2004-05-21 Thread Nathan R. Jessop
Oh no...another problem. If my imput file list looks likes this (arrows just indicate extra folios) 001folio:2201 . . . 274.00 points free 002folio:2251 . . . 021.00 points free 003folio:2252 . . . 001.00 points free 004folio:2253 . . . 011.00 points free 005folio:2254 . . . 001.00 points free

Executing an ASX file on ColdFusion Server?

2004-05-21 Thread Greg Landers
Hello. I have an issue with getting an ASX file to properly execute on a CF server (MX) ... on the same machine using apache's web server the ASX file execute in the browser causing it to stream the media as expected. However, when running it throught the CF server it pulls up a blank page in the

RE: Ignoring duplicates in select

2004-05-21 Thread Philip Arnold
From: Nathan R. Jessop How can I get it to output in the correct order? What does your data look like? Can you sort it with ArraySort()? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: What causes this sporadic error?

2004-05-21 Thread Mark Leder
But what I don't understand is why this is happening in normal a href tags, I'm not using or clicking a cflocation tag?? Thanks, Mark _ From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:00 AM To: CF-Talk Subject: RE: What causes this sporadic error? You generally

RE: excel files

2004-05-21 Thread George Abraham
So I did some quick looking around and here is something that could be helpful: http://www.macromedia.com/support/coldfusion/ts/documents/dynamic_dsn_cfmx.htm George At 10:00 AM 5/21/2004, you wrote: How many people will be querying the excel file? Could you create an Excel DSN with a file of

Problem with CFC web service Flash

2004-05-21 Thread Rick Root
I've got a web service that I use to authorize users against our DB2 Mainframe, and I recently changed it up to return an array of CFC datatypes instead of a structure. The WSDL generates fine... I can call the methods from the browser directly.But when Flash tries to access it, it simply says

RE: Executing an ASX file on ColdFusion Server?

2004-05-21 Thread Paul Vernon
I run CFMX 6.1 and Windows Media services without any problems, send some more information and I'll see what I can do to help. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Passing a webservice a file

2004-05-21 Thread David Adams
My understanding of webservices are weak but is it possible to pass a webservice a file (as opposed to a string) and have it processed and returned? I am not concerned about how it is processed or returned but whether or not a webservice accepts binary files. Thanks in advance. DA [Todays

RE: Passing a webservice a file

2004-05-21 Thread Tony Weeg
an xml file? sure. tw -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:33 AM To: CF-Talk Subject: Passing a webservice a file My understanding of webservices are weak but is it possible to pass a webservice a file (as opposed to a string)

RE: What causes this sporadic error?

2004-05-21 Thread Paul Vernon
Sorry, I missed out an important point when I looked at your error The CFID and CFTOKEN that you give in your example are definately corrupt... The first place I look when I see errors like this is page and server enconding settings... Paul [Todays Threads] [This Message]

ColdFusion TechNote Notification: ColdFusion MX 6.1: IBM WebSphe re 5.1 support

2004-05-21 Thread Debbie Dickerson
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/was51_support.htm Intro: IBM WebSphere Application Server (WAS) 5.1 is generally supported with ColdFusion MX 6.1; however, there are certain configurations that are not. WAS 5.1 Base Edition is supported

RE: Active Directory

2004-05-21 Thread Coleman, Brian
I'm not sure why you wouldn't be able to take off the OUs...but maybe there's something above the OUs you can use? My queries I'm playing with to use AD based authentication look like this ***first query to connect to ldap and query the username entered*** CFLDAP NAME=ServConnect SERVER=server

Don't mean to be picky

2004-05-21 Thread Don
In the quest for the separation of business logic layer and presentation layer, went to fusebox.org site, interesting stuff, just for the heck of it, tried an invalid value for a parameter, fuse threw a cf error, it's sort of interesting that fuse threw its err msg, however, it also included CF

Re: excel files

2004-05-21 Thread Joe Tseng
I don't know if anyone would be interested in this but I'm doing something right now using CF and Excel but I'm using XML and SOAP rather than DSNs (my questions in this list earlier were regarding this little effort of mine).I created a CFMX web service that would pass an XML string via SOAP to

Re: Problem with CFC web service Flash

2004-05-21 Thread Rick Root
Rick Root wrote: I've got a web service that I use to authorize users against our DB2 Mainframe, and I recently changed it up to return an array of CFC datatypes instead of a structure. The WSDL generates fine... I can call the methods from the browser directly.But when Flash tries to

Re: excel files

2004-05-21 Thread George Abraham
Definitely share. I am not well-versed in XML, SOAP or VBA, but for a long-term solution, I could be persuaded to get my butt in gear. George At 10:54 AM 5/21/2004, Joe Tseng wrote: I don't know if anyone would be interested in this but I'm doing something right now using CF and Excel but I'm

Re: How does Amazon do that?

2004-05-21 Thread Jeff Langevin
Assuming you have an orders table and an orderDetails table (containing orderID and productID of each item in the order) it would be simple.Query the orderDetails table for any order containing the product ID of the item that the customer is looking at.At the same time, pull the other items in

Re: Passing a webservice a file

2004-05-21 Thread David Adams
I am thinking more of a image or doc file. Is this possible or am I confusing the concept of web services? an xml file? sure. tw -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:33 AM To: CF-Talk Subject: Passing a webservice a file My

Extracting an email address out of a text file

2004-05-21 Thread Ben Densmore
I have about 1800 text files that I exported from outlook that are all bounced emails. I need to extract the email addresses that were bounced back. Unfortunately not all mail servers bounce messages that look alike. I was thinking I could just read through each text file and find where the email

RE: Active Directory

2004-05-21 Thread Coleman, Brian
I'm not sure why you wouldn't be able to take off the OUs...but maybe there's something above the OUs you can use? My queries I'm playing with to use AD based authentication look like this ***first query to connect to ldap and query the username entered*** CFLDAP NAME=ServConnect

Re: Extracting an email address out of a text file

2004-05-21 Thread Claude Schneegans
I really don't want to manually go through each text file and copy and paste the email For this I would try to use CF_REextract to extract the address in its context. The address is variable, but the context is not. See CF_REextract at http://www.contentbox.com/claude/customtags/tagstore.cfm --

Re: Extracting an email address out of a text file

2004-05-21 Thread Bryan F. Hogan
I can vouch for cf_reextract. I use it as a spider for a web cvs I wrote and it works wonderfully. Claude Schneegans wrote: I really don't want to manually go through each text file and copy and paste the email For this I would try to use CF_REextract to extract the address in its

RE: Don't mean to be picky

2004-05-21 Thread Greg Luce
Yeah, IMHO FB 4/MVC is the ultimate in business logic/presentation later separation. I just finished my first FB4/MVC project, and I'm very happy with the way it turned out. A widely adapted methodology. Great support community. You're right, that error on fusebox.org is careless. Greg

Comma in price

2004-05-21 Thread Robert Orlini
I'm using dollarformat to convert prices. However, if I user inputs a large price with a comma, such as 1,200.00 it generates a cannot convert number error. To save time, what is the best way to allow a user to enter a comma and still be able to calculate the price against a quantity. Robert O.

RE: Don't mean to be picky

2004-05-21 Thread Lofback, Chris
A widely adapted methodology. adapted = great typo/pun! Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

'Select' statement question!

2004-05-21 Thread cf coder
The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.asstetID IN

Re: Comma in price

2004-05-21 Thread Claude Schneegans
Just remove any comma from the string first: CFSET price = replace(price, ,, , all) -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads]

Re: Comma in price

2004-05-21 Thread Rick Root
Robert Orlini wrote: I'm using dollarformat to convert prices. However, if I user inputs a large price with a comma, such as 1,200.00 it generates a cannot convert number error. To save time, what is the best way to allow a user to enter a comma and still be able to calculate the price

Re: 'Select' statement question!

2004-05-21 Thread Alexander Sherwood
At 11:42 AM 5/21/2004, you wrote: The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From

Re: Extracting an email address out of a text file

2004-05-21 Thread Jochem van Dieten
Ben Densmore wrote: I have about 1800 text files that I exported from outlook that are all bounced emails. I need to extract the email addresses that were bounced back. Unfortunately not all mail servers bounce messages that look alike. I was thinking I could just read through each text file

Re: 'Select' statement question!

2004-05-21 Thread cf coder
Sorry, I made a typo mistake. This is the correct sql SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where Employee.callNo IN (select distinct Employee.callNo from Employee where Employee.asst_id IN (select Assets.asst_id from Assets where bar_code = ' + char(39) + @asset + char(39)

Re: 'Select' statement question!

2004-05-21 Thread cf coder
yes I am using MS SQL Server [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

retreive the FORM name?

2004-05-21 Thread Claude Schneegans
Hi, Any one knows if it is possible to retreive the form name from the template fired by a form? -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks.

Re: 'Select' statement question!

2004-05-21 Thread Jochem van Dieten
cf coder wrote: The following code is in a stored procedure. Can somebody please just confirm if this is a valid SQL Statement. I appreciate this is not a SQL Forum. I'm a ColdFusion developer and am trying to query the db. SET @SQLStatement = @SQLStatement + 'SELECT * From Employee where

Re: retreive the FORM name?

2004-05-21 Thread Charlie Griefer
not via CF.you'd need to put it in a hidden form field. just out of curiousity...why would you need the form name? - Original Message - From: Claude Schneegans [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:56 AM Subject: retreive the FORM name? Hi, Any

RE: Comma in price

2004-05-21 Thread Robert Orlini
Thanks Rick and Claude. It worked. RO -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 11:44 AM To: CF-Talk Subject: Re: Comma in price Just remove any comma from the string first: CFSET price = replace(price, ,, , all) --

Re: retreive the FORM name?

2004-05-21 Thread Bryan F. Hogan
Try this, just a thought. cfif isDefined('form.submit') cfdump var=#form# /cfif script function checkForm(theForm) { document.forms[theForm.name].theFormsName.value=theForm.name; return true; } /script form action="" method=post name=formName checkForm(this) input type=hidden

Re: Extracting an email address out of a text file

2004-05-21 Thread Scott Weikert
There's also a tag on the DevEx, StripEmail - you pass it a string and it'll pull out email addresses and return them as a list. Works great for me. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: retreive the FORM name?

2004-05-21 Thread Guy Rish
Claude, Since only one form can post per request it is presumed that you will know because of the form's linkage to the ACTION. If you are using one uber ACTION handler then create a hidden INPUT that contains the name of the form.This can lead to problems though and it not the better choice.If

RE: Extracting an email address out of a text file

2004-05-21 Thread Ben Densmore
Thanks Claude, I bought the tag and it seems to work ok. I'm wondering if someone can help me with a reg ex. Just playing around with the tag I was trying: CF_REextract INPUTMODE=File INPUT=c:\cfusionmx\wwwroot\email_blast\#name# OUTPUTMODE=output RE1=([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]))

Re: Problem with CFC web service Flash

2004-05-21 Thread Rick Root
Here is my WSDL: https://www.ads.duke.edu/components/authorization/authorize.cfc?WSDL and a sample HTTP invocation... https://www.ads.duke.edu/components/authorization/authorize.cfc?method=authByUsernameUNAME=fooPWORD=fooSPECIFICLOGINS=SPECIFICGROUPS=APPNAME=ENTITY_LOOKUP But it will NOT

Re: retreive the FORM name?

2004-05-21 Thread Claude Schneegans
Since only one form can post per request it is presumed that you will know because of the form's Sure, but a template can contain several forms which all call the same template, even if only one is submitted. My question is then to detect the one that fired the template. --

Re: Problem with CFC web service Flash

2004-05-21 Thread Rick Root
More info... this definately has something to do with my CFC datatypes.. Here's the code where I'm invoking the CFC datatypes: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: 'Select' statement question!

2004-05-21 Thread cf coder
Thanks Jochem, but your sql returns duplicate callNo's. I tried both your queries. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: retreive the FORM name?

2004-05-21 Thread Claude Schneegans
Try this, just a thought. Ok, but it is precisely what I'm looking a simpler solution for. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays

SOT: Javacript Onclick Question

2004-05-21 Thread Casey C Cook
I would like to know if this is possible, I know very little about _javascript_, but if if someone could point me in the right direction I can do the research. Heres what Im trying to do. I have my main display page which calls a custom header. This custom header has an a href link that logs

Re: Extracting an email address out of a text file

2004-05-21 Thread Claude Schneegans
I bought the tag Congratulations: you're on the right track ! ;-) if someone can help me with a reg ex. Just playing around with the tag I was trying: Sure, try the REWizard, same author, same address, and this one is on line and free. Make sure you work with the CF syntax, not the

Re: retreive the FORM name?

2004-05-21 Thread GFSCold
What if you give the submit buttons unique names.That way you can check which form you are processing by the name of the submit button that was pressed. Jim Audette Website Administrator Garrison Forest School 300 Garrison Forest Road Owings Mills, MD 21117 [EMAIL PROTECTED] 410-559-3128 [Todays

RE: Javacript Onclick Question

2004-05-21 Thread Barney Boisvert
You'll need to get a reference to the link object, and then you can add a custom onClick handler to the object.If the A tag has an id attribute, then it's simple, just use document.getElementById(id_of_anchor) to get the object.If it doesn't, then you'll have to us document.links (I don't know how

RE: Selecting by row or CurrentRow

2004-05-21 Thread Pascal Peters
qProduct.field[theRowIWant] -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 mei 2004 13:11 To: CF-Talk Subject: Selecting by row or CurrentRow Could someone remind me of the syntax to select by row? I don't remember where to find that. Thanx Select

  1   2   >