Re: list help

#ListGetAt(eList, ListPosition, ,)# You can get that type of error if your listposition variable is 0 sabrina - Original Message - From: Joshua Tipton To: CF-Talk Sent: Wednesday, May 09, 2001 4:33 AM Subject: list help Please help me to figure out why this isnt

Re: Log files of a web attack.

A little more info is starting to go around. This attack is a scripted attack from a worm that infects Solaris machines, which then attack up to 2000 IIS servers before putting up the f*ck usa pages on the Solaris machine. Mostly harmless, but you gotta admire the mind that came up with that.

RE: Uploading a file

The file is a small Word Document so should not take up too much space at all..any ideas? nb -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 18:39 To: CF-Talk Subject: Re: Uploading a file How large is the file? How much free diskspace and

RE: Uploading a file

however, I can upload a TXT file! (but not a word doc) -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 08:54 To: CF-Talk Subject: RE: Uploading a file The file is a small Word Document so should not take up too much space at all..any ideas? nb

Linking accross datasources.

I seem to remember reading last week that someone had said you could query one datasource and reference another within it. Somethinglike datasourcename.tablename.fieldname Is this true ? Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038

cffile vars

Got a q. about CFFILE variables. CFFile.ContentType and CFFile.ContentSubType - are they reliable enough? I allow people to upload gif/jpg to one of my sites, and ONLY jpg/gif but I bet some of them will try to rename a .mp3 file into .gif or something Can I use this to filter other formats,

RE: [Object Oriented CFML]

Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's

RE: ASP NumberFormat

WTF? Is this a joke? -Original Message- From: Chris Maloney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 8:04 PM To: CF-Talk Subject: RE: ASP NumberFormat Nathan, At first only your newsletters made me wonder about your lack of professionalism. Chris -Original

UK ColdFusion/ASP developer required

Position / Location ==Applications developer (Cold Fusion, ASP) Rainford (near St Helens), Merseyside, United Kingdom Start date ==From 21st May 2001 Skill set requirements == Necessary: HTML

RE: Uploading a file

There should not be a problem with the file size. Some one in my company was uploading online manuals in pdf format and my programme started to fall over. Fair enough really when the files are 15 meg but the message I got was different to that. -Original Message- From: Nick Betts

Watchguard Firewall II stripping CGI variables?

A Watchguard Firewall II has just been installed and it looks as though the default setting is to strip out unknown HTTP headers, judging by the information on their website. It appears to remove a raft of CGI variables sent by the browser and the only ones available are the ones ColdFusion

RE: Limit on SQL passed via CFQuery to SQL Server?

I disagree..If you use the Transact SQL language to it's full capabilities you can easilly build up a dynamic SQL string and execute it using EXEC(sqlstring)...in fact I'd say much better than you can using cfquery!. OK, if you do this you lose the query plan generated by SQL which is one of

RE: [Object Oriented CFML]

Nick Yeh I thought that sounded pretty interesting too! I'm the first person to admint that serverlets are pretty coollightning quick if I remember correctly. What bothers/worries me is how you can convert your cfml code into a serverlet without losing anything in the

concurrency problem..

hi ppl... i have a hotel booking system that lets the users to reserve room thru the web. I retrieve the hotel room capacity to show the current room available... if the capacity is zero.. the page will indicate fully booked. In order to have the most updated info.. i actually retrieve the

Re: Limit on SQL passed via CFQuery to SQL Server?

* Team Allaire * I disagree..If you use the Transact SQL language to it's full capabilities you can easilly build up a dynamic SQL string and execute it maybe, but its not designed to be used this way and i beat that sql is one darned

Q. about Encoding

