RE: Browser resize looses attributes scope

2003-07-01 Thread Tyagi, Badal
No there is no JS but I've put only this meta tag META HTTP-EQUIV=Pragma CONTENT=no-cache Users are using strictly IE 5.5 only regards badal -Original Message- From: Nagy, Daniel J [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 6:46 PM To: CF-Talk Subject: RE: Browser resize

Mimic a perl/php function

2003-07-01 Thread Patric Stumpe
Hi cf-talkers, I'm not that maths genie so I'm wondering if it is possible to mimic the unpack()-function that's implemented in perl and php with ColdFusion? I have some data as an 32Bit Word in LittleEndian order and want to convert it to a normal decimal... Already searched the CFLib for

RE: visual fox pro db?

2003-07-01 Thread Bill Grover
Tony, We use FoxPro here all the time and have successfully migrated many systems to SQL. What is the issue/errors you are seeing? __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc.

RE: Refresh a frame

2003-07-01 Thread Bill Grover
I've used the following JavaScript function to change/refresh a frame from another frame: function ChangeFrame(toFrame, tcLocation) { toFrame.location.href = tcLocation; } HTH __ Bill Grover Supervisor MIS

Re: when do client variables update the db?

2003-07-01 Thread Calvin Ward
Couldn't you test this with the following somewhere in the page following your set statement? SELECT * FROM CDATA WHERE data like '%#variablename#%' And app = '#application.applicationname#' and cfid = '#cfid#:#cftoken#' Sorry, not near my app server to try this atm. - Calvin - Original

RE: visual fox pro db?

2003-07-01 Thread Tony Weeg
just missing a table in the import, that is there, in the foxpro files directory does this make sense? I have like 55 groups of 3 files, all I assumed where 55 different tables with some ancillary files to hold datacorrect? so, most of them import fine, its just that a couple, don't?

ot: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
select * from routes where 10509 = id why does this work? I always thought that it was supposed to read like... select * from routes where id = 10509 column, before the value? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax

RE: sql oddity (but weird)

2003-07-01 Thread Robertson-Ravo, Neil (RX)
Its perfectly valid. In T-SQL you can have a constant on either the left or the right. in essence 383709 does = ID just as much as ID = 383709 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 13:46 To: CF-Talk Subject: ot: sql oddity (but weird)

RE: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
well I know that :) cause it works here...its just way backward from everything I was taught...thats all...whats CORRECT? either, neither, both? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original

RE: sql oddity (but weird)

2003-07-01 Thread Ben Forta
Actually, you can have: WHERE column = column WHERE constant = constant WHERE column = constant WHERE constant = column All are allowed. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 8:46 AM To: CF-Talk Subject: ot: sql oddity (but weird)

Re: sql oddity (but weird)

2003-07-01 Thread Michael T. Tangorre
Ben??? Where have you been!!! - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:00 AM Subject: RE: sql oddity (but weird) Actually, you can have: WHERE column = column WHERE constant = constant WHERE column =

RE: sql oddity (but weird)

2003-07-01 Thread Robertson-Ravo, Neil (RX)
both are correct it just really what you are used to etc.. its not a case of whats allowed etc, its a case of what will produce the desired result. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 14:01 To: CF-Talk Subject: RE: sql oddity (but weird)

RE: sql oddity (but weird)

2003-07-01 Thread Robertson-Ravo, Neil (RX)
However, I do agree with you, its not what gets taught but I am sure in your code are snippets which are certainly not set in stone somewhere... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 14:01 To: CF-Talk Subject: RE: sql oddity (but weird) well I

RE: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
well, then it should always produce the desired result...if all are correct...neither should matter...all should work? correct? I wonder why it is, and why I havent seen the other way value = column in any books (especially the one I got at devcon 2001 sql in 10 minutes!!!) just weird, I guess

RE: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
select * from routes where 10509 = 10509 doesn't produce anything close to what im lookin for...that just returns all rows...? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ben

