RE: Commenting Text in Studio

2000-07-28 Thread David Gassner
It's the 2nd button from the right on the CFML Basic toolbar. Highlight the text you want to comment, then click the button. -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 27, 2000 10:24 PM To: [EMAIL PROTECTED] Subject: Commenting Text in

Pass a value

2000-07-28 Thread Parker, Kevin
Help please. I'm trying to replace a drop down list with a series of buttons but I need a click on the image to pass a value (different one depending on which button is clicked). CF studio lets me insert a value for an image based input but doesn't write the code which make me think its not

Re: Pass a value

2000-07-28 Thread Dick Applebaum
One way: A HREF="javascript:void()" onClick="myButton()"IMG SRC="..."/A now, the JavaScript routine myButton can do anything you wish, such as: set a form field value popup a window submit a form HTH Dick At 4:41 PM +0930 7/28/00, Parker, Kevin wrote: Help please. I'm trying to

Re: Commenting Text in Studio

2000-07-28 Thread Erki Esken
I changed HTML comment shortcut (Shift+Ctrl+M) to CFML comment shortcut. Very handy! Erki - Original Message - From: "Shane" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 28, 2000 7:26 AM Subject: Re: Commenting Text in Studio In Studio, Options |

CF-Talk V1 #105

2000-07-28 Thread justin
Hello I am on holiday until Monday 14th of August. Please phone Electrum on 0131 555 4241 if it cannot wait until then. Cheers _ This message has been checked for all known viruses by Star Internet delivered through the

RE: SQL and apostrophes

2000-07-28 Thread Philip Arnold - ASP
Any SQL Server 7 gurus out there that know how to allow apostrophe's in SQL statements? For example, last_name = 'O'Brien' chokes the query. Not a SQL Server problem, but a SQL problem Use PreserveSingleQuotes() - it doubles the apostrophies for the SQL Philip Arnold ASP Multimedia

RE: Oh man i need help

2000-07-28 Thread Philip Arnold - ASP
I believe "time" is a reserved word and can not be used as a variable name. I could be wrong (and probably am). :) Time by itself is a reserved word, but if you scope it, it becomes a variable name, rather like Form, URL, Session, Client etc. Normally I'd say to avoid them, but I've got

RE: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Philip Arnold - ASP
CFSETTING - White Space The CFSETTING tag and respective CFADMIN setting for this globally appear to be great tools. In some cases they are. However, remember that essentially you're asking CF to do extra work to remove these "offensive items" (tabs, spaces, etc.). If your page is now

RE: SQL and apostrophes

2000-07-28 Thread DeVoil, Nick
Use PreserveSingleQuotes() - it doubles the apostrophies for the SQL I'm getting confused here. I didn't think that was what PreserveSingleQuotes() does. I thought this function was for *keeping* the quotes the way they were and not escaping them. E.g. if you have a dynamically-constructed

Re: Can I use 2 datasources in one app?

2000-07-28 Thread Bill Grover
I'll look into that. One of the ways I've gotten around the problem is to create COM objects and do the processing there and return ADO recordsets to CF. In some cases this works great but for some of the "down and dirty" stuff I need to do I was trying to do it differently. Bill Grover

Re: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Mooner Ent
Thank you all for such an invigorating and insightful conversation stemming from my original post. Believe it or not, the point I wanted most addressed... hasn't been. Let me try to rephrase it. We all seem to agree that a) \WINNT should be on it's own partition b) the swap file should be on

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 So what about Application variables that never change (say a list of countries or something)? Do they need to be locked? They *should* be locked. Realisticly, I've got a million-hit-a-month site that does: Cfquery name="blah"

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Question? Why would automatic locking for Session Application variables be any more of a performance hit that CF searching for APPLICATION.CFM all the way up the directory tree - for each and every page call? Those are completely

Re: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Dave Hannum
We actually run all of our, what we call, Net Apps on a separate hard dirve - that is the cf server is on a separate hard dirve along with Perl, PHP, JRun, etc. The web server, along with the scripts for the web apps (.cfm, .php, .cgi, etc) sit on a separate hard dirve. WinNT sits on it's own

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Matthew Walker
Thank you Zac, that made a whole lot of sense. So henceforth I'll lock everything except data that never changes like Application.DSN, i.e. data that only gets set if Not IsDefined... If it's not defined, no other process can be accessing it. One final thing? Should locks be wrapped around