Is it possible to Encode a certain string into specific set of characters? when I use the Encode() function it gives out a WELL ENCODED STRING, but the problem is that it's TOO ENCODED - It can't seem to be placed securely into form fields or urls (because it sometimes contains special signs such

Re: Q. about Encoding

on 5/9/01 6:01 AM, Michael Lugassy at [EMAIL PROTECTED] wrote: Is it possible to Encode a certain string into specific set of characters? when I use the Encode() function it gives out a WELL ENCODED STRING, but the problem is that it's TOO ENCODED - It can't seem to be placed securely into

CFX_IMAGE original?

I just downloaded 2 cfx tags named: cfx_image. the first one was downloaded from allaire dev exchange - by gafware. the second one was downloaded from intrafoundation - by jukka. which one is better? I need to put this cfx into extensive use. any help would be appriciated. Michael.

Re: How do I open an IE window into fullscreen channel mode?

Hi Spadea. Welcome to the list. Try this in the head section. SCRIPT LANGUAGE=JavaScript !-- BrowserName = navigator.appName; BrowserVersion = parseInt(navigator.appVersion); if (BrowserName == Netscape) { self.moveTo(0,0) self.resizeTo((screen.availWidth-8),(screen.availHeight-45)) } else {

Re: Log files of a web attack.

I used Netscape FastTrack and/or Enterprise for the longest time on Win32. Finally, when it too bloated and I got frustated at its error-handling, I switched to Apache which come around to great Win32 version... IIS - Never used it, never will. I am getting more and more annoyed at Microsoft's

Re: concurrency problem..

I have somewhat of the same issue... In my shopping cart which show live inventory available, stock is check before you put the item in the cart. And then again during a transaction which puts the item in your order. But there is the possibility that someone will have ordered the last widget

RE: [OT] CF to PHP converter

Interesting..it seems like quite a few folk want to use Allaire's language to port over to other languages.. Tagservlet.com is doing it from CFML to .jsp I believe (same thing CF6 wants to do?)...and now from CFML to PHP..interesting. :) LOL! If this continues, pretty soon everyone will be

RE: concurrency problem..

A suggestion is to when the user selects the room/item is to mark the record as being taken, and with a date/time. Thus not available for someone else. Then I would run a clean up file to unmark those checked after say 20 minutes or so. Maybe a scheduled task every hour -Original

Re: Uploading a file

I have had many problems with this... I hear people say that it's a memory issue or whatever, I really have a hard time believing this. I have 2 different servers running this and the first server is a dual pent 500 with a gig of ram and I cant upload anything over 50 megs and I get the same

New Cold Fusion book, O'riely Press

Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie

COM CFLOOP error

Hi all :) Im trying to loop thru a object structure with no luck. Im using an object from Serverobjects called AspPop3, and everything works fine, except when i try to loop thru a variant that is returned from the object. The structure i'm trying to output is explained in the documentation

Can 2 Applications Share a Client Variiable Database?

Hi Folks, Well, the subject is pretty much my question. We're wondering if two different applications can share the same client variable repository database. Perhaps this is odd question, especially seeing as how we run our own ISP and therefore do not have to pay for each datasource. However,

Re: COM CFLOOP error

Hello Per, snip cfloop collection=#Mailer# item=akey cfoutput #MessageInfo# /cfoutput /cfloop /snip when you loop thru a structure or collection the item is your key field so try outputting #akey.messageInfo# -- Best regards, Critter

Re: CFMAIL Errors..whats going on??

It means that your SMTP server is not authorizing you for relaying mail. You need to get the mail server admin to allow relay for your CF server. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The

Re: Watchguard Firewall II stripping CGI variables?

I'm not sure what version of WG are are using, but either way you should be able to go into the policy manager and set up your own rules for port 80. I would recommend though, to continue using the http proxy if thats what your doing and try to adjust the CF code to conform to the standards that

RE: Log files of a web attack.

I used Netscape FastTrack and/or Enterprise for the longest time on Win32. Finally, when it too bloated and I got frustrated at its error-handling, I switched to Apache which come around to great Win32 version... IIS - Never used it, never will. I've encountered serious performance

RE: cffile vars

CFFile.ContentType and CFFile.ContentSubType - are they reliable enough? I allow people to upload gif/jpg to one of my sites, and ONLY jpg/gif but I bet some of them will try to rename a .mp3 file into .gif or something. Can I use this to filter other formats, rather then images? CF

Re: CFX_IMAGE original?

Michael, I've used the one by Jukka -- it's excellent. However, some folks have noted that the docs are a bit hazey. Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday,

Re: cffile vars

Thanks, I figured it out... I'm using CFX_IMAGE on each file and checking IMG_TYPE/IMG_WIDTH neq it's working absoultly great!! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get

Help for using cfftp to access to MVS system

Hi, has anyone use cfftp to access to MVS system? I am able to open the connection and get the currentdirectory, but I am not able to list the directory or send a file to the MVS system. When i try to list the directory, I kept getting 0 file. here is my code cfftp action=OPEN server=MVS

Re: [Close window : JavaScript (OT)]

body onunload=window.open() in popup... body onload=window.close() Joseph Eugene [EMAIL PROTECTED] wrote: Hi all, I would like to know, if you guys had any code to 1.Open a new window when the User tries to close his Browser. 2. Close the new window Just opened

syntax error when inserting date

Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual

RE: CFX_IMAGE original?

I've use Jukka's tag quite a bit and it is good, but I work for a company involved with graphics. Jukka's tag just didn't cut it with us. But don't get me wrong. It is quite sufficient for what we needed. It resizes and composites acceptably. The antialiasing is fair. It could be better.

cfgrid and onvalidate

Does anyone have an better guide to what the three items passed to the onvalidate funtion are ? The first is a reference to the form itself, from reading CFDOCS, but there doesnt seem to be anything about the other two. All I'm trying to do is validate a few inputs in a cfgrid, so need a way to

Re: Problems with forms in MSIE 5 Mac?

You may also want to have a look at this link about Macs and IE5: http://lookclose.com/learnmore/faqs/macieuploads.htm hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659

Re: syntax error when inserting date

Date is most likely a reserved word in your database. Try changing the column name to something more descriptive like Start_Date. HTH Brian - Original Message - From: megan sherman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 9:01 AM Subject: syntax

MS Access JOIN Error

I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]