RE: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
of course my stuff is by the book ;) always... tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
Can anyone see what I am doing wrong? If I use the convert statement in the select clause instead of the where clause it works but I need to convert from the where clause against my criteria. -Original Message- From: Eric Creese Sent: Monday, June 30, 2003 5:24 PM To: CF-Talk Subject:

RE: sql oddity (but weird)

2003-07-01 Thread Robertson-Ravo, Neil (RX)
Yes, it will as the SQL you have just pasted simply reads SELECT ALL FROM ROUTES WHERE VALUE X = VALUE Y The engine is simply working logically and getting all rows where the X = Y (which it is) Again, this is expected behaivour. Think of it this way...If this was a CFIF it would simply

RE: sql oddity (but weird)

2003-07-01 Thread Nagy, Daniel J
like the objectivists say, A = A. all you're doing is giving it a true boolean. since 10509 DOES equal 10509, you're going to get * back. --d. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:13 AM To: CF-Talk Subject: RE: sql oddity (but

CF web-based report writer

2003-07-01 Thread Roth, John
Ahoy, CF Talk! I've been lurking for a few months now, and finally have a question worthy of posting. My boss is looking for a web-based report writer that uses Cold Fusion. does anyone know of anything out there like that? (I might even get him to pay for it... ;-) Yours Truly, J.B.

RE: CF web-based report writer

2003-07-01 Thread John Stanley
I have been doing this for a while. It depends on what you need. If you need a very robust solution that does things like sub reports, you may need to choose a product like Actuate e.reports or something similar. Most of the reports I do nowadays are just data sets that the users want to see.

Re: sql oddity (but weird)

2003-07-01 Thread Jochem van Dieten
Tony Weeg wrote: well, then it should always produce the desired result...if all are correct...neither should matter...all should work? correct? quote ©ISO/IEC ISO/IEC 9075-2:1999 (E) 8.2 comparison predicate Function Specify a comparison of two row values. Format comparison predicate ::=

Re: sql oddity (but weird)

2003-07-01 Thread jon hall
Tuesday, July 1, 2003, 9:25:45 AM, you wrote: JvD Tony Weeg wrote: well, then it should always produce the desired result...if all are correct...neither should matter...all should work? correct? JvD quote JvD ©ISO/IEC ISO/IEC 9075-2:1999 (E) JvD 8.2 comparison predicate JvD Function JvD

CFMX Append Issue? (James Blaha)

2003-07-01 Thread James Blaha
Hello All: I have a question about CF MX. I have simple code that creates a text file where each line should have a carriage return at the end. This works in CF5 but in MX it creates one long string in the text file. !--- White Pages: Start

Dynamic Test Engine

2003-07-01 Thread Scott Wilhelm
Would anyone know of any free, dynamic test engines? I'm trying to create an app that will include dynamic test generation for multiple types of tests (multiple choice, essay, matching, etc.) TIA! Scott ~| Archives:

Re: sql oddity (but weird)

2003-07-01 Thread Jochem van Dieten
jon hall wrote: Just curiosity on my part, but what does ::= translate to in english? Seen it before...just never understood it. http://cui.unige.ch/db-research/Enseignement/analyseinfo/AboutBNF.html Jochem ~| Archives:

RE: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
always there for the spec. jochem do you speak in spec. when dining with friends ;) tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]

RE: sql oddity (but weird)

2003-07-01 Thread Ben Forta
Actually, funny you should ask I tried to post a message to cf-talk last week and it bounced saying I was not subscribed. I don't remember unsubscribing, but honestly, I also can't remember when I last received messages. Sad, eh? Anyway, once I figured it out I resubscribed immediately.

RE: sql oddity (but weird)