Re: CFContent MIME Types

2000-07-28 Thread JustinMacCarthy
Hi Dave Try added this before your Cfcontent tag: to display in the browser: cfheader name="Content-Disposition" value="inline; filename="XYZ.txt" to download : cfheader name="Content-Disposition" value="attachment; filename="XYZ.txt" ~JustinMacCarthy - Original Message - From:

RE: CFContent MIME Types

2000-07-28 Thread Matthew Walker
Is there a list of the different MIME types that should be used with CFContent? Right click and edit tag. I'm returning a .txt file, but when it comes up on the user's machine, it comes up with the name of the script (script.cfm) instead of the file name (xyz.txt). I think it has

Re: CFContent MIME Types

2000-07-28 Thread Dave Hannum
OK, I didn't explain. I'm not trying to open the file in a browser You see, the info can be returned in the users choice of three ways, To the browser, to an Excel Spreadsheet or to an ASCII file (for MAC users or others who don't have Excel). Browser rolls the page to the info. Excel does not

Re: CFContent MIME Types

2000-07-28 Thread Dave Hannum
Hi Justin, This throws an error. It does not like the "FILENAME" attribute. It says it's unknown. Any suggestions? cfheader name="Content-Disposition" value="attachment; filename="XYZ.txt" Plus, isn't this a " short? You have a double quote after value=, but no matching end quote. Thanks,

Re: CFContent MIME Types

2000-07-28 Thread Fred T. Sanders
too many quotes. - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 28, 2000 8:21 AM Subject: Re: CFContent MIME Types Hi Justin, This throws an error. It does not like the "FILENAME" attribute. It says it's unknown. Any

RE: CFContent MIME Types

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there a list of the different MIME types that should be used with CFContent? I'm returning a .txt file, but when it comes up on the user's machine, it comes up with the name of the script (script.cfm) instead of the file name (xyz.txt).

RE: CFContent MIME Types

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 a href="template.cfm?whateveryouwant/firstfivereleases.html" Yup... That's how I used to do it until NT SP6 broke that. I dunno whether it works under 451 or under Win2k. Anyone else tried that under either 451 and/or Win2k? (Under NT SP6, you

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Zac, that made a whole lot of sense. You're more than welcome! I just with Allaire would make an official statement to that effect. All of what I said was of course only my best guesses from experience. You might be able to get away

Re: CFContent MIME Types

2000-07-28 Thread Dave Hannum
Works like a charm. However, TYPE="text/plain" in the CFCONTENT tag returns it to the browser. I replaced text/plain with application/unknown and it works fine. Thanks for the help! Dave - Original Message - From: "Zachary Bedell" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

OT: CSS and attribut A:visited

2000-07-28 Thread cftalk
A:visited as an attribut of CSS for hyperlinks doesn't work in Netscape 4.x Ideas how to manage it in Netscape with CSS ? Uwe -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

WAP Question

2000-07-28 Thread Edward Chanter
Can anyone tell me why I'd get an error from a Nokia 7110 when trying to access http://demo.cc.uk.com/wap/welcome.cfm The code of the above file is as follows: CFCONTENT Type="text/vnd.wap.wml" CFHEADER Name="Expires" Value="#Now()#" CFHEADER NAME="pragma" VALUE="no-cache" ?xml version="1.0"?

Re: CFLOCKs.... is this really necessary?

2000-07-28 Thread John Allred
Zachary Bedell wrote: *shudders* Don't get me started on Allaire's documentation. We're considering starting our own internal errata list for our developers Maybe you could publish this for the rest of us, if you do it.

Re: (OT) JS Image for Button vs. FORM Button

2000-07-28 Thread Dave Hannum
OK - I just found the answer at IRT.ORG - if you haven't checked that site out, you're missin' out! Thanks, Dave - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, July 28, 2000 9:07 AM Subject: (OT) JS Image for Button vs. FORM

RE: CSS and attribute A:visited

2000-07-28 Thread Aidan Whitehall
A:visited as an attribut of CSS for hyperlinks doesn't work in Netscape 4.x Yes it does. Check your code. The CSS below will give you visited colours in both Netscape 4.xx and IE and hovers in IE that still show on visited links (the :visited:hover line). A:link { color: #D8A800; }

Passing NULL integers to a custom tag

2000-07-28 Thread Gina Shillitani
Apparently something strange happens to INT fields when you try to pass them to a custom tag as NULL values. The stored proc snippet below was originally just a query in a simple custom tag, and I kept getting the error "cannot convert datatype to int... use convert function" when this particular

RE: CSS and attribut A:visited

2000-07-28 Thread Kaplan, Mindie
This will work in Netscape 4.x browsers BODY VLINK="#FF" (escape the # for CFM pages, of course) -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 9:06 AM To: [EMAIL PROTECTED] Subject: OT: CSS and attribut A:visited A:visited as an attribut

Re: CSS and attribute A:visited

2000-07-28 Thread cftalk
Yes o.k you are right. For some reason I can't get the link A href="mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/a get highlighted via the A:visited attribut. This was the reason I presumed it doesn't work in NS 4.x in general. But the other links are fine. Thank you. Uwe SD Solutions Uwe

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Al Musella, DPM
For things like datasource names, wouldn't it just be easier to define it in application.cfm as a local variable? Why add the overhead of locking / checking if it is defined then setting it, etc... at all? cfset DSN = 'mydata' instead of cflock ... cfif

Re: WAP Question

2000-07-28 Thread Erki Esken
Can anyone tell me why I'd get an error from a Nokia 7110 when trying to access http://demo.cc.uk.com/wap/welcome.cfm /...skip.../ If anyone has a 7110 and wants to give the site a whirl, please feel free, just let me know if it lets you on I have an Ericsson R320s, and it says

RE: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Steve Bernard
I like to put all the applications on one drive and the data on another. hda - OS hdb - APPS (CF, IIS, JRun, etc.) hdc - DATA (.cfm, .asp, .jsp, Access files, etc.) hdd - SWAP CF is going to cache its DLLs and custom tags so there shouldn't be much read activity in /CFusion. The exception to

Desperately need help - sorting a QueryNew()

2000-07-28 Thread Aidan Whitehall
This is an urgent problem... thanks for any help offered. I've got a query that retreives product names and quantities sold. Having spent ages trying to get the query to return the recordset sorted by the amount sold (desc), I've given up (I'm trying to output the top 5 items sold on a website).

Re: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Erki Esken
You can also move the CustomTags folder to the same drive where your other .cfm files are. Just change the CFMLTagSearchPath key in HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\CustomTags \ Erki - Original Message - From: "Steve Bernard" [EMAIL PROTECTED] To: [EMAIL

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 *shudders* Don't get me started on Allaire's documentation. We're considering starting our own internal errata list for our developers Maybe you could publish this for the rest of us, if you do it. If I ever do quantify it, I'll

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Bud
On 7/28/00, Zachary Bedell penned: Your best bet is to copy the session or application variables to local variables and then use those in your code. Vis: cflock scope="Session" type="readonly" timeout="10" Cfset LocalVar = Application.Var /cflock Hi Zac. I'm still trying to grasp all

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Ann Harrell
I just joined the list today. I would be interested in viewing the entire thread if anyone has it. Thanks! Ann Harrell Tech Support Engineer -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 10:18 AM To: '[EMAIL

RE: $1,000 servers (was: High-Powered Scaling)

2000-07-28 Thread Cary Gordon
Dell servers use proprietary RAM. At 01:36 PM 7/27/2000 -0400, you wrote: Where are you buying your Ram at? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

Re: (admin) List 'suggestions'

2000-07-28 Thread Bud
On 7/28/00, Michael Dinowitz penned: There seems to be some discussion on the CF-Community list about the usefulness of the CF-Talk list. Talk about the usefulness? This list is indispensable. JMHO And the suggestions noted. Thanks, -- Bud Schneehagen - Tropical Web Creations

RE: WAP Question

2000-07-28 Thread Kuehn, Matthew
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFF8A6.C5C4E2DC Content-Type: text/plain; charset="iso-8859-1" I'm not accessing it from any type of phone, but when I try to

RE: WAP Question

2000-07-28 Thread Edward Chanter
Thanks, I got the page working now I'm having trouble getting the phone to submit a simple form :-( I think I'm really starting to hate the 7110 If you wanna try the site again, go for it :o) Thanks for your help! -= Ed -Original Message- From: Erki Esken [mailto:[EMAIL

RE: Desperately need help - sorting a QueryNew()

2000-07-28 Thread DeVoil, Nick
There's no reason why you shouldn't be able to get it sorted by the original query. Did you try "ORDER BY AmountSold" or "ORDER BY 2"? What table(s) are Status and ShopUID on? What does Status=2 mean? Nick -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday,

No Subject

2000-07-28 Thread Mike Weaver
This is a multi-part message in MIME format. --=_NextPart_000_0021_01BFF87E.AF7F8180 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is anyone aware of a method to install a real video player within your = pages and not require the client

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread David Gassner
The reason some developers use application variables for this case is the variable protection in custom tags. That is, a local variable set in application.cfm isn't available in a custom tag except with use of the caller scope. A better approach, and one that avoids the need to cflock, is use

RE: Custom Tag for Date and Time

2000-07-28 Thread Olive, Christopher M Mr NMR
why not just insert '#DateFormat(Now())# #TimeFormat(Now())#' ? Chris Olive, DOEHRS Website Administrator -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:22 AM To: [EMAIL PROTECTED] Subject: Custom Tag for Date and Time Any one have a

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 7/28/00, Zachary Bedell penned: Your best bet is to copy the session or application variables to local variables and then use those in your code. Vis: cflock scope="Session" type="readonly" timeout="10" Cfset LocalVar =

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Gary McNeel, Jr.
Sure, go to: http://www.hcfug.com/ -Gary McNeel -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 10:26 AM To: '[EMAIL PROTECTED]' Subject: RE: CFLOCKs is this really necessary? I just joined the list today. I would be interested

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Check out the list archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:26 AM To: '[EMAIL PROTECTED]' Subject: RE: CFLOCKs

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread mherbene
You can catch part of it at http://www.mail-archive.com/cf-talk@houseoffusion.com/msg15264.html -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:26 AM To: '[EMAIL PROTECTED]' Subject: RE: CFLOCKs is this really necessary? I just joined

Need help on the SQL...

2000-07-28 Thread kailash
Hi! We are facing a problem with MSSQL ... we have a Clustered Database ... and the Microsoft documentation sates that we cannot uses Full Text Catalog with clustered Database... Does anybody know of an alternative Your immediate help is appreciated... Thanks Kailash ( [EMAIL

RE: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Steve Bernard
I never meant to imply that SMP would "break" a Linux box, just that current SMP, multi-tasking, and multi-threading in Linux is not as robust as it is in Solaris and NT/2000. There are applications that run on Linux which operate very efficiently and don't require robust SMP support to operate

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Conrad, Christopher
take a look at this article - somebody may have sent this already - but here it is: http://www.sys-con.com/coldfusion/archives/0208/Forta/ I think Ben explains this pretty good here. I think we have locking down pretty good here - but it took us a couple of days to really understand the

RE: Desperately need help - sorting a QueryNew()

2000-07-28 Thread Aidan Whitehall
There's no reason why you shouldn't be able to get it sorted by the original query. Did you try "ORDER BY AmountSold" or "ORDER BY 2"? What table(s) are Status and ShopUID on? What does Status=2 mean? AmountSold is a calculated column, created by: SUM(PurchaseItem.Quantity) AS

RE: WAP Question

2000-07-28 Thread Edward Chanter
nah, the page is WML so your browser won't know what to do with it. You've got to look at it in a WAP compliant client or a phone... :o) -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 4:16 PM To: '[EMAIL PROTECTED]' Subject: RE:

Re: Passing NULL integers to a custom tag

2000-07-28 Thread paul smith
Please explain why? (I opted for a zero.) best, paul At 09:46 AM 7/28/00 -0400, you wrote: So, now I know what the problem is and how to work around it, but I need a better solution than passing a 0 (zero). --

RE: $1,000 servers (was: High-Powered Scaling)

2000-07-28 Thread Cary Gordon
The facts, in my case, are that the 15 percent that I might pay for Dell over SAG (I couldn't find telenet) is worth it to me, because, over the past five years, Dell has really stood by their machines. I have purchased about 50 Dells and speced hundreds. We have had a DOA machine, which was

RAM Costs (was: $1,000 servers (was: High-Powered Scaling))

2000-07-28 Thread Bill Killillay
I know that, my question was to somebody that was saying they where getting 512 for around $200. I don't care who's memory it is, if they are getting that amount for that money, I want some. I can put it in any machine with in reason at that point. That is just the best price that I have heard

Re: CSS and attribut A:visited

2000-07-28 Thread Shane Pitts
A far as I know, it's not supported as of yet. you would have to use an image swap javascript, and not use text. Shane - Original Message - From: "cftalk" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 28, 2000 7:06 AM Subject: OT: CSS and attribut A:visited A:visited

RE: $1,000 servers (was: High-Powered Scaling)

2000-07-28 Thread Steve Bernard
No they don't, or if they do, you can still buy it on the open market. If a sales rep. told you that they are feeding you a line of BS. They try to confuse you with all that, "168-pin, 5ns, CAS 2, ECC, non-buffered" stuff. I have a brand new Dell 6350 and I found RAM for it from several vendors.

Re: CSS and attribut A:visited

2000-07-28 Thread Shane Pitts
Retraction:: CFIF post.reader.name IS "shane" show A:hover give incorrect response, confuse readers. CFSET required.action = Shane get more coffee CFELSE show A:visited /CFIF Sorry.Not reading Shane - Original Message - From: "cftalk" [EMAIL PROTECTED] To: [EMAIL

Mail / Database Integration

2000-07-28 Thread Claremont, Timothy S
I've been wondering if e-mail sent to a specific account could have its text entered automatically into a database? For example, subject gets stripped and loaded in a SUBJECT field; text between the keywords SUMMARY and SUMMARY END gets loaded into a SUMMARY field , etc. Got any thoughts

Re: Custom Tag for Date and Time

2000-07-28 Thread Gene Kraybill
"James Taavon" [EMAIL PROTECTED] wrote: Any one have a custom tag that retrieves both the DateFormat (Now()) and TimeFormat (Now()) as one function that can be inserted into a database? Why format it before putting it into the db? Would it work for you to simply capture the current date and

Re: Custom Tag for Date and Time

2000-07-28 Thread Shane Pitts
in you sql why not just use CreateODBCDateTime(Now()) - Original Message - From: "James Taavon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 28, 2000 9:22 AM Subject: Custom Tag for Date and Time Any one have a custom tag that retrieves both the DateFormat (Now()) and

RE: Desperately need help - sorting a QueryNew()

2000-07-28 Thread DeVoil, Nick
AND PI.PurchaseItemUID = PS.PurchaseItemUID of course ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender

RE: Custom Tag for Date and Time

2000-07-28 Thread Sharon DiOrio
If you're putting it in a database, why not just #now()# which creates an ODBC datetime value. Sharon At 11:44 AM 7/28/2000 -0400, Olive, Christopher M Mr NMR wrote: why not just insert '#DateFormat(Now())# #TimeFormat(Now())#' ? Chris Olive, DOEHRS Website Administrator -Original

Re: Custom Tag for Date and Time

2000-07-28 Thread James Taavon
i thiught i tried that and it did not work, i will try again "Olive, Christopher M Mr NMR" wrote: why not just insert '#DateFormat(Now())# #TimeFormat(Now())#' ? Chris Olive, DOEHRS Website Administrator -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]]

Re: Desperately need help - sorting a QueryNew()

2000-07-28 Thread Don Vawter
Try ORDER BY SUM(PurchaseItem.Quantity) - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "'DeVoil, Nick'" [EMAIL PROTECTED]; "CF-Talk (E-mail)" [EMAIL PROTECTED] Sent: Friday, July 28, 2000 9:54 AM Subject: RE: Desperately need help - sorting a QueryNew() There's no

Re: Custom Tag for Date and Time

2000-07-28 Thread James Taavon
yep, this is what I got when using it, ODBC Error Code = 22008 (Datetime field overflow) [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax of date, time, or timestamp value not valid. "Olive, Christopher M Mr NMR" wrote: why not just insert '#DateFormat(Now())#

RE: Job Titles

2000-07-28 Thread Jennifer
At 08:56 AM 7/28/00 +0930, you wrote: Try Web God I want Web Smitress. I think that's reasonable. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

RE: Digital clock display

2000-07-28 Thread ron
I got it working great - only problem it is that in is running the CPU on the PC running the browser to view the page with the clock on to 100% and pegs it there. I noticed when the animated banners weren't animated any more :-) Anyone else seeing that with that code - or have I missed a

Re: Milking..., High Scalability and $1000 servers

2000-07-28 Thread Jim McAtee
What about registered CFX tags residing in CustomTags? Don't you also have to redefine the paths to the DLL's within the CF Administrator? Jim -Original Message- From: Erki Esken [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, July 28, 2000 9:17 AM Subject: Re:

RE: Desperately need help - sorting a QueryNew()

2000-07-28 Thread mherbene
See http://www.mail-archive.com/cf-talk@houseoffusion.com/msg14920.html for sorting queries -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:55 AM To: 'DeVoil, Nick'; CF-Talk (E-mail) Subject: RE: Desperately need help - sorting a

Re: Need help on the SQL...

2000-07-28 Thread paul smith
ColdFusion uses Verity to do full-text indexing and searching of SQL7 columns. We use it here. The one posting I saw by someone who tested CF-based Verity full-text search and SQL7 full-text search, went back to CF/Verity. He did have high hopes for M$'s next version of full-text

Newbie Question on Tables and CF

2000-07-28 Thread Richard Ramos
This is a multi-part message in MIME format. --=_NextPart_000_004C_01BFF87B.E5E41860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've been searching on info on how to create a multiple column table = from one column of data. What I

Re: SQL and apostrophes

2000-07-28 Thread Peter Theobald
--=_12476792==_.ALT Content-Type: text/plain; charset="us-ascii" I'm having the same problem. At 04:03 PM 7/27/00 -0600, Nick Call wrote: Any SQL Server 7 gurus out there that know how to allow apostrophe's in SQL statements? For example, last_name = 'O'Brien' chokes the

Re: CF user group in Los Angles or southern Calif

2000-07-28 Thread Cfmarksport
In a message dated 07/27/2000 4:03:09 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I am in the process of learning CF and would like to find out about CFUG's in the southern Calif area. I am located in Palmdale calif and looking for something with in a couple of hours drive.

RE: CSS and attribut A:visited

2000-07-28 Thread Kaplan, Mindie
You don't need to use javascript. The HTML tag is: BODY VLINK="color" A good CSS reference is: _Core CSS_ by Keith Schengili-Roberts. It has syntax, browser support notes, and workarounds. -Original Message- From: Shane Pitts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000

Re: Passing NULL integers to a custom tag

2000-07-28 Thread David E. Crawford
This is a multi-part message in MIME format. --=_NextPart_000_02A0_01BFF8B9.C9830B70 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Passing NULL integers to a custom tagHave you tried passing NULL to the = stored procedure? There is no

Re: Mail / Database Integration

2000-07-28 Thread David E. Crawford
This is a multi-part message in MIME format. --=_NextPart_000_02B4_01BFF8B9.F3157090 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Mail / Database IntegrationCheck out the CFPOP tag. DC - Original Message -=20 From:

RE: Passing NULL integers to a custom tag

2000-07-28 Thread Gina Shillitani
Because in some cases, the value might actually be a zero, and I need to differentiate between a zero and a null (unfortunately). -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:55 AM To: [EMAIL PROTECTED] Subject: Re: Passing NULL

RE: Custom Tag for Date and Time

2000-07-28 Thread jamesa {James Alexander}
or #CreateODBCDateTime(now())# -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 10:44 AM To: '[EMAIL PROTECTED]' Subject: RE: Custom Tag for Date and Time why not just insert '#DateFormat(Now())# #TimeFormat(Now())#' ? Chris

RE: $1,000 servers (was: High-Powered Scaling)

2000-07-28 Thread Benjamin S. Rogers
Where I used to work, the decision to use Dell something of a company policy. I prefer to purchase, build and maintain "clone" machines for the following reasons: 1) %50 to %75 cost savings for the same or better system. 2) Dell uses proprietary RAM and charges at least 3x the going rate. 3)

Re: Mail / Database Integration

2000-07-28 Thread Randy Adkins
Yes, you can use the CFPOP and get the mail message and database the subject, from, to, message. Using the query name for the CFPOP tag, then have it POP a particular message. cfpop action="GETALL" name="get_mail" messagenumber="1404" server="my.pop3.com" username="myname" password="mypass" So

WANTED: Challenging + Exciting CF work!

2000-07-28 Thread Michael Fox
Fellow ColdFusioners: I have been developing advanced web applications using ColdFusion 4.0 and 4.5 for a year. I've been working for a number of local firms, but I'm now looking to expand my horizons in search of some challenging and exciting contract work. I am looking to develop primarily

CF integration with Quickbooks

2000-07-28 Thread Craig A. Zingerline
Hello, Does anyone know of any custom tag that will allow Cold Fusion to [fairly] easily interact with Quickbooks? I have searched the forums and nothing of the sort comes up, I see some people asking, but no answers. Any leads would be great. Thanks, Craig Craig A. Zingerline Advanced

RE: Commenting Text in Studio

2000-07-28 Thread Planet CF
CF has a 'Quick Bar' which is usually on the RH of the CF Studio. (Ctrl+H) or from the Menu select View --- Quick Bar In the "Quick Bar", select the "CFML Basic" tab and you will not only see the 'comment' but also 'cfoutput', '##' and many more. You could insert your own by right clicking and

Re: Digital clock display

2000-07-28 Thread Adrian Cooper
- Original Message - From: [EMAIL PROTECTED] Sent: Friday, July 28, 2000 5:56 PM I noticed when the animated banners weren't animated any more :-) Anyone else seeing that with that code - or have I missed a line out somewhere? I have since noticed that this only occurs when

RE: CFLOCKs.... is this really necessary? - hold on a sec

2000-07-28 Thread Mike Amburn
http://www.sys-con.com/coldfusion/archives/0208/Forta/ I think Ben explains this pretty good here. unfortunately, his article completely contradicts some of the statements made earlier in this thread. Ben says: "...CF developers typically create variables in the APPLICATION scope...and

Re: Javascript:Writing you're own validation routine.

2000-07-28 Thread Heather Haindel
In order to use this from HTML, I would use onClick="return validate()" for a button. Then the function submits the form. Not sure if this applies to your case or not. --- Angél_Stewart [EMAIL PROTECTED] wrote: Ok, in order to validate a date of the format 01-Jan-2000, someone wrote a

Passing Results of DorpDown List Box

2000-07-28 Thread Paige Chandler
This is a multi-part message in MIME format. --=_NextPart_000_0009_01BFF8AF.22497D30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All,=20 I'm trying to capture the selected item from a dropdown list box. My = first attempt to do

RE: CFLOCKs.... is this really necessary? - hold on a sec

2000-07-28 Thread Ben Forta
Mike, I've been watching this thread with interest, and I stand behind my comments in the CFDJ column (which were reviewed thoroughly by Allaire programmers). I did say that if you were absolutely sure that variables would never change then you'd not need to lock them. But I also added that

No Subject

2000-07-28 Thread Mike Weaver
This is a multi-part message in MIME format. --=_NextPart_000_001B_01BFF8A5.92939120 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable unsubscribe --=_NextPart_000_001B_01BFF8A5.92939120 Content-Type: text/html;

No Subject

2000-07-28 Thread Mike Weaver
This is a multi-part message in MIME format. --=_NextPart_000_0026_01BFF8A5.9FE76EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 'unsubscribe'=20 --=_NextPart_000_0026_01BFF8A5.9FE76EA0 Content-Type: text/html;

Scalabilty and Reliability which is better

2000-07-28 Thread Robert Everland
I am looking to invest some money in some computers soon and was wondering which is a better configuration. 2 huge computers with maxed out ram, raid 5, 3 network cards, the whole nine yards, or that equivalent price with maybe 5 computers and everything is clustered using cluster cats

Re: SQL and apostrophes

2000-07-28 Thread Jake Hileman
Just put it between double quotes. Most datatypes use doublequotes anyhow.. so it would be last_name="O'Brien" and you should be okay. let me know if i'm retarded or not.. i probably am :-) jake - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL

cfheader question

2000-07-28 Thread aslam bajaria
Hello All, I am trying to understand the functionality of cfheader. Is this used to expire pages? When is it best to use it? Please advise. Appreciate. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

RE: RAM Costs (was: $1,000 servers (was: High-Powered Scaling))

2000-07-28 Thread Scott Weikert
I'm sure most of you have heard of this place, but if not... http://www.thechipmerchant.com -Original Message- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 4:56 PM To: [EMAIL PROTECTED] Subject: RAM Costs (was: $1,000 servers (was: High-Powered

  1   2   >