RE: Invalid parser construct eror
No that's incorrect.. no quotes
#Evaluate(SumTotals.RegTotal + SumTotals.OTTotal)#
the problem however is that the value is not numeric.
Check how you are getting the value .5
It is obviously not calculated in the template, so an easy way to fix this
is make sure the data types presenting the values are numeric.
e.g make the data type float if you are using SQL server
Also use the IsNumeric function on the values.
-j
-Original Message-
From: Brendan Avery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 5:18 PM
To: CF-Talk
Subject: RE: Invalid parser construct eror
No actually, keep the single quotes.
> -Original Message-
> From: James Curran [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 14:12
> To: CF-Talk
> Subject: RE: Invalid parser construct eror
>
>
> And the single quotes.
>
> #Evaluate(SumTotals.RegTotal + SumTotals.OTTotal)#
>
> - j
>
> -Original Message-
> From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 5:06 PM
> To: CF-Talk
> Subject: Re: Invalid parser construct eror
>
>
> Get rid of the ## inside the evaluate.
>
> Jerry
>
> >>> [EMAIL PROTECTED] 02/20/02 04:59PM >>>
> Hey all,
>
> Is there any reason why this error would occur with the
> following code?
>
> An error occurred while evaluating the expression:
>
>
> #Evaluate('#SumTotals.RegTotal# + #SumTotals.OTTotal#')#
>
>
>
> Error near line 303, column 185.
> --
> --
>
>
> An error has occurred while processing the expression:
>
>88 + .5
>
>
> Invalid parser construct found on line 1 at position 6. ColdFusion
was
> looking at the following text:
>
> .
>
>
>
> IS there a problem with my evaluate statement?
>
> -Gel
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Invalid parser construct eror
And the single quotes.
#Evaluate(SumTotals.RegTotal + SumTotals.OTTotal)#
- j
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 5:06 PM
To: CF-Talk
Subject: Re: Invalid parser construct eror
Get rid of the ## inside the evaluate.
Jerry
>>> [EMAIL PROTECTED] 02/20/02 04:59PM >>>
Hey all,
Is there any reason why this error would occur with the following code?
An error occurred while evaluating the expression:
#Evaluate('#SumTotals.RegTotal# + #SumTotals.OTTotal#')#
Error near line 303, column 185.
An error has occurred while processing the expression:
88 + .5
Invalid parser construct found on line 1 at position 6. ColdFusion was
looking at the following text:
.
IS there a problem with my evaluate statement?
-Gel
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Force Pop-Up Window
Use javascript in the popup to set the field value of a hidden field and don't give them an option to enter into a text field. - j -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10:31 AM To: CF-Talk Subject: OT: Force Pop-Up Window I am using a pop-window for date entry for my application. Does anyone know of a way to force users to use the pop-up? I want to prevent users from keying in a date via keyboard. James __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RGB / HEX color
Can you send an example of your RGB color value items in your list? - j -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 12:39 PM To: CF-Talk Subject: RGB / HEX color working on something and I need to figure out a way to convert a list of RGB color values to the web-hex value. does anyone know of a site or some kind of reference that shows some conversion equation or something? I need to do this programmatically instead of figuring them all out manually. Thanks, -chris.alvarado [application developer] 4|Guys Interactive, Inc. http://www.4guys.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic Images Using Coldfusion
Forgot about the twice-a-day part. And screwed up the function: Try This: Just name your files: monday_morn.cfm monday_eve.cfm tuesday_morn.cfm etc. - j -Original Message- From: James Curran [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 11:33 AM To: CF-Talk Subject: RE: Dynamic Images Using Coldfusion Try this: - j -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 11:26 AM To: CF-Talk Subject: Dynamic Images Using Coldfusion Hi I have the following script that changes an imagemap for each day of the week, however I would like it to change twice a day once in the morning from midnight to twelve noon, and from twelve noon to twelve midnight. How can this be built into the script ? any ideas would be most appreciated, also is this code the most efficient way to achieve this ? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic Images Using Coldfusion
Try this: - j -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 11:26 AM To: CF-Talk Subject: Dynamic Images Using Coldfusion Hi I have the following script that changes an imagemap for each day of the week, however I would like it to change twice a day once in the morning from midnight to twelve noon, and from twelve noon to twelve midnight. How can this be built into the script ? any ideas would be most appreciated, also is this code the most efficient way to achieve this ? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Color Coding Scheme in Studio
(proper subject this time) Hey.. Anyone here know if it is possible to add an "element" to the Color Coding Schemes in CF Studio? Thanks. - j __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Deleting Row from Array
Hey.. Anyone here know if it is possible to add an "element" to the Color Coding Schemes in CF Studio? Thanks. - j -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 4:23 PM To: CF-Talk Subject: Re: Deleting Row from Array > Anyway, that being said, here is your problem: > arrayDeleteAt returns a boolean true/false, so when you say > > you are actually setting session.cart to "true". Do this: > > Doh! And I read that in the reference over and over, too. Thanks for straightening me out. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Loop Logic Question
You can loop over the ads and insert the ad_ID into a array based on the weight. So in this case ad_1 is inserted 4 times, ad 2 three times etc. Then choose a random number between 1 and arrayLen(ad_array) The random selection will now output the weighted results. - j jim.curran technical.director nylon.technology [EMAIL PROTECTED] -Original Message- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:38 PM To: CF-Talk Subject: Loop Logic Question I'm writing an ad insertion tool and I have a logic question. I have 4 weighted ads: Ad1 .4 Ad2 .3 Ad3 .2 Ad4 .1 and I want to distribute them into 10,000 newsletters depending on their weight (4000 Ad1, 3000 Ad2, etc.) I'm trying to throw them in an array with 10,000 elements and add that array to my email query with QueryAddColumn. BUT... I'm having trouble writing the loop structure to go over the 10,000 newsletters and assign an Ad depending on weight. Any suggestions? Mark Kecko Technology Director MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: page break when printing
This is fairly straight-forward as well:
- j
jim.curran
technical.director
nylon.technology
[EMAIL PROTECTED]
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:26 PM
To: CF-Talk
Subject: RE: page break when printing
At the DC CFUG, this came up. The solution was to use:
.
h6 {page-break-after: always)
.
code before break
You might download the presentation from www.cfugorama.com.
The intent here was to get this to work as a page break in word when
opening an HTML file and saving it out as .doc
Of course, IE only.
>>> "Steve Oliver" <[EMAIL PROTECTED]> 02/15/02 12:37PM >>>
Isn't it something like
Your content
I could be wrong there, I've seen saw something like that in a previous
post. You could check the archive.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Dimo Michailov [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:32 PM
To: CF-Talk
Subject: OT: page break when printing
All:
Can anyone recommend a good way to set a page break when printing
documents. I have been playing with CSS and { page-break-after: left }
but it does not always work as intended, especially with Netscape
Navigator.
Anyone have a solution to this? Thanks,
Dimo
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF/Flash Integration problem in NS 6
Try using: flashfile.swf?var1=1&var2=2 etc. Just like CF. It works well. - j jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 2:31 PM To: CF-Talk Subject: Re: CF/Flash Integration problem in NS 6 Mike Chambers wrote: > how are you getting the data from ColdFusion to Flash? I'm using GetVariablesNum to get the variables from a template. (The template looks at which file in the browser is currently loaded and sends the appropriate strings and URLs back to Flash). Scott -- Scott Brady http://www.scottbrady.net/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Color Pallette
You'll need a in there too somewhere... -Original Message- From: James Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:46 PM To: CF-Talk Subject: RE: Color Pallette If you want to use the 216 Web pallate, you can loop over the following HEX list: 00, 33, 66, 99, CC, FF With three Nested loops: #r##g##b#, - j jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] . -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:53 PM To: CF-Talk Subject: Color Pallette Does anyone have a tab delimeted list of a windows 256 color pallette? It is for a forum and typing in all the hex values is a pain in the keester There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Color Pallette
If you want to use the 216 Web pallate, you can loop over the following HEX list: 00, 33, 66, 99, CC, FF With three Nested loops: #r##g##b#, - j . jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] .. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:53 PM To: CF-Talk Subject: Color Pallette Does anyone have a tab delimeted list of a windows 256 color pallette? It is for a forum and typing in all the hex values is a pain in the keester There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access to SQL Server
You need the: "Insert Into TABLENAME" Part
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 11:53 AM
To: CF-Talk
Subject: Re: Access to SQL Server
Thanks for your help. I have another question. Normally this query works
(in Access):
(FirstName, LastName, Email, Address, City, State, ZipCode, DOB, Phone,
QuestionOne, QuestionTwo, QuestionThree, QuestionFour, QuestionFive)
Values
('#form.first#', '#form.last#', '#form.address#', '#form.city#',
'#form.state#', '#form.zip#', '#variables.dob#', '#variables.phone#',
'#form.cupsaday#', '#form.howoften#', '#form.typesofcoffee#',
'#form.percentprepared#', '#form.otherbrands#')
But trying to insert it into sql server I get this error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'FirstName'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (28:1) to (28:48).
Is the syntax alot different when inserting into sql server than Access?
- Original Message -
From: "Tyler Silcox" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 8:46 AM
Subject: Re: Access to SQL Server
> set your primary key as an INT, then you have to set your Identity to Yes
> (Not for Replication)...are you using Enterprise Manager or scripting?
>
> Tyler Silcox
> email | [EMAIL PROTECTED]
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, February 08, 2002 10:35 AM
> Subject: Access to SQL Server
>
>
> In Access you can set the primary key to auto number - how do you do this
in
> SQL Server? I would assume that has something to do with this error that
I
> am getting:
>
> Error Diagnostic Information
> ODBC Error Code = 23000 (Integrity constraint violation)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the
value
> NULL into column 'UserID', table 'SaraLee.dbo.ChockUsers'; column does not
> allow nulls. INSERT fails.
>
>
>
> Thanks!
>
>
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I need to do a sum on a secondary (left outer join) table...
Here's an example i use: The table names don't make sense, but the logic is there SELECT master.master_ID, SUM(sub_table.cost) AS total FROMmaster INNER JOIN sub_table ON master.master_ID = sub_table.master_ID GROUP BYmaster.master_ID jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 11:00 AM To: CF-Talk Subject: I need to do a sum on a secondary (left outer join) table... Is there a way to grab all the records from one table and sum up all the values of a column from another table based on a foreign key? This is what I'm trying to do: SELECT primary.primary_id, primary.initiated, primary.completed, SUM(secondary.received) FROM primary LEFT OUTER JOIN secondary ON primary.primary_id = secondary.primary_id I want to grab all of the rows from primary, but then I want to count the received amount for every record in the secondary table that have the id from primary... so if I have 3 records in the primary table, and 15 records in the secondary (5 per each record in primary), I just want to return the 3 rows from the primary and the sum of all the received columns in the secondary pertaining to the primary's id...whew... desired recordset: 1initiatedcompleted50(so this could be the sum of 5, 5, 5, 5, 5 [from 5 different rows in the secondary table with the primary_id or 1]) 2initiatedcompleted222 3initiatedcompleted0 Tyler Silcox email | [EMAIL PROTECTED] website | www.gslsolutions.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to Find Hidden Characters -- maybe related to whitesp...
Try Searching for the following: chr(13) & chr(10) or any combo of the two. - j . jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] .. -Original Message- From: Carol Bluestein [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:02 AM To: CF-Talk Subject: How to Find Hidden Characters -- maybe related to whitesp... Subject: How to Find Hidden Characters -- maybe related to whitespace issue - Greetings all. I'm having one !@#%$#$^$%^& of a time figuring this out. Can anyone out there help? The Task: Taking the information from the error/cferror variables saving them in a log file which can then be displayed in EXCEL, with one column per variable. The Problem: everything works EXCEPT error.diagnostics, which insists on placing itself in two columns. The Analysis: The diagnostics information is preformatted by coldFusion and contains a hidden cr/lf or paragraph marker(s) that I can not seem "read" programmatically so that I can remove it. The Question: How do I do this... remove these hidden characters? Testing so far has shown that I can remove the hidden marker by removing a block of space in which it is contained, but it requires that I have seen where it occurs and for which type of error and an assumption that it will always "look" the same for each error. If I try to remove just "extra spaces" in a loop, the hidden character does not get "caught" and remains. Anyone have any ideas I've been working on this for several days. Any help would be very much appreciated. Thanks, Carol Carol Bluestein TAAD, Senior Programmer NYS Office of Real Property Services 16 Sheridan Avenue Albany, NY 12210 518-486-6335 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL missing messages
Did you try examining the unsent messages in c:\CFUSION\MAIL\UNDELIVR? Compare those with the mail log in Cfadministrator.. Usually there are some smtp restictions at play here, such as malformed email addys or relay restrictions. I usually get around this by running SMTP server on the windows machine running CF and allowing relay only from that IP... - j jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Keane, John (WDS) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 6:23 AM To: CF-Talk Subject: CFMAIL missing messages I have two different websites that use CFMAIL to send order confirmations and feedback messages to users and to internal mailboxes for reaction by customer service personnel. Ocassionally these messages are not getting through. In a recent application, 175 messages were sent in a 30 day timeframe. An analysis of these messages shows that only 130 were actually delivered. All 175 messages were sent from the same cfm template page to the same email address using the same code. Our websites are hosted by a webhosting company. Is this a common problem with CFMAIL? Can anybody give me any idea as to what could be causing these messages to be lost? Thanks for your assistance. John Keane EMAIL: [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-based DNS Manager software beta
Are you building your own DNS server too or are you just building the CF to integrate with Windows 2k's built in DNS? - j -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 11:39 PM To: CF-Talk Subject: CF-based DNS Manager software beta Hello. I mentioned a few days ago that we've been developing CF-based DNS management. I am looking for a small group of beta program participants. If you are interested, read on, otherwise please disregard this message. If you are interested: Please fill out the following form: http://www.brainbox.net/idnsm_beta/ (excuse the form, its not pretty...;) ) Beta testers will be entitled to free 1.x software, and opt-in for future releases, and the likelihood of your feature requests being implemented will be much greater. Thanks ya'll. -Bill brainbox __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: looping inside cfquery - brain on vacation
Are there -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 8:01 PM To: CF-Talk Try taking out the tags and output the loop to the screen surrounded with Then just check your SQL statements... It's usually standing out like a sore thumb :) - j OK..long day..CF whining about syntax...help! The situation: CF doesn't like my syntax for this bit of looping over a query to insert muliple records. It's complaining about the final ")" closing bracket for the insert. Any ideas? I'm sure I've done it beforejust saw it posted the other week too...geesh talk about timing ;-) INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) TIA Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Formatting a Date in MS SQL Access Query...Try Again
you can store the time/date data in one field and make a view/query breaking out the separate parts into 2 new fields.. - j -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 6:32 PM To: CF-Talk Subject: Re: Formatting a Date in MS SQL Access Query...Try Again Thanks for the response and tips. Are you suggesting I use a date and a time column in my classes db? With several classes per day, they each have a time of day. I was trying to be efficient and use a single date/time field to store this info. The trick then becomes how to find records with the same date (ignoring the time element) for all classes on any given day. Bruce - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 3:08 PM Subject: Re: Formatting a Date in MS SQL Access Query...Try Again > On 2/6/02, Bruce Holm penned: > >BTW, when I created the date in Access, I specified the Date format to be > >General which stores date and time info in the SAME field. > > BTW Bruce. Access always stores dates as date and time. So does SQL > Server. When you choose type of date/time when creating the field, > you're just telling Access how to display it when looking at the > table directly. > > The trick is, when you insert a date with a SQL query, insert it with > createodbcdate. Then the time portion of any date/time you enter, > such as #createodbcdate(now())#, will be inserted as 00:00:00. Then > the search using# createodbcdate(mydate)# will return that date. This > way you won't need to search for a range if looking for a single date. > -- > > Bud Schneehagen - Tropical Web Creations > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server / SQL 2K / IIS
Nope. - j -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 4:52 PM To: CF-Talk Subject: Re: CF Server / SQL 2K / IIS > Is it necessary for IIS to be running on the SQL Server if our webserver is > a totally separate machine? No __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced CFCATCH Exception Types
Try this: The only problem is that the file must complete the upload process, which could be a pain... - j . jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] .. -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 3:13 PM To: CF-Talk Subject: Advanced CFCATCH Exception Types I would like to trap a CFFILE error using CFTRY/CFCATCH if the user submits a bad file type. I only want to allow them to upload .gif files. I can use the CFCATCH TYPE="Any" to trap it, but I was hoping that I could trap specifically for a bad file type. I noticed that there are a whole slew of "advanced" exception types starting with COM.* listed in the documentation, but I can't find one for a bad file type. Can one of those advanced types or a regular type be used other than "Any"? Thanks, Dave. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