2003-07-01 Thread Ben Forta
Of course it returns all rows. You are telling the database that for each row retrieved, check if 10509 is equal to 10509 (which it will be). -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:12 AM To: CF-Talk Subject: RE: sql oddity (but

Re: sql oddity (but weird)

2003-07-01 Thread Michael T. Tangorre
Same thing happened to me, but don't ask Michael D about it, he had to clean up a bunch of my accounts from the past 5 years Once that happened, I resubscribed with one name and email and and was good to go! Mike - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk

RE: sql oddity (but weird)

2003-07-01 Thread Tony Weeg
ahhh of course ;) duh. anyway, its just looked strange to me this morning when jaye, my head cfmxflashman here showed me some code he had worked on, and I was like WOA but it worked then we had this mind-bending morning that made last weekend look like a birthday party at mcDonalds...thats

RE: sql oddity (but weird)

2003-07-01 Thread Andy Ewings
MAkes no difference which comes first value or column. Simple case of Mathematical equality. This is why for the old inner join syntax (=) it didn't matter which table you had on left or right of join statement. In fact doesn't matter using new syntax either -Original Message- From:

RE: CFMX Problem with Connectors

2003-07-01 Thread Stephenie Hamilton
Hmmm, I am not sure how to restore the original perms. Sounds like you might want to start all over though. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 5:36

RE: CFMX Problem with Connectors

2003-07-01 Thread Brook Davies
Thanks for the reply. It turns out it was Black Ice's Rouge application protection running in another session (I am connected to a dedicated server via terminal services and have never sat at the machine). Brook At 10:15 AM 7/1/2003 -0400, you wrote: Hmmm, I am not sure how to restore the

RE: CFMX Problem with Connectors

2003-07-01 Thread Stephenie Hamilton
Aha! So were you able to get mx working with sp4? Or did you have to remove sp4? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:27 AM To: CF-Talk Subject:

RE: CFMX Problem with Connectors

2003-07-01 Thread Brook Davies
No, it's running w/ SP4 with no special changes. Works fine so far :) Brook At 10:29 AM 7/1/2003 -0400, you wrote: Aha! So were you able to get mx working with sp4? Or did you have to remove sp4? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original

RE: sql oddity (but weird)

2003-07-01 Thread Matthew Small
Which can be useful in certain situations, such as building dynamic queries. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:52 AM To: CF-Talk

RE: (OT) RegEx editor

2003-07-01 Thread Charlie Griefer
Hey Adam: As much as I despise all things WYSIWYG...I wouldn't mind a CFML RegEx generator. I still haven't quite gotten my head around writing regular expressions...even tho I know how powerful and userful they can be. I'd want a generator not to rely on...but to use so that I can start to get

RE: (OT) RegEx editor

2003-07-01 Thread Larry Juncker
ditto Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain

SSL with CFHTTP on MX

2003-07-01 Thread Matt
Are there any known issues using SSL with CFHTTP on CFMX? If I try to call a URL starting with https, I get a connection failure. If I then copy that address to a browser window, I get the expected return with no problems. I'm using Win2k. Anyone have any experience with this?

RE: SSL with CFHTTP on MX

2003-07-01 Thread Tony Weeg
it may be a problem with the cert. ive had that problem with certain certs...i think the one that I had issues was a rather new cert company, and they hadnt gone through all the loops and hoops to become accepted as a trusted cert provider...maybe instantssl or something like that? not sure of

Little OT: SQL Query Date Filter

2003-07-01 Thread Tony Gruen
I have been testing this and cannot envision a solution. SQL Server 2000 and CF5. I have a small table that records transactions. The date for each transaction is recorded in createodbcdatetime format. Transactions can occur throughout the day. I am creating a page that shows the days

RE: Little OT: SQL Query Date Filter

2003-07-01 Thread Robertson-Ravo, Neil (RX)
ermhow about : WHERE bDate = #variables.EDate# 00:00:00 AND bDate = #variables.TDate# 23:59:59 SQL Server uses the timestamp alongside the date as well. -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 16:56 To: CF-Talk Subject: Little OT: SQL

RE: Little OT: SQL Query Date Filter

2003-07-01 Thread Tony Weeg
SELECT * FROM Transactions WHERE bDate between #variables.EDate# AND #variables.TDate# where the dates can be any two dates, the query will return allthings matching, including things *on* those dates. using less than and greater than, excludes stuff not there...does this make sense... so if

RE: Little OT: SQL Query Date Filter

2003-07-01 Thread DURETTE, STEVEN J (AIT)
Sounds like you are using SQL Server. This is expected behavior because 6/30/2003 01:01:01.01 is greater than 6/3/2003 00:00:00.03 (think that's right). The second one is what you are creating. I believe that what you really want is : Select * from transactions where bDate = #variables.EDate#

RE: Little OT: SQL Query Date Filter

2003-07-01 Thread Scott Brady
-- Original Message -- From: Robertson-Ravo, Neil (RX) Neil.Robertson-ermhow about : WHERE bDate = #variables.EDate# 00:00:00 AND bDate = #variables.TDate# 23:59:59 Since that would get 3 days' worth (that would get you transactions on EDate and

RE: Little OT: SQL Query Date Filter

2003-07-01 Thread Robertson-Ravo, Neil (RX)
ah yeah, you got the picture ;-) The key is that you need to include the timestamp info. -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 17:07 To: CF-Talk Subject: RE: Little OT: SQL Query Date Filter -- Original Message

Re: SSL with CFHTTP on MX

2003-07-01 Thread jon hall
Could be this... http://mxc.blogspot.com/2002_12_15_mxc_archive.html I could swear at one time I read that cfhttp required a 1.4 JRE for SSL, but I haven't seen that piece of info in a while...so take that with a grain of salt. MM may have done the legwork to get JSSE working on 1.3 as well. --

Coldfusion MX installer problem - Please help

2003-07-01 Thread Allan Clarke
I have ColdFusion 5 installed on my machine. I ma now trying to install ColdFusion MX. When I run the CD, the install sheild window opens up, and I get the msg Preparing to Install and then I see the ColdFusion MX - Install Wizard, clickin on next takes me to the license agreement window. I have

RE: Refresh a frame

2003-07-01 Thread Paul Campano
Hi Bill. I put that javascript in the head of my page and tried calling it via ONclick and it doesn't workthe javascript error says location is null or not an object Here's my code: --This is in the head of the page script language=JavaScript !-- function ChangeFrame(toFrame, tcLocation)

RE: export to .xls tag?

2003-07-01 Thread Chris
Thank you very much. That does work great. Chris -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:02 AM To: CF-Talk Subject: RE: export to .xls tag? You can create an HTML table and save the file as an .xls file and it will create an

best practice for building a large text file?

2003-07-01 Thread James Blaha
All: What’s the best practice for building a large text file? Is it better to use CFFILE and APPLEND or use an array then once you have the information use arraytolist and then use CFFILE to create the text file? I have a 30 meg text file that I’m building line by line. Regards, James Blaha

RE: export to .xls tag?

2003-07-01 Thread DURETTE, STEVEN J (AIT)
One caveat to this... If you use CSS to format and the users have Office 97 it won't display properly. The office 97 programs use an older html (3.2 I think, but don't hold me to it). Steve -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:51 PM

Re: best practice for building a large text file?

2003-07-01 Thread David Brown
Can you use your database to do it? - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 1:04 PM Subject: best practice for building a large text file? All: What's the best practice for building a large text file? Is it

HTTP_REFERER and MS VPN

2003-07-01 Thread Sean McCarthy
Hi, Does anyone have any thoughts why vpn users are not passing or have the HTTP_REFERER defined when they come from another page? This is what I see when a vpn users information is dumped: HTTP_~~~ :~~~

OT: Regex question

2003-07-01 Thread Larry Juncker
Sorry for the OT, but I can not get any answers on CF-Regex.. I have the following code in a text file: ~TX which is tildeSTATECODEspace I want to do a regex in my text editor that will find every occurrence of every state and change it to: ~TX~or ~IA~OR ~NC~ I

Re: best practice for building a large text file?

2003-07-01 Thread Jim McAtee
For a very large file, something in between. If you build a big file within memory (in an array or text variable) then you risk bringing the machine to a standstill or even crashing it. If you append to a file line by line a couple of million times you'll also tax the system and won't be doing

RE: best practice for building a large text file?

2003-07-01 Thread Barney Boisvert
When I'm building files, I usually use build up a string/array (depending on the situation) in memory, and then flush it to the file periodically, because string concatenation gets expensive as the string gets large. This example (a horribly contrived one) uses the string concatenation method,

Re: best practice for building a large text file?

2003-07-01 Thread James Blaha
Jim, Thank you so much for your reply. I really like your approach. Can you please just explain this line below. I'm building the file looping through a query. cfloop (until you're done) Have a great weekend! Regards, JB Jim McAtee wrote: For a very large file, something in between. If

Not displaying

2003-07-01 Thread Robert Orlini
I am currently working on a simple shopping cart for our book orders. I have update fields for each book for any changes to quantity a customer may want to make. Clicking Update takes them to the update.cfm page which displays the new qty and price (using sessions). However, the update page

Re: best practice for building a large text file?

2003-07-01 Thread James Blaha
Barney, Thank you so much for your reply. I need to digest this one. Have a great weekend! Regards, JB Barney Boisvert wrote: When I'm building files, I usually use build up a string/array (depending on the situation) in memory, and then flush it to the file periodically, because string

Re: Not displaying

2003-07-01 Thread Jeff Garza
You need to wrap the expressions inside of your loop with a CFOUTPUT... Jeff - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:37 AM Subject: Not displaying I am currently working on a simple shopping cart for our

Re: best practice for building a large text file?

2003-07-01 Thread Jim McAtee
I didn't know the looping condition for your particular application. You'd just loop over your query. cfloop query=myquery ... /cfloop - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 11:37 AM Subject: Re: best

RE: best practice for building a large text file?

2003-07-01 Thread Barney Boisvert
It's all but identical to what Jim said, except I forgot to add newlines to my string, and I have the commented array usage in there. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com

Re: Regex question

2003-07-01 Thread Jim McAtee
If you just want to replace all occurences of ~AA (caps only), anywhere in the file and you have the entire file contents in a single variable, the following should work: cfset y = REReplace(x, (~[A-Z]{2}), \1~, all) If you need to discern this character sequence only when it's the only thing on

RE: Coldfusion MX installer problem - Please help

2003-07-01 Thread Christine Lawson
Hi Allan, Take a look at this article http://www.macromedia.com/support/coldfusion/ts/documents/configure_web_server_option.htm and make the registry key change. You should then be prompted to co-exist. Christine -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent:

Re: OT: Regex question

2003-07-01 Thread Marlon Moyer
This might work: REreplace(test, ~([A-Z]{2})[ ], ~\1~ ,ALL) Marlon Larry Juncker wrote: Sorry for the OT, but I can not get any answers on CF-Regex.. I have the following code in a text file: ~TX which is tildeSTATECODEspace I want to do a regex in my text editor that will find

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01, 2003 7:49 AM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Can anyone see what I am doing wrong? If I use the convert statement in the select clause instead of the where clause it works but I

Re: Refresh a frame

2003-07-01 Thread Christian Cantrell
It looks like you are missing a reference to top. Try something like this: function changeFrame(frame, url) { top[frame].location = url; } Call it like this: a href=javascript:changeFramePage('otherFrame','http://yahoo.com')Load Yahoo/a You can also just use the target attribute of

RE: Little OT: SQL Query Date Filter

2003-07-01 Thread Tony Gruen
A huge thanks to all who took the time to respond. Now I am a little wiser and it is working. Tony Gruen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

MX Fun

2003-07-01 Thread GL
My CFMX stopped working over the weekend. I tried reinstalling and whatever I could think of. I finally had to uninstall/reinstall IIS. I installed CF5 first to make sure it was configured properly, then I installed MX over the CF5. The final step configuration errored trying to import the

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread DURETTE, STEVEN J (AIT)
Without seeing the actual data being converted, my guess would be that substring 11 is the problem. IE: 06/30/2003 = 10 characters not 11. Also, could your data not prepend 0 to months and days? Such as 6/5/2003 or maybe even 6/5/03? Without knowing more about the data being processed, that is

RE: OT: Regex question

2003-07-01 Thread Larry Juncker
I am doing the replacements in TextPad on a text file that I am parsing. Is there not a regex that would work without running it through CF? Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information

Re: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Marlon Moyer
Have you tried using Cast instead of Convert, ie My query: select personid from persondemographic where cast(substring(demographicvaluedesc,1,11) as datetime) '06/30/2003' and demographicgroupid =4 and demographicitemid = 4 and demographicvaluedesc is not null Marlon Eric Creese wrote: No

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
Did you try cast (substring(demographicvaluedesc,1,11) as datetime) ? (assuming substring(demographicvaluedesc,1,11) is the datepart of your string. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: Eric Creese

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
Did you try cast (substring(demographicvaluedesc,1,11) as datetime) ? (assuming substring(demographicvaluedesc,1,11) is the datepart of your string. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: Eric Creese

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
Yes I tried this, same error. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 1:46 PM To: CF-Talk Subject: Re: SQL DATE CONVERSION QUESTION Have you tried using Cast instead of Convert, ie My query: select personid from persondemographic

SOT: Correct way to match a record with a list in one field?

2003-07-01 Thread Lee Fuller
Ok guys.. Thinking caps: ON Have an nvarchar field in the database with data like: 1,3,9,12,2,51 Have a formfield with single number (not digit) data, like: 1 or 12 -- single whole numbers, maybe more than 1 digit. Now, would like to do something like this: SELECT EmailAddr,

Re: OT: Regex question

2003-07-01 Thread Jim McAtee
Do you have CF Studio or HomeSite+? They both permit the use of re's in the Extended Find and Extend Replace dialogs. The regex syntax should be pretty much identical to CF Server's syntax. Hard to say what TextPad's abilities or quirk's are when working with regular expressions. From your

RE: best practice for building a large text file?

2003-07-01 Thread Jeff Beer
Wait - it's only Tuesday... Can I have your job? ;p From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:44 AM { ... } Have a great weekend! Regards, JB ~| Archives:

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
Oh, ok, you've got an error meaning that some of the data that you are converting actually is not date information. Maybe you could do this: Where ... And isdate(substring(demographicvaluedesc,1,11)) is true Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED]

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
Oh, ok, you've got an error meaning that some of the data that you are converting actually is not date information. Maybe you could do this: Where ... And isdate(substring(demographicvaluedesc,1,11)) is true Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED]

Re: best practice for building a large text file?

2003-07-01 Thread James Blaha
Jeff, Its been a long day! :-) Regards, JB Jeff Beer wrote: Wait - it's only Tuesday... Can I have your job? ;p From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:44 AM { ... } Have a great weekend! Regards, JB

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread DURETTE, STEVEN J (AIT)
Ok, I need a sanity check! Isn't 06/30/2003 only 10 characters? Just wondering because after my initial post I see a lot of replies with the 11 back in there? Steve -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:06 PM To: CF-Talk

Re: Correct way to match a record with a list in one field?

2003-07-01 Thread Jim McAtee
Can you put leading and trailing commas into the field? ,1,3,9,12,2,51, SELECT EmailAddr, RecipientID FROM SupportEmailRecipient WHERE SubjectID LIKE '%,#FORM.SubjectID#,%' Better would be to normalize the data into two tables. - Original Message - From: Lee Fuller [EMAIL

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
You're right, it is. I wasn't paying attention to that. Sorry. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:10 PM To: CF-Talk

CFMail Attachments

2003-07-01 Thread Mark Leder
Hi all, I'm using cfmailparam (twice) to send two email attachments (pdf files). (This is a text only message, no HTML). Receives fine when sending to Outlook and Eudora. However, I find that receiving in AOL 8.0, the two attachments are in Zip format. I'm concerned that some folks won't have

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
the date string in the 255 varchar field is stored as Jul 01 2003 12:00 AM now if I put the convert(datetime,substring(demographicvaluedesc,1,11),101 in the select clause it will return the data correctly, how ever I need this logic in the where clause. -Original Message- From:

Re: CFMail Attachments

2003-07-01 Thread Jochem van Dieten
Mark Leder wrote: I'm using cfmailparam (twice) to send two email attachments (pdf files). (This is a text only message, no HTML). Receives fine when sending to Outlook and Eudora. However, I find that receiving in AOL 8.0, the two attachments are in Zip format. I'm concerned that some

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread DURETTE, STEVEN J (AIT)
Ok, That changes things. Are you sure that one of your rows doesn't have improper data? I used to have a database that used strings instead of a datetime and I always had the problem of people putting in things like INC or NR or other stuff where the date needed to go. Steve -Original

Re: CFMail Attachments

2003-07-01 Thread Ben Densmore
I don't think there is much you can do. AOL has had problems like this since 3.0. We used to send out emails to our customers with zip files attached and AOL would convert them to .bin attachments for some strange reason. Ben - Original Message - From: Mark Leder [EMAIL PROTECTED] To:

Re: SOT: Correct way to match a record with a list in one field?

2003-07-01 Thread jon hall
Normalize your SubjectID column...otherwise you will need to either get creative with the string functions in sql, or do the compare with CF. -- jon mailto:[EMAIL PROTECTED] Tuesday, July 1, 2003, 2:58:55 PM, you wrote: LF Ok guys.. Thinking caps: ON LF Have an nvarchar field in the database

Data Types?

2003-07-01 Thread James Blaha
CFer’s, I have users who are cutting and pasting from a word document into a text area within a form. I need to insert that information into one field in SQL Server 7. What is the best data type to use? Regards, JB ~|

Re: Cold Fusion Forums - reindex?

2003-07-01 Thread Jochem van Dieten
Al Musella, DPM wrote: I just inherited a website that uses the old allaire forums software. I had to move it to a new server, but didn't have access to the verity collections, so I need to reindex it. I can't figure out how to reindex it. I tried searching the web, but couldn't find

Re: CFMail Attachments

2003-07-01 Thread Matt Robertson
AOL does this themselves and unless someone knows a magic setting and wants to share this is out of your control. The reason for it is that AOL likes to make themselves as annoying and difficult as possible. Oh, and don't forget capricious and intrusive. That too.

RE: Data Types?

2003-07-01 Thread Bryan Love
depends entirely on what DB you are using, whether or not you want it to be searchable, and what you want the max allowable size to be. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer

Re: Data Types?

2003-07-01 Thread William Bowen
text (for virtually unlimited sizes or input text, though that may be limited by HTML form limits) varchar (for input text limited to certain sizes) will - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:54 PM

RE: CFMail Attachments

2003-07-01 Thread Mark Leder
I agree with all your comments Matt. A slightly different issues, related to these attachments. Doing a send out to a list of about 600 emails, the server throws a timeout error midway through the process. When I set the cfmail timeout to, say = 900, I still get the error, at the same point in

Re: Data Types?

2003-07-01 Thread Ben Densmore
text would be the best data type to use to store info from a text area field. Ben - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:54 PM Subject: Data Types? CFer's, I have users who are cutting and pasting from a

RE: CFMail Attachments

2003-07-01 Thread Matt Robertson
That thing was originally meant to throttle down mail to a level that a shared ISP could handle. I put it together partially with the advice of one of the guys at Virtualscape (which will tell a lot of people how old the code is). It *may* help you. I remember I was told that for the mail to

  1   2   >