RE: MS Access JOIN Error

Not sure about Access but in SQL you have to specify the fact that it's an outer join so instead of LEFT JOIN use LEFT OUTER JOIN. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net

RE: cffile vars

Dave, it would appear that CF is aware of the true file type of an uploaded file in spite of any file extension renaming. By way of a quick test I took a JPG and renamed it to .MP3 and uploaded it. file.contenttype and contentsubtype reflected the fact that the file was indeed an image/pjpeg and

Re: Maybe OT: Infinite categories/subcategories

Let me verify what I see in your SQL. All your categories live in the same table, pcategory. You give that table 3 different 'aliases' though? I think is a self join. I do this so I can give a list of every thing and where they fall in the category structure. Also it seems as though you

test

All my mails to CF Talk are vanishing... test resub... if you see this, reply directly :-) Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with

RE: test

Can see it - J -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 15:46 To: CF-Talk Subject: test All my mails to CF Talk are vanishing... test resub... if you see this, reply directly :-) Regards, Thomas Chiverton Intranet Architect and Desktop

OT: Spider 404s

I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify

Re: CFX_IMAGE original?

Great Thanks! Say - is it possible to specify MULTIPLE commands on the same CFX use? i.e ACTION=ROTATE then ACTION=RESIZE then ACTION=COPY for example? also - have you tried using the ACTION=IML to specify IPTC comments? Thanks, -=Michael. - Original Message - From: Russel Madere

RE: Spider 404s

Try: CFHTTP.StatusCode Should contain 404 if the server is contacted and returns a 404. Steve -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 19:05 To: CF-Talk Subject: OT: Spider 404s I'm building a little spider in CF and want to check

Re: OT: Spider 404s

You should be able to check CFHTTP.StatusCode this will be equal to 404 or 500. 200 is a successful request. At 11:04 AM 5/9/2001 +00-07, you wrote: I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems

RE: Spider 404s

I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to

RE: test

Sorted now. Thanks to those who replied. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: Uploading a file

you are missing the accept paramater, cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ ACCEPT=mime_type/file_type This could very well be your problem, I think the mime type for Word docs is application/ms-word -Original

RE: [Object Oriented CFML]

If I remember correctly, Neo will actually be a full set of JSP Custom tags to convert the CFML to appropriate Java syntax (which will be compiled to a servlet class file). It's pretty much the same as using the Jrun custom tags like %jrun:sql%. This will be some really cool technology as you

RE: MS Access JOIN Error

No, Access only allows a LEFT JOIN. Try Creating the query in the Access Query builder and paste to your CMFL template. This is by far the easiest way I found to deal with Access's squirly SQL syntax... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED]

cfloop vs cfoutput

Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official

RE: MS Access JOIN Error

Does this work? FROM [MPA log] LEFT JOIN [52 log] ON [MPA log].[MPA #] = [52 log].[MPA #] Those table names and field names are pretty confusing. Is it an option for you to change the names so that they do not contain spaces, pound signs etc? Nick -Original Message- From:

RE: Array String Concatenation

Just for clarification: what are your intended results? Are you making a list of clickable teams from a database? Could you, instead of using a two dimensional array use an array with a structure in it like this: cfscript Standings[1][TeamName] = Barracudas; Standings[1][TeamID] = 17;

RE: Spider 404s

Funny you should mention this -- we go this hit from Google the other day: http://www.as.columbia.edu/test404response2057687042.html Now since we have no page of that name, I'm guessing that google is dealing with exactly the same problem that you are, and their process goes something like

Re: Spider 404s

Gene, In addition to the comments you've received, you could also take the route of using a try/catch statement with the TYPE= to one of the HTTP exception types (see below): Examples: CFTRY cfhttp statement here... !--- 404 Not Found --- CFCATCH TYPE=COM.Allaire.ColdFusion.HTTPNotFound

RE: concurrency problem..

Well, that's a problem. Let's assume that we can mark a quantity of an item as taken when they place it in their shopping cart. What percentage of shopping carts are abandonned? Plenty. So that inventory is locked up until this cleanup runs - which may be before the user has finished shopping!

RE: MS Access JOIN Error

Rats, that did not do it Thanks all the same. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 7:32 AM To: CF-Talk Subject: RE: MS Access JOIN Error Not sure about Access but in SQL you have to specify the fact that it's an outer join so

RE: Log files of a web attack.

What was the situation under which Apache failed? What version of 1.3? My last application used a large number of clustered servers, so it may be a while before that installation experiences any problems. Load testing proved very successful however... I put Apaches Mod_rewrite to great use. I

Re: cfloop vs cfoutput

ofcourse cfoutput, that's why it doesn't allow alot of tags to be typed into it. it's much more faster then CFLOOP, which lets you specify every cf tag you want (CFMAIL, for example) Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd.

Re: cfloop vs cfoutput

No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling

RE: Log files of a web attack.

What was the situation under which Apache failed? Load testing of a simple CF application on non-clustered servers. The servers became unresponsive at high load, and started generating lots of Winsock errors at the console. What version of 1.3? I don't recall exactly. I believe it was 1.3.9

CFLOOP question

Hi all I'm attempting to overwrite the index value of a CFLOOP from within the loop: CFLOOP FROM=1 TO=288 INDEX=insert_counter STEP=1 !--- skip gaps in case value numbering --- CFSWITCH EXPRESSION=insert_counter CFCASE VALUE= 23 CFSET insert_counter = 26 /CFCASE CFCASE VALUE=194

RE: [Object Oriented CFML]

Yeh I spoke to some guy from Allaire about it a while back and he sounded pretty upbeat about the whole thing. I agree it sounds superb that you can combine pure Java and CF in one page. I guess having the ability to combine both in a page gives you the opportunity to enjoy increased

RE: cfloop vs cfoutput

You can have a CFQUERY tag between CFOUTPUT/CFOUTPUT Tags I have done that many times Example: CFOUTPUT QUERY=MINE CFQUERY NAME=YOURS This that and the other thing /CFQUERY Back to Square One /CFOUTPUT -Original Message- From: Gregory Harris

RE: cfloop vs cfoutput

sure? I just remembered where I read that cfloops are more efficient than cfoutput with queries, in ben forta's coldfusion developers study guide, if that helps clarify anything mark If there is no notable difference then i suppose it doesnt matter! Kola -Original Message- From:

Re: cfloop vs cfoutput

Well thats a bit misleadingthe more processing you do within a loop, the slower its going to be, no matter the looping method. For pure looping, I remember hearing from somewhere that CFLOOP was actually faster, all other things being equal. I remember being somewhat surprised by this.

Re: cfloop vs cfoutput

Hello Kola, This is from the Certified ColdFusion Developer Study Guide: pg 37 Tip #1 crit_quote The function of the query loop is the same as using cfoutput with a query attribute. For performance reasons, use a Query loop rather than a CFOUTPUT query=qAny loop. Before ColdFusion 4.x,

RE: [Object Oriented CFML]

CF5 is, I believe, the last of the CF engines based on the C++ codebase. There are parts of CF5 (like parts of the Administrator) that are java servlet based. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original

PageMaker/Quark document generated from Database?

I've got an Access database full of information to list in in a directory which is to be printed at a print shop. So I need the database to populate my directory pages. I'll probably need to use Quark or PageMaker. Is one or the other better suited for this endeavor? I'm also a ColdFusion

Can I run CFML code that I pull form my database?

OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my

ColdFusion Query Windows NT Error 1450

I'm having a problem with a query that displays the results in a CFGRID. The query works on two different servers with no problems. Now, I'm trying the query on NT 4.0 machine and getting a blank page. A Error number 1450 occurred while attempting to write the reply to the web server. entry

default spool file

I had a problem with cfmail where it kept sending the same email over and over again. I had to stop the CF service. I checked the spool directory and found the following spool file: c:\CFusion\Mail\Spool\2A.CFMAIL=1 That was the name of the email that was beeing sent over and over. What is the

Re: cfloop vs cfoutput

Ok, bad example (I recall in an earlier version that this was impossible though, to embed CFQUERY in CFOUTPUT), but some tags still, such as the before mentioned CFMAIL tag. Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL:

Re: cfloop vs cfoutput

And now to inject a little more uncertainty... Just a couple of months ago an Allaire consultant told me that cfloop was the second slowest tag after cfmail. Always use cfoutput to output queries. I imagine he was speaking relatively though. I can think of some really slow tags. jon -

Re: cfloop vs cfoutput

I think that has made it into Hals Helms worst practices list. Learn to use SQL joins and this is never necessary. jon - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 1:08 PM Subject: RE: cfloop vs cfoutput You can

Re: Can I run CFML code that I pull form my database?

It will work if you change to regular HTML FORM tags FORM... INPUT... etc. - Original Message - From: Robert J. Bailey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 2:27 PM Subject: Can I run CFML code that I pull form my database? OK, here is what I

RE: PageMaker/Quark document generated from Database?

You defiantly want Quark, and to add to the confusion, you might look at Meadows Information's offerings (www.meadowsinfo.com). I reviewed the three and decided on Meadows because they seemed like they would be more responsive to tech questions (and price was less). When I used it, they were

Re: Can I run CFML code that I pull form my database?

Wrap the string from SQL Server in an #Eval()# statement. It'll take a bit of escaping a whatnot, but it should work. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Robert J. Bailey wrote: OK, here is what I am doing. I am executing a stored procedure which grabs some code

RE: Can I run CFML code that I pull form my database?

yes, I understand that, but is there anyway I can use any CFML within this that you can think of at all? Thanks! Robert J. Bailey (646) 526-4536 -Original Message- From: Dave f [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:36 PM To: CF-Talk Subject: Re: Can I run CFML

Pinging an email address

Is there a way to ping an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: Can I run CFML code that I pull form my database?

And PLEASE be aware that this is potentially very dangerous. Do YOU have full control over what goes in and out of the database? Be aware of your risks before you take this action. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:46 PM

RE: syntax error when inserting date

Your problem is most likely due to the format of the date. If the data field in the database is of type 'Date' you would have to use CreateODBCDate(Form.Date) in order to change the text to an ODBC date format. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer,

Re: OT: Spider 404s

On 9 May 2001, at 11:15, Nick McClure wrote: You should be able to check CFHTTP.StatusCode this will be equal to 404 or 500. 200 is a successful request. Yes, that's the way it's supposed to work. Unfortunately, a bunch of people out there have configured their servers to return

Highlighting Text

Hi! How do I go about... Having the Keyword highlighted throughout page. For example the keyword 'sales' would be shadowed in yellow. I've looked into the CF_Findit custom tag, but it's not quite what I need. It would be nice to highlight all the keywords at once. How about looping

OT: How to set up PWS to process CGI scripts?

Hi Everybody, Sorry for the OT post, but I need to find out some info on this topic quick. I need to know if it's possible to set up PWS to process cgi scripts. I'm on a Win 98 SE box. If yes can someone point me to any resources or downloads? I really apreciate any help. Thanks a lot. Robert

RE: Pinging an email address

you can telnet to a mail server (they usually have exposure to the internet). 1) lookup the MX record for a domain 2) telnet to that mail server (usually on port 25) 3) do VRFY (username) or EXPN (username) however, those commands are unavailable sometimes for privacy/security reasons.

RE: Pinging an email address

There is no explicit way to 'ping' an email address the best and only way to do it is send an email to that address. If the host rejects the email the address is invalid. If the email is accepted it's likely valid. Typically the best way to verify an email address is to have the user click on

RE: Pinging an email address

you can not ping an email, but there are some ways to determine if the email exists. Will take some extra work on your end and more then likely you are not going to know right away. Try connecting to the SMTP server that you want to check mail against. When you connect to the SMTP, which is

Re: syntax error when inserting date

Remember that date is a key word in sql and will produce undesired results if a field in a table is named date as in your code snippet. insert into class_schedule (classID, location, date) Try changing the field name to aDate or lastupdated or something. Bryan - Original Message -

RE: Can I run CFML code that I pull form my database?

Yes, I am aware of this, also I am the only one with access to my SQL server. Robert J. Bailey (646) 526-4536 -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 4:04 PM To: CF-Talk Subject: RE: Can I run CFML code that I pull form my

RE: Can I run CFML code that I pull form my database?

Robert, Considering I've seen other replies to this post that were considerably inaccurate, I'll give you a proper solution. The way to solve this problem is to take the data from the database write it to a file and then use cfinclude to include the file back in and thus have the code executed.

RE: syntax error when inserting date

Actually the problem is that you have a field in your database named 'Date' this is a reserved word and cannot be used as a field name in your db. Try changing the field name to something like 'mydate' or some other equivalent and try your code again, you will likely see better results. Chris

Re: Highlighting Text

There's a Custom Tag that I think does just that in Allaire the name is CF_Highlight CF_Highlight takes a list of substrings, and highlights them in a larger text string. For example, it can be used to highlight search terms on the results page from a search engine. It requires CF 3.01 or above

disabling RDS

I have disabled the RDS service on our NT server but get the following error in the executive log: Error,TID=104,05/09/01,00:41:34,Unexpected Windows NT error number 1058 occurred while attempting to start the RDS service. Is it possible to completely disable the RDS service? Thanks, Brook

  1   2   >