RE: ... should be a simple query question ...
a good web site for T SQL is available at http://www.inquiry.com/techtips/thesqlpro/ its basically a version of the SQL Server books online with a few more examples Regards Stew Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
Morning Paul, i tried that but i recieved this error thanks Sorry about that. I accidently sent the untested version. This is what the cfif should look like cfset framesource = url.MainPage cfif IsDefined("url.courseid") cfset framesource = framesource"##"url.courseid /cfif I made a mess of the cfset! :o} Too many "'s and not enough . ;o) Regards Stephen Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: An Idea about access and paragraphs
This is the CF_ParagraphFormat tag I wrote cause I hated the way ParagraphFormat() outputs code. Basically you get the user to enter their text in a TEXTAREA, save it as a memo field and then wrap CF_ParagraphFormat around the variable. It finds double carriage return/line feeds, formats them with P tags with whatever style info you supplied and reformats single carriage return/line feeds with BRs. Usage === CF_ParagraphFormat Style="font-size: 11pt; font-weight: bold; "#YourMemoFieldHere#/CF_ParagraphFormat CF_ParagraphFormat === CFPARAM NAME="attributes.Style" DEFAULT="" CFSET variables.Style="" CFIF Len(attributes.Style) CFSET variables.Style = " STYLE=""" attributes.Style /CFIF CFIF ThisTag.ExecutionMode is "end" CFSET ThisTag.GeneratedContent = "P" variables.Style "" Replace(Replace(ThisTag.GeneratedContent, Chr(13) Chr(10) Chr(13) Chr(10), "/PP" variables.Style "", "ALL"), Chr(13) Chr(10), "BR", "ALL") "/P" /CFIF -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 23 October 2000 19:24 To: CF-Talk Subject: RE: An Idea about access and paragraphs So, here's my idea. Access cannot literally store paragraphs however you can always put in P at the start of each paragraph/line and achieve the the paragraphs. The drawback to this is that if it is left up to the regular user, they'll probably mess it up. So, this is the idea. Is there a way to detect a paragraph break, then when you submit the page, the paragraph break is detected, and then replaced with a P tag. Therefor all the user has to do, is put in a normal paragraph. Great idea! Allaire must have had the same one, since they've given us the ParagraphFormat() function, which substitutes CRLF strings into p strings for display purposes. I prefer to do it manually, however, with a Replace function, and replace a CRLF with br instead, since users will sometimes use just one CRLF for things like address formatting, and two for actual paragraphs. Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
OT: SQL INSERTs across multiple related tables
Hi all I've been trying to insert a record which spans multiple tables, i.e. INSERT INTO ( SELECT Users.Surname, Wages.NINumber FROM Users INNER JOIN Wages ON Users.User_ID = Wages.User_ID ) VALUES ('Bloggs', 'NY012398B') and I keep getting Integrity violations; I have tried to do this in numerous different ways (including creating the SELECT query in Access, then trying to insert into that) - all sorts. Anybody got any ideas on how I could accomplish this without having to create 3 queries (first to insert into the Users table, second to pick up the User_ID (autonumber), third to insert details (along with the User_ID foreign key) into the NINumber table)? Any help greatly appreciated. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: large database query timing out
Did you indexed by any key field in the table? -Original Message- From: Joseph Vincent [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 7:15 AM To: CF-Talk Subject: large database query timing out I am running a rather large database query that is supposed to retrieve 42,000 records through ODBC...however, the operation only retrieves about 19,000 before it times out. Is there anywhere that I can change a setting in Administrator that will allow the query to work for a longer period of time? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
Hi Simon, would it not be INSERT INTO Users INNER JOIN Wages ON Users.User_ID = Wages.User_ID (Users.Surname, Wages.NINumber) VALUES ('Bloggs', 'NY012398B') eh? Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFApplication and IE5.5 - not work properly!
I have been using 5.5 since it was a beta, I have never come across any sites that I use application variables where it doesn't work with IE5.5 I've found that it has problems with temporary cookies - it doesn't always carry them forwards However when looking at your code, the first thing I see is this. Application variables are held in the servers memory, so session management might need to be switched on. I'm deliberately holding them on the server as many users will be on the system simultaneously, so I don't want it re-loading the variables all the time. Also another thing to check is that cookies are switched on, I think the combination of these two things is causing the problem. They're definitely on - but (as I've said above) temporary ones seem to dissapear between pages - which seems to defeat the point of them After some playing, I got into the first page, but when going to another page, the temporary cookie had vanished, thus all references within my system vanished... Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
query problem
Is there some way of incorperating the datediff function into a query? I am trying to get only records that have a date difference of 30 days. Here is the query: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", dos, #dos2#) LTE 30 /CFQUERY the variables dos dos2 are created using CreateODBCDate. Thanks in advance, Dominic Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: query problem
Try putting hashes around dos and using = rather than LTE. You also have a bracket missing around your ABS function like so: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", #dos#, #dos2#)) = 30 /CFQUERY If this doesn't work try replacing the "d" in the datediff function with "dd" or "day" -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 13:01 To: CF-Talk Subject: query problem Is there some way of incorperating the datediff function into a query? I am trying to get only records that have a date difference of 30 days. Here is the query: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", dos, #dos2#) LTE 30 /CFQUERY the variables dos dos2 are created using CreateODBCDate. Thanks in advance, Dominic Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: query problem
Andy, it gives me no returns even when there are 2 possible returns it should be returning. I have set up 2 records that should match the query tests. I am no longer getting the syntax error I was. Dominic At 01:08 PM 10/24/00 +0100, you wrote: Try putting hashes around dos and using = rather than LTE. You also have a bracket missing around your ABS function like so: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", #dos#, #dos2#)) = 30 /CFQUERY If this doesn't work try replacing the "d" in the datediff function with "dd" or "day" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: query problem
Are you using SQL server? If so cut and paste the SQL into query Analyser and run it replacing the variabls with their values. First find out exactly what values are being passed to the query. I'm not sure you need to use CreateODBCDatetry doing it just passing in 2 strings containing valid dates and use the SQL CONVERT function to get into dates. Did you try replacing "d" with "dd" or "day"? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 13:22 To: CF-Talk Subject: RE: query problem Andy, it gives me no returns even when there are 2 possible returns it should be returning. I have set up 2 records that should match the query tests. I am no longer getting the syntax error I was. Dominic At 01:08 PM 10/24/00 +0100, you wrote: Try putting hashes around dos and using = rather than LTE. You also have a bracket missing around your ABS function like so: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", #dos#, #dos2#)) = 30 /CFQUERY If this doesn't work try replacing the "d" in the datediff function with "dd" or "day" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
onValidate in CFGrid
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_01C03DB5.9C5FE8C0 Content-Type: text/plain; charset="iso-8859-1" Hello everyone, Has anyone been successful with the onValidate attribute for the CFGrid tag? Allaire's documentation is vague which doesn't help my understanding of how this attribute works. The documentation states "the form object, input object and input object value are passed" I understand the form object and the input object but I'm confused with the input object value. Does this mean just one column or all of the columns? It would be greatly appreciated if someone could state a better explanation on how this works and perhaps some sample code. The point of my validation is to ensure no text is entered in the grid only numbers. I want an error message to appear before the data goes to the cfgridupdate page. I don't want the users to have to re-enter all of their data again since it's a large grid(36 rows, 10 columns). Thanks for the help!! Laura --_=_NextPart_001_01C03DB5.9C5FE8C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75" TITLEonValidate in CFGrid/TITLE /HEAD BODY PFONT SIZE=3D2 FACE=3D"Arial"Hello everyone,/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Has anyone been successful with the = onValidate attribute for the CFGrid tag? Allaire's documentation is = vague which doesn't help my understanding of how this attribute = works.nbsp; The documentation states quot;the form object, input = object and input object value are passedquot;nbsp; I understand = the form object and the input object but I'm confused with the input = object value.nbsp; Does this mean just one column or all of the = columns?nbsp; /FONT/P PFONT SIZE=3D2 FACE=3D"Arial"It would be greatly appreciated if = someone could state a better explanation on how this works and perhaps = some sample code.nbsp; The point of my validation is to ensure no text = is entered in the grid only numbers.nbsp; I want an error message to = appear before the data goes to the cfgridupdate page.nbsp; I don't = want the users to have to re-enter all of their data again since it's a = large grid(36 rows, 10 columns)./FONT/P PFONT SIZE=3D2 FACE=3D"Arial"Thanks for the help!!/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Laura/FONT /P /BODY /HTML --_=_NextPart_001_01C03DB5.9C5FE8C0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: query problem
I am using access 2000. I tried replacing "d" with both "dd" "day" neither worked. I can get records when I go by just one date but not over a given time period. I need to get records that were created in the last 30 days. the variable dos is a date stamp that is in the table. Dominic At 01:26 PM 10/24/00 +0100, you wrote: Are you using SQL server? If so cut and paste the SQL into query Analyser and run it replacing the variabls with their values. First find out exactly what values are being passed to the query. I'm not sure you need to use CreateODBCDatetry doing it just passing in 2 strings containing valid dates and use the SQL CONVERT function to get into dates. Did you try replacing "d" with "dd" or "day"? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 13:22 To: CF-Talk Subject: RE: query problem Andy, it gives me no returns even when there are 2 possible returns it should be returning. I have set up 2 records that should match the query tests. I am no longer getting the syntax error I was. Dominic At 01:08 PM 10/24/00 +0100, you wrote: Try putting hashes around dos and using = rather than LTE. You also have a bracket missing around your ABS function like so: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", #dos#, #dos2#)) = 30 /CFQUERY If this doesn't work try replacing the "d" in the datediff function with "dd" or "day" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: query problem
Create a query directly in Access using the values for the variables (make sure yo know exactly what they are by outputting them to the screen with lines of debug code in your cfm). If you get the result directly in Access (which I doubt) then you know it is something between CF and Access, otherwise it is your SQL. I'd bet that it is because you are using CreateODBCDate. Try it without and use a CONVERT function around a string. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 13:46 To: CF-Talk Subject: RE: query problem I am using access 2000. I tried replacing "d" with both "dd" "day" neither worked. I can get records when I go by just one date but not over a given time period. I need to get records that were created in the last 30 days. the variable dos is a date stamp that is in the table. Dominic At 01:26 PM 10/24/00 +0100, you wrote: Are you using SQL server? If so cut and paste the SQL into query Analyser and run it replacing the variabls with their values. First find out exactly what values are being passed to the query. I'm not sure you need to use CreateODBCDatetry doing it just passing in 2 strings containing valid dates and use the SQL CONVERT function to get into dates. Did you try replacing "d" with "dd" or "day"? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 13:22 To: CF-Talk Subject: RE: query problem Andy, it gives me no returns even when there are 2 possible returns it should be returning. I have set up 2 records that should match the query tests. I am no longer getting the syntax error I was. Dominic At 01:08 PM 10/24/00 +0100, you wrote: Try putting hashes around dos and using = rather than LTE. You also have a bracket missing around your ABS function like so: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", #dos#, #dos2#)) = 30 /CFQUERY If this doesn't work try replacing the "d" in the datediff function with "dd" or "day" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
Hi Anthony Nope - tried the INSERT INTO Users INNER JOIN Wages ON Users.User_ID = Wages.User_ID (Users.Surname, Wages.NINumber) VALUES ('Bloggs', 'NY012398B') before. All I get is: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Surely, there's an easier way?! Thanks. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFHTTP and XML
This isn't quite true. Ensure that the MIME type is correct for sure, but also ensure that the file returned is an XML file NOT just an XML packet ie: ?xml version="1.0"? myxmldoc textHello/text /myxmldoc instead of myxmldoc textHello/text /myxmldoc If there is no identifier, it can get very messy! Have a look at a WDDX packet (ie sump one to the screen) and you'll see what I mean. Paul PS It can also be useful to strip out any whitespace at the top of the XML file. Use cf_lesswhitespace custom tag for this. Very useful. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 23 October 2000 23:33 To: CF-Talk Cc: '[EMAIL PROTECTED]' Subject: RE: CFHTTP and XML Does anybody know why CFHTTP reports that an XML file is not an ASCII file, and how you can actually get the content back? All you get back is the error message, and I thought CF was meant to be good for stuff like that. If the remote server doesn't return a MIME content type that CF recognizes as text, then CF won't let you reference the FileContent variable. Your only recourse in that situation is to save it to the file system, then open it with CFFILE. According to the 4.5.1 SP 1 release notes, this "feature" has been fixed in SP 1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
Not sure if you can do it in Access in one statement. I think I would insert into USERS and a intermediary table and then insert iton Wages based on the content of the intermediary table. If you could use SQL ~Server then it would be easier. You could create an SP which inserts into USERS and then interrogate the system table INSERTED (I assume you are using SQL). This will contain all of the records you have inserted in to USERS which will include the ID so you can then perform an insert into wages. A much better aprocach would be to create an updateable view combining these 2 tables and insert into the view (I think this works but I'm not sure.) If I'm way off the mark sorry!! Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Simon Halcrow [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 13:53 To: CF-Talk Subject: RE: SQL INSERTs across multiple related tables Hi Anthony Nope - tried the INSERT INTO Users INNER JOIN Wages ON Users.User_ID = Wages.User_ID (Users.Surname, Wages.NINumber) VALUES ('Bloggs', 'NY012398B') before. All I get is: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Surely, there's an easier way?! Thanks. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFX tags
You are absolutely correct. The simple explanation is that CFX tags are executables (dll or class files) that utilize the ColdFusion API. Thus, they must be written in a separate language. However, if your colleague can show us the "button", we'd all be eternally grateful. -- Billy Cravens [EMAIL PROTECTED] W Luke wrote: Hi, Could someone resolve an argument I've been having all day with a colleague about CFX tags? I'm hardly an expert on CF, but am pretty sure that to create CFX tags, you don't just press an "Export to CFX DLL" button :) Am I right in thinking you have to write it in a different lanugage? Thanks in advance? Will Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
mail attachments
If I have a form that uses CFMAIL, can I attach files to it? I can't seem to figure this out with the help file. :( Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFHTTP and XML
Does anybody know why CFHTTP reports that an XML file is not an ASCII file, and how you can actually get the content back? All you get back is the error message, and I thought CF was meant to be good for stuff like that. If the remote server doesn't return a MIME content type that CF recognizes as text, then CF won't let you reference the FileContent variable. Your only recourse in that situation is to save it to the file system, then open it with CFFILE. According to the 4.5.1 SP 1 release notes, this "feature" has been fixed in SP 1. This isn't quite true. Ensure that the MIME type is correct for sure, but also ensure that the file returned is an XML file NOT just an XML packet... While I agree that it's a good idea to make sure that your XML data is valid and well-formed, that doesn't have anything to do with not being able to output CFHTTP.FileContent to the page. That's purely a "feature" of the CFHTTP tag prior to SP 1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: fusebox and cfschedule
I wouldn't think that "scheduling" fits into the methodology; Fusebox responds to an event (fuseaction) with little regard to when that event takes place (I'm talking about externally, not the internal logic of a fuse). However, internally within your scheduled event, you can point to a URL using the same structure as any Fusebox page: index.cfm?fuseaction=some_scheduled_event To set up your scheduled event, either do it in the ColdFusion administrator, or set it up programatically. If you do it programatically, then just stick the code to do so as a separate fuseaction. -- Billy Cravens [EMAIL PROTECTED] sebastian palmigiani wrote: Where would one put scheduled events that are to run automatically using the fusebox method? In the index.cfm with cfswitch is not the appropriate place. Sebastian Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Zeus Webserver
Hi All, Does anyone have any experience good or bad with this web server? Kind Regards Stew Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: cflock. . .once again
I know that this topic has been addressed many times, but is the following code the preferred method of CFLOCKING an application variable for a CFQUERY that will only execute once, or should the lock go around the whole thing because of the IsDefined block? CFIF Not IsDefined("application.States") CFQUERY NAME="getStates" DATASOURCE="#dsn#" SELECT States from StateTable /CFQUERY CFLOCK SCOPE="Application" TIMEOUT="30" TYPE="Exclusive" CFSET application.States = ValueList(getStates.States) /CFLOCK /CFIF The IsDefined should be locked, so you'd be better off wrapping the entire block within the CFLOCK. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Cobaly RAQ's and Cold Fusion
I am interested to see whether anyone on the list has tried to put CF 4.5 for Linux on any RAQ server or not. Please see below for what Cobalt says may be possible. Paul -- This comes from the Cobalt website. Quite interesting I think you'll find! Although, there is still no real clue as to whether you can do use CF with a RAQ or not. COBALT RAQ Support: -- These instructions refer to the RaQ3 ONLY! Do not attempt to use these instructions with other products QuestionNum: 660 Product: RaQ3 Category Admin Creation Date: Thu Dec 16 15:11:14 1999 PST Question Is the RaQ 3i binary compatible with Redhat 6.0, and if so does it support Allaire Cold Fusion 4.5 for Linux? Response NOTE: UNSUPPORTED. Cobalt Networks currently does not offer support for third party software or modified systems. Please contact the appropriate software vendor for further assistance. Modifications through root shell access could potentially void your warranty. A fee will be assessed by Cobalt for fixes or rebuilds on systems with unsupported modifications. Yes, the RaQ3i is binary compatible with RedHat 6. Although Cobalt has not tested Cold Fusion with the RaQ3i, we have received reports from customers that it does work. -- -- This document refers to all products QuestionNum: 335 Product: All Category Software Creation Date: Thu Oct 29 00:00:00 1998 PST Question Is Cold Fusion supported on the Cobalt servers? Response Currently there is no support currently for Cold Fusion. We are looking into porting Cold Fusion but have no formal timeframe yet. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: fusebox style: too much disk access?
Did I understand Jeremy Allen correctly that the CF server will compile the entire page to P-Code *with any included files* and cache it. How does it track the myriad of combinations when all of the cfincludes are dynamic (inside CFIFs) and different files are included depending on the input and data? Peter that was more of a theoretical guess than an actual statement but I will reenforce it. My assumptions based on how C compilers work. There is a preprocessing phase for a individual page call. Step one, preprocess any individual CF template include any files into the template do anything else (syntax checking after the inclusion, before the inclusion) there are to many things to talk about so ill just stick to including files. After "pre processing" you now have a template to be interpreted. The next phase since we all know that CF "compiles" templates to PCode is to turn that template into PCode. So one Section of my site may have 10 fuses which is really just 10 seperate Compilations (10 different file configurations) Again most of this is theory if anyone actually knows I would love to hear it, im just taking some guesses here. At this point I can only state guesses since I am not entirely certain. Dave? Allaire people? Based on the background info I was given at the instructor training for the CF Performance Tuning class, CF doesn't work the same way that a C compiler might, but rather each individual .cfm file is cached individually. Using CFINCLUDEs provides the illusion that the entire body of request code is being executed as "one big file", includes and all, but it apparently doesn't really work that way. Unfortunately, this is based on a relatively vague discussion with some of the Allaire guys, so I can't state this with absolute certainty. This is one of the problems, of course, with CF - there are too many low-level mysteries on how things really work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Any Help please... NT Error 2
Can anyone shed some light on this error please. Thanks in advance. |--| | An error occurred while attempting to establish a connection to the service. || | || | || | The most likely cause of this problem is that the service is not currently running. |You can use | | the 'Services' Control Panel to verify that the service is running and to restart it |if | | necessary. || | || | || | Windows NT error number 2 occurred. || |--| Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Any Help please... NT Error 2
go into the control panel, then services, and start each of the 3 coldfusion listings. you may want to double click them and set them to automatic, if they aren't already set that way. ~Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 9:58 AM To: CF-Talk Subject: Any Help please... NT Error 2 Can anyone shed some light on this error please. Thanks in advance. |--- ---| | An error occurred while attempting to establish a connection to the service. | | | | | | The most likely cause of this problem is that the service is not currently running. You can use | | the 'Services' Control Panel to verify that the service is running and to restart it if | | necessary. | | | | | | Windows NT error number 2 occurred. | |--- ---| Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Any Help please... NT Error 2
What service? Is that your ColdFusion Application Server service is not running? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 24 October 2000 14:58 To: CF-Talk Subject: Any Help please... NT Error 2 Can anyone shed some light on this error please. Thanks in advance. |- -| | An error occurred while attempting to establish a connection to the service. | | | | | | The most likely cause of this problem is that the service is not currently running. You can use | | the 'Services' Control Panel to verify that the service is running and to restart it if | | necessary. | | | | | | Windows NT error number 2 occurred. | |- -| Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: nested # problem
#Evaluate("myview.#myvariable#")# -Original Message- From: Laszlo Nadai [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 8:19 PM To: CF-Talk Subject: nested # problem I have a query: cfquery datasource="mydata" name="myview" SELECT * FROM mytable /cfquery Now I would like to cfoutput let's say myview.city, or my myview.state, or myview.zip depending on the value of a variable. I was trying nesting #'s something like: #myview.#myvariable## and similar things, none of which worked :-( TIA, laszlo Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
Simon, You must use multiple INSERT statements to insert multiple rows. The exception to this is INSERT SELECT, which can be used to insert what is returned by the SELECT statement. Shane Witbeck -Original Message- From: Simon Halcrow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 5:58 AM To: CF-Talk Subject: OT: SQL INSERTs across multiple related tables Hi all I've been trying to insert a record which spans multiple tables, i.e. INSERT INTO ( SELECT Users.Surname, Wages.NINumber FROM Users INNER JOIN Wages ON Users.User_ID = Wages.User_ID ) VALUES ('Bloggs', 'NY012398B') and I keep getting Integrity violations; I have tried to do this in numerous different ways (including creating the SELECT query in Access, then trying to insert into that) - all sorts. Anybody got any ideas on how I could accomplish this without having to create 3 queries (first to insert into the Users table, second to pick up the User_ID (autonumber), third to insert details (along with the User_ID foreign key) into the NINumber table)? Any help greatly appreciated. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Any Help please... NT Error 2
Vance in the Control Panel under services make sure that: Cold Fusion Application Server Cold Fusion Executive Cold Fusion RDS are all started. Regards, Greg Jordan FreightMatrix.com Email: [EMAIL PROTECTED] Vance_Duke@i2 .com To: CF-Talk [EMAIL PROTECTED] cc: 10/24/00 Subject: Any Help please... NT Error 2 08:58 AM Please respond to cf-talk Can anyone shed some light on this error please. Thanks in advance. |--| | An error occurred while attempting to establish a connection to the service. | | | | | | The most likely cause of this problem is that the service is not currently running. You can use | | the 'Services' Control Panel to verify that the service is running and to restart it if | | necessary. | | | | | | Windows NT error number 2 occurred. | |--| Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
WAY WAY OT: Windows NT
List, I know that this is a stretch but I need to get this figured out and thought that somebody might be able to point me to a web page or something that might help me here. Problem: I have a box that was on Win2k, I found it to be slow and cause broadcast storms on my network, I 'upgraded' to NT4 on Sunday and lost my partitions (2GB Sys, 7 GB File Share, 1 GB Other) now I know I was supposed to loose them, but on Sunday I somehow got them back! So last night I realized that the 'upgrade' had given me a box that was not on the network or in any domain, I figured that the easiest way to fix this was a reinstall, so I did. Now I have my System Drive (2 GB) and then icons for D: and E:, but they are not shared, unassigned in Disk Administrator, and I get an explorer error when trying to access the partitions. I have an ERD, but going through the Setup and Repair option did not work and Disk Admin tells me that there is no disk data on my ERD. HELP PLEASE, I have 6 GB of data on one of those shares (and I know that I should have Backed up, but...), I know that there is a way to get them back as I did it Sunday but am unsure as to what I did. Whoever gets this one can come to GA and have a beer (or 12) on me some day! TIA, Kevin P.S. if you wish to flame me for the OT post please feel free. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: WAY WAY OT: Windows NT
all I can say is that I'd pick up a copy of Partition Magic if I were you. Why did you lose those partitionsFAT32? ~Simon -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:18 AM To: CF-Talk Subject: WAY WAY OT: Windows NT List, I know that this is a stretch but I need to get this figured out and thought that somebody might be able to point me to a web page or something that might help me here. Problem: I have a box that was on Win2k, I found it to be slow and cause broadcast storms on my network, I 'upgraded' to NT4 on Sunday and lost my partitions (2GB Sys, 7 GB File Share, 1 GB Other) now I know I was supposed to loose them, but on Sunday I somehow got them back! So last night I realized that the 'upgrade' had given me a box that was not on the network or in any domain, I figured that the easiest way to fix this was a reinstall, so I did. Now I have my System Drive (2 GB) and then icons for D: and E:, but they are not shared, unassigned in Disk Administrator, and I get an explorer error when trying to access the partitions. I have an ERD, but going through the Setup and Repair option did not work and Disk Admin tells me that there is no disk data on my ERD. HELP PLEASE, I have 6 GB of data on one of those shares (and I know that I should have Backed up, but...), I know that there is a way to get them back as I did it Sunday but am unsure as to what I did. Whoever gets this one can come to GA and have a beer (or 12) on me some day! TIA, Kevin P.S. if you wish to flame me for the OT post please feel free. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
Thanks Shane, I have resorted to using 3 separate queries (cannot get any of the other types of INSERTs to work - anything with a JOIN in it gets spat back at me)... Should be using SQL Server I suppose! Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message- From: Shane Witbeck [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:59 PM To: CF-Talk Subject: RE: SQL INSERTs across multiple related tables Simon, You must use multiple INSERT statements to insert multiple rows. The exception to this is INSERT SELECT, which can be used to insert what is returned by the SELECT statement. Shane Witbeck --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: WAY WAY OT: Windows NT
To my knowledge, PM 5 does not work on NT4 Server. Correct me if I'm wrong. What is the explorer error? Shane Witbeck -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:27 AM To: CF-Talk Subject: RE: WAY WAY OT: Windows NT all I can say is that I'd pick up a copy of Partition Magic if I were you. Why did you lose those partitionsFAT32? ~Simon -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:18 AM To: CF-Talk Subject: WAY WAY OT: Windows NT List, I know that this is a stretch but I need to get this figured out and thought that somebody might be able to point me to a web page or something that might help me here. Problem: I have a box that was on Win2k, I found it to be slow and cause broadcast storms on my network, I 'upgraded' to NT4 on Sunday and lost my partitions (2GB Sys, 7 GB File Share, 1 GB Other) now I know I was supposed to loose them, but on Sunday I somehow got them back! So last night I realized that the 'upgrade' had given me a box that was not on the network or in any domain, I figured that the easiest way to fix this was a reinstall, so I did. Now I have my System Drive (2 GB) and then icons for D: and E:, but they are not shared, unassigned in Disk Administrator, and I get an explorer error when trying to access the partitions. I have an ERD, but going through the Setup and Repair option did not work and Disk Admin tells me that there is no disk data on my ERD. HELP PLEASE, I have 6 GB of data on one of those shares (and I know that I should have Backed up, but...), I know that there is a way to get them back as I did it Sunday but am unsure as to what I did. Whoever gets this one can come to GA and have a beer (or 12) on me some day! TIA, Kevin P.S. if you wish to flame me for the OT post please feel free. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: WAY WAY OT: Windows NT
PM will run on any machine, but you need to boot to the CD if your NT Box is NTFS. Once the OS has booted to an NTFS partition, partition magic will not run, that is correct ~Simon -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:30 AM To: CF-Talk Subject: RE: WAY WAY OT: Windows NT To my knowledge, PM 5 does not work on NT4 Server. Correct me if I'm wrong. What is the explorer error? Shane Witbeck -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:27 AM To: CF-Talk Subject: RE: WAY WAY OT: Windows NT all I can say is that I'd pick up a copy of Partition Magic if I were you. Why did you lose those partitionsFAT32? ~Simon -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:18 AM To: CF-Talk Subject: WAY WAY OT: Windows NT List, I know that this is a stretch but I need to get this figured out and thought that somebody might be able to point me to a web page or something that might help me here. Problem: I have a box that was on Win2k, I found it to be slow and cause broadcast storms on my network, I 'upgraded' to NT4 on Sunday and lost my partitions (2GB Sys, 7 GB File Share, 1 GB Other) now I know I was supposed to loose them, but on Sunday I somehow got them back! So last night I realized that the 'upgrade' had given me a box that was not on the network or in any domain, I figured that the easiest way to fix this was a reinstall, so I did. Now I have my System Drive (2 GB) and then icons for D: and E:, but they are not shared, unassigned in Disk Administrator, and I get an explorer error when trying to access the partitions. I have an ERD, but going through the Setup and Repair option did not work and Disk Admin tells me that there is no disk data on my ERD. HELP PLEASE, I have 6 GB of data on one of those shares (and I know that I should have Backed up, but...), I know that there is a way to get them back as I did it Sunday but am unsure as to what I did. Whoever gets this one can come to GA and have a beer (or 12) on me some day! TIA, Kevin P.S. if you wish to flame me for the OT post please feel free. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: WAY WAY OT: Windows NT
To my knowledge, PM 5 does not work on NT4 Server. Correct me if I'm wrong. I've used PartitionMagic 4 with NT; there's a patch for dealing with NTFS 5 partitions though, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Mysterious Request Scope
I have seen a few references to the REQUEST scope by many on this list. Is this a standard scope that is available to all CF pages? What is stored in this structure? Is there any information on it in the CF documentation? When does it get built? Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Problem with email form validation
Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL Server equivalent of Access memo
(Sorry if this got asked before... can you guess I'm playing with SQL Server for the first time ;-) What's the SQL Server equivalent of a memo field? (if there is anything that can be described as equivalent) If memo is 16k, then a field that can hold that amount would be perfict. Thanks. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access memo
memo == text Scott Cavanaugh Lead Software Developer Online Operations Salem Communications Corporation -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 8:03 AM To: CF-Talk Subject: SQL Server equivalent of Access memo (Sorry if this got asked before... can you guess I'm playing with SQL Server for the first time ;-) What's the SQL Server equivalent of a memo field? (if there is anything that can be described as equivalent) If memo is 16k, then a field that can hold that amount would be perfict. Thanks. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access memo
From the book; text Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes. Stew Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access memo
text ~Simon -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:03 AM To: CF-Talk Subject: SQL Server equivalent of Access memo (Sorry if this got asked before... can you guess I'm playing with SQL Server for the first time ;-) What's the SQL Server equivalent of a memo field? (if there is anything that can be described as equivalent) If memo is 16k, then a field that can hold that amount would be perfict. Thanks. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Problem with email form validation
you need to add a "return false;" in there. like this function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); return false; } return true; } otherwise, the script will always return true, and always think the email is correct. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mysterious Request Scope
I have seen a few references to the REQUEST scope by many on this list. Is this a standard scope that is available to all CF pages? What is stored in this structure? Is there any information on it in the CF documentation? When does it get built? The Request scope is available to all scripts that are used within a single response to a single HTTP request, whether those scripts are called directly via the URL, or with CFINCLUDE or as custom tags. This scope was introduced in CF 4.x. By default, nothing is stored in this scope unless you put it there. As for whether it's described in the documentation, I suspect that it's mentioned at least. There are at least a couple good uses for this scope. One is with deeply nested custom tags. The Request scope will be available to all custom tags within a page, no matter how deeply nested they are. Another good use for the Request scope is for constants. Typically, people use Application variables for things like datasource names and other constants which don't change over the life of the application. Request variables provide an alternative - and you don't have to worry about CFLOCK with them. On the other hand, you'd need to create them again for each page request, so you'd just plonk them down in application.cfm, typically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access memo
Datatype text can hold a couple of GB's...the next step down is varchar(n)... No doubt someone will correct me (I'm a newbie to SQL Server too...) Si. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message- From: Aidan Whitehall [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 4:03 PM To: CF-Talk Subject: SQL Server equivalent of Access memo (Sorry if this got asked before... can you guess I'm playing with SQL Server for the first time ;-) What's the SQL Server equivalent of a memo field? (if there is anything that can be described as equivalent) If memo is 16k, then a field that can hold that amount would be perfict. Thanks. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mysterious Request Scope
This is from the ColdFusion Quick Reference Guide "Request variables store data that pertains to the processing of a single page request. Request variables allow you to store data in a structure that can be passed to nested tags, such as Custom Tags, and processed once. Set a Request variable to provide information to nested tags. The Request variable is set as follows: CFSET Request.field_name1 = "value" CFSET Request.field_name2 = "value" CFSET Request.field_name3 = "value" Each nested tag can access the variable with the CFOUTPUT tag: CFOUTPUT#Request.field_name1#/CFOUTPUT" -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 1:55 AM To: CF-Talk Subject: Mysterious Request Scope I have seen a few references to the REQUEST scope by many on this list. Is this a standard scope that is available to all CF pages? What is stored in this structure? Is there any information on it in the CF documentation? When does it get built? Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Array Sort [help][please]
Hello All... I am trying to sort a multi-dimentional array. And am getting an error I've never seen before. The Setup I am querying two tables to populate a select box,Because I need to know which table the selection came from, and there will be duplicate IDs on two tables, I want to add a table identifier...So I thought I would make an array...(if you know a better way please share). I have reversed the order in which the array populates - because as far as I can tell - the ArraySort() will only do the first 'field', and I need to sort the text 'field' in alphabetical...not the IDs...(if you know a better way please share). Oh yea - one more piece of info - the text is stored in unicode on the db. === The Code cfset sql_getContent = ArrayNew(2) cfloop query="GetSubject" cfset sql_getContent[currentrow][3] = 1 cfset sql_getContent[currentrow][2] = GetSubject.Subject_ID cfset sql_getContent[currentrow][1] = GetSubject.Subject_Name /cfloop cfloop query="GetSSubject" cfset SSnum = GetSubject.recordCount+GetSSubject.CurrentRow cfset sql_getContent[SSnum][3] = 3 cfset sql_getContent[SSnum][2] = GetSSubject.SSubject_CD cfset sql_getContent[SSnum][1] = GetSSubject.SSubject_Name /cfloop cfset ArraySort(sql_getContent, "textnocase") = The Error The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you may be trying to use a query variable in a CFIF tag. This was possible under Cold Fusion 2.0 but is an error under later versions. === Thanks! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access memo
The SQL Server equivalent is the Text datatype (or nText for unicode). Bob -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:03 AM To: CF-Talk Subject: SQL Server equivalent of Access memo (Sorry if this got asked before... can you guess I'm playing with SQL Server for the first time ;-) What's the SQL Server equivalent of a memo field? (if there is anything that can be described as equivalent) If memo is 16k, then a field that can hold that amount would be perfict. Thanks. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Problem with email form validation
Firstly, you should have your CheckEmail function return false if the validation fails - it looks like you haven't specified that within the function. Then, in your form tag, call the function by doing: onSubmit="return CheckEmail();" Bob -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access memo
But given that an SQL varchar field can hold considerably more than an Access text field you might get away with using varchar instead. You also have the bonus of being able to index varchar fields, something which you can't do to text fields. Steve -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 15:55 To: CF-Talk Subject: RE: SQL Server equivalent of Access memo From the book; text Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes. Stew -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mysterious Request Scope
... This scope was introduced in CF 4.x. By default, nothing is stored in this scope unless you put it there. CF 4.01. Wasn't there in 4.0 As for whether it's described in the documentation, I suspect that it's mentioned at least. A possible reason for its obscurity is that it would have missed the 4.0 docs which may not have been updated sufficiently for the 4.01 release. In addition, most ppl would have d/led the 4.01 electronic update w/o docs. FWIW Steve Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Array Sort [help][please]
I am trying to sort a multi-dimensional array. And am getting an error I've never seen before. You can't directly sort a multi-dimensional array. All of the array functions provided by CF will only work on one array dimension. If you think about what a multi-dimensional array really is, you'll understand why you can't sort it. A multi-dimensional array in CF is an array, in which each member is itself an array. So, if you have a two-dimensional array, you can use ArraySort only with the inner dimension (which has sortable values) - you can't use it with the outer dimension, which simply contains other arrays. As a further thought experiment, if you use a recordset as an analogy to a two-dimensional array, it would be hard to figure out what it would mean to be able to sort that recordset both by row and column values. I am querying two tables to populate a select box, Because I need to know which table the selection came from, and there will be duplicate IDs on two tables, I want to add a table identifier...So I thought I would make an array...(if you know a better way please share). You could probably just take care of it in your SQL. Here's an example, which might do what you're looking for: cfquery name="getstuff" datasource="myds" SELECT tableandid = "table1:" + id, name FROM table1 UNION SELECT tableandid = "table2:" + id, name FROM table2 ORDER BY name /cfquery select name="mystuff" cfoutput query="getstuff" option value="#tableandid#"#name#/option /cfoutput /select Of course, you'd have to parse the value of Form.mystuff to get the table and ID in your action page. I'm not sure if this is exactly what you're trying to accomplish, but I hope it helps. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
URGENT HELP NEEDED: using cf to connect to an olap cube
Has anyone ever used cf to connect to an olap cube using mdx? I found this sample on the allaire message boards and it connects to our cube but will not return any data. Any suggestions would be greatly appreciated. This queries the sample cube that comes with OLAP services. Eddie !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleCube Test/title /head body cfset adOpenStatic = 3 cfset adLockReadOnly = 1 cfset adCmdText = 1 !--- Grab the component--- cfobject type="COM" name="cst" class="ADOMD.Cellset" action="CREATE" !---This is where I now write the mdx expression--- cfset sMDX="SELECT TopCount({[Product].[Product Name].Members}, 1, Measures.[Unit Sales]) ON COLUMNS FROM [Sales]" !---cfset sMDX="SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [The Cube]" --- cfset cst = cst.open(sMDX, "Provider=MSOLAP;Datasource=NHCNTMSSQL2000;Catalog=FoodMart;") !---I have just added this to make sure that the variable is not empty. If it is the page will stop--- cfif "CST" IS " " The variable is empty. cfabort showerror="The Template was aborted because the variable is an empty string" /cfif !---The values should be listed here--- cfform name="mdx" font face="arial" size=4 Results:brbrbr /font font face="arial" size="3" cfoutput #cst#br /cfoutput/font font face="arial" size=4 Your mdx query is:br/fontbr font face="arial" size="3" cfoutput #smdx# /cfoutput/font /cfform /body /html Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Problem with email form validation
Added form.submit = false at the end when it fails validation -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Any Help please... NT Error 2
The services are started. All are running. Sorry I was not more clear before. Once I get that error message on screen, if I refresh the page it comes up fine. I have not touched the server at all. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 Greg_Jordan@i 2.comTo: CF-Talk [EMAIL PROTECTED] cc: 10/24/00 Subject: Re: Any Help please... NT Error 2 09:11 AM Please respond to cf-talk Vance in the Control Panel under services make sure that: Cold Fusion Application Server Cold Fusion Executive Cold Fusion RDS are all started. Regards, Greg Jordan FreightMatrix.com Email: [EMAIL PROTECTED] Vance_Duke@i2 .com To: CF-Talk [EMAIL PROTECTED] cc: 10/24/00 Subject: Any Help please... NT Error 2 08:58 AM Please respond to cf-talk Can anyone shed some light on this error please. Thanks in advance. |--| | An error occurred while attempting to establish a connection to the service. | | | | | | The most likely cause of this problem is that the service is not currently running. You can use | | the 'Services' Control Panel to verify that the service is running and to restart it if | | necessary. | | | | | | Windows NT error number 2 occurred. | |--| Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
What about using a view? Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFApplication and IE5.5 - not work properly!
Application variables are held in the servers memory, so session management might need to be switched on. Session management isn't required for the use of Application variables. All you need is a CFAPPLICATION tag with a NAME attribute, and for Application variables to be enabled within the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
AOL and Cold Fusion Sessions
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_01C03DD1.64900C00 Content-Type: text/plain; charset="iso-8859-1" Hey guys, I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. Thanks, Scott --_=_NextPart_001_01C03DD1.64900C00 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLEAOL and Cold Fusion Sessions/TITLE /HEAD BODY PFONT SIZE=2Hey guys,/FONT /P PFONT SIZE=2I'm having a mind boggeling problem. This problem only happens/FONT BRFONT SIZE=2from within the AOL browser environment. I have a site that requires/FONT BRFONT SIZE=2you to be logged in. Once you log in, you can go to other pages on/FONT BRFONT SIZE=2the site. If these pages detect you aren't logged in, the bounce you/FONT BRFONT SIZE=2back to the login page. In AOL, on certain pages, even though you/FONT BRFONT SIZE=2are logged in, it will bounce you back to the login screen. This/FONT BRFONT SIZE=2doesn't happen on my regular browser, just within AOL./FONT /P PFONT SIZE=2Is anybody familiar with any kind of special issues to deal with here?/FONT BRFONT SIZE=2I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are /FONT BRFONT SIZE=2stored in a cookie./FONT /P PFONT SIZE=2Thanks,/FONT /P PFONT SIZE=2Scott/FONT /P /BODY /HTML --_=_NextPart_001_01C03DD1.64900C00-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
What If You Don't Know The File Type?
I have a site where users can upload files to the server. There is a vast array of file types they can upload (PDF, all kinds of images, zipped files, .sit files, etc.). For the administrator, I have a page that displays all of the files in the upload directory. The admin can then click on a link to download the file. I want to use CFContent for this procedure, but CFContent requires that you specify the file type. But We don't know what the file type might be. How do I get around this requirement on CFContent? What are the options. H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL and Cold Fusion Sessions
Probably because the AOL browser has session level cookies swiched off. What you should do to overcome this is create a variable in your application.cfm that is the CFID andd CFTOken appended together if cookies are switched off. Then append this variable to every hyperlink/form posting/cflocation in your site. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 16:45 To: CF-Talk Subject: AOL and Cold Fusion Sessions 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_01C03DD1.64900C00 Content-Type: text/plain; charset="iso-8859-1" Hey guys, I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. Thanks, Scott --_=_NextPart_001_01C03DD1.64900C00 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLEAOL and Cold Fusion Sessions/TITLE /HEAD BODY PFONT SIZE=2Hey guys,/FONT /P PFONT SIZE=2I'm having a mind boggeling problem. This problem only happens/FONT BRFONT SIZE=2from within the AOL browser environment. I have a site that requires/FONT BRFONT SIZE=2you to be logged in. Once you log in, you can go to other pages on/FONT BRFONT SIZE=2the site. If these pages detect you aren't logged in, the bounce you/FONT BRFONT SIZE=2back to the login page. In AOL, on certain pages, even though you/FONT BRFONT SIZE=2are logged in, it will bounce you back to the login screen. This/FONT BRFONT SIZE=2doesn't happen on my regular browser, just within AOL./FONT /P PFONT SIZE=2Is anybody familiar with any kind of special issues to deal with here?/FONT BRFONT SIZE=2I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are /FONT BRFONT SIZE=2stored in a cookie./FONT /P PFONT SIZE=2Thanks,/FONT /P PFONT SIZE=2Scott/FONT /P /BODY /HTML --_=_NextPart_001_01C03DD1.64900C00-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFX tags
You are absolutely correct. The simple explanation is that CFX tags are executables (dll or class files) that utilize the ColdFusion API. Thus, they must be written in a separate language. However, if your colleague can show us the "button", we'd all be eternally grateful. To addd to that: The "X" in CFX, as I recall, is for eXtension. A CFX extends the capabilities of CF beyond what it ships with via other more low-level languages. For the most part exporting plain cfml into a cfx wouldn't be a good idea anyway. It might run faster to be sure, but it most likely be harder to maintain and be less cross-portable. --min Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Problem with email form validation
Use CFFORM ACTION="blah.cfm" METHOD="POST" ONSUBMIT="return CheckEmail();" -Original Message- From: Randy Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 9:33 AM To: CF-Talk Subject: RE: Problem with email form validation Added form.submit = false at the end when it fails validation -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL INSERTs across multiple related tables
Can't - I'm using the *dreaded* Access! It's only a small system for a small client and probably won't be getting that many hits. I tried creating a SELECT query in Access with the JOINing in it, then do an INSERT INTO qry_mywages, but alas - nowt! Thanks for your help though...I'm still looking for an easier Access solution... Regards. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message- From: Anthony Geoghegan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 4:38 PM To: CF-Talk Subject: RE: SQL INSERTs across multiple related tables What about using a view? Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: What If You Don't Know The File Type?
Is it possible to ZIP all files received. This way it will cut down on the bandwidth required to download the files as well. Just an option -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:42 AM To: CF-Talk Subject: What If You Don't Know The File Type? I have a site where users can upload files to the server. There is a vast array of file types they can upload (PDF, all kinds of images, zipped files, .sit files, etc.). For the administrator, I have a page that displays all of the files in the upload directory. The admin can then click on a link to download the file. I want to use CFContent for this procedure, but CFContent requires that you specify the file type. But We don't know what the file type might be. How do I get around this requirement on CFContent? What are the options. H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: What If You Don't Know The File Type?
Once a file has been uploaded using CFFILE you have access to a bunch of FILE variables. Two of these variables will help you out here: FILE.ContentType FILE.ContentSubType For example, if a GIF file is uploaded, whether it has a .gif extension or not then the above variables will contain the values: image, gif respectively. You can store these values in your db against the file reference and combine them (image/gif) for use in CFCONTENT when delivering the files. HTH Steve -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 16:42 To: CF-Talk Subject: What If You Don't Know The File Type? I have a site where users can upload files to the server. There is a vast array of file types they can upload (PDF, all kinds of images, zipped files, .sit files, etc.). For the administrator, I have a page that displays all of the files in the upload directory. The admin can then click on a link to download the file. I want to use CFContent for this procedure, but CFContent requires that you specify the file type. But We don't know what the file type might be. How do I get around this requirement on CFContent? What are the options. H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Finding a query in a file
Hi everyone, i have written a regex that should (i think) return an instance of any cfquery name=blah datasource=foo in a page. I read a page into meory first, and call it page_buffer. The regex looks like this: ReFindNoCase("cfquery +name=[a-z]+[0-9]* +datasource=[a-z]+", #page_buffer#) For some reason, however, this does not turn up any mathces. Could any of you regex wiards out there tell me why? Chris Martin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL and Cold Fusion Sessions
I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. You're not using the user's IP number in the session control scheme somehow, are you? AOL dial-up users are behind a shifting-IP proxy... their IP number changes in the middle of a session with some regularity. -ron Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: NASDAQ.com... ERRRRR! - Fixed it -
Gavin, There is a better and more PC way of doing this (That's Program ally Correct :) While your method works it also will suppress other errors related to your accessing this structure. Here is what I recommend. cfif isArray(sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"]) !--- You could also loop over the array here to get all the values --- cfoutput#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"][ 1].value#/cfoutput cfelse cfoutput#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"]. value#/cfoutput /cfif Sorry for reviving the dead thread but I don't troll this list much. Also lemme plug our new release of SOXML, which is a complete XML interface for ColdFusion, free and open-source. blah, blah just go here: http://www.siteobjects.com/index.cfm?fuseAction=showproducts Happy Coding, -Brett Suwyn -Original Message- From: Gavin Myers Sent: Tuesday, October 17, 2000 9:29 AM To: '[EMAIL PROTECTED]' Subject: NASDAQ.com... ER! Nevermind, Had my stuff inside the cfcatch... shoulda been like this: cftry#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"][1]. value# cfcatch/cfcatch /cftry cftry#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"].val ue# cfcatch/cfcatch /cftry Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mysterious Request Scope
There has been some use of the request scope for global variables in the Fusebox methodology. You can read more about how it's being used from this Powerpoint presentation which was given by Gabe Roffman at the first Fusebox conference last month: http://www.fusebox.org/content/index.cfm?fuseaction=presentations Hope this helps. Shane Witbeck -Original Message- From: Jones, Matt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:11 AM To: CF-Talk Subject: RE: Mysterious Request Scope This is from the ColdFusion Quick Reference Guide "Request variables store data that pertains to the processing of a single page request. Request variables allow you to store data in a structure that can be passed to nested tags, such as Custom Tags, and processed once. Set a Request variable to provide information to nested tags. The Request variable is set as follows: CFSET Request.field_name1 = "value" CFSET Request.field_name2 = "value" CFSET Request.field_name3 = "value" Each nested tag can access the variable with the CFOUTPUT tag: CFOUTPUT#Request.field_name1#/CFOUTPUT" -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 1:55 AM To: CF-Talk Subject: Mysterious Request Scope I have seen a few references to the REQUEST scope by many on this list. Is this a standard scope that is available to all CF pages? What is stored in this structure? Is there any information on it in the CF documentation? When does it get built? Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL and Cold Fusion Sessions
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_01C03DDA.BCE553E0 Content-Type: text/plain; charset="iso-8859-1" Nope, not using the IP number. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 12:39 PM To: CF-Talk Subject: RE: AOL and Cold Fusion Sessions I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. You're not using the user's IP number in the session control scheme somehow, are you? AOL dial-up users are behind a shifting-IP proxy... their IP number changes in the middle of a session with some regularity. -ron Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --_=_NextPart_001_01C03DDA.BCE553E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: AOL and Cold Fusion Sessions/TITLE /HEAD BODY PFONT SIZE=3D2Nope, not using the IP number./FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: [EMAIL PROTECTED] [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Tuesday, October 24, 2000 12:39 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: RE: AOL and Cold Fusion Sessions/FONT /P BR PFONT SIZE=3D2gt; I'm having a mind boggeling problem. This = problem only happens/FONT BRFONT SIZE=3D2gt; from within the AOL browser environment. I have = a site that requires/FONT BRFONT SIZE=3D2gt; you to be logged in. Once you log in, you can = go to other pages on/FONT BRFONT SIZE=3D2gt; the site. If these pages detect you aren't = logged in, the bounce you/FONT BRFONT SIZE=3D2gt; back to the login page. In AOL, on certain = pages, even though you/FONT BRFONT SIZE=3D2gt; are logged in, it will bounce you back to the = login screen. This/FONT BRFONT SIZE=3D2gt; doesn't happen on my regular browser, just = within AOL./FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; Is anybody familiar with any kind of special = issues to deal with here?/FONT BRFONT SIZE=3D2gt; I'm using Cold Fusion Session Variables, and = the CFID and CFTOKEN are/FONT BRFONT SIZE=3D2gt; stored in a cookie./FONT /P PFONT SIZE=3D2You're not using the user's IP number in the session = control scheme somehow,/FONT BRFONT SIZE=3D2are you? AOL dial-up users are behind a shifting-IP = proxy... their IP number/FONT BRFONT SIZE=3D2changes in the middle of a session with some = regularity./FONT /P PFONT SIZE=3D2-ron/FONT /P BR BR PFONT = SIZE=3D2---= -/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2Unsubscribe: A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= /A or send a message with 'unsubscribe' in the body to = [EMAIL PROTECTED]/FONT/P /BODY /HTML --_=_NextPart_001_01C03DDA.BCE553E0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: What If You Don't Know The File Type?
At this point, we're not storing any information about the files in a db (we will eventually, but we're not to that point yet). Does cfdirectory have a method for determining the type of file (jpeg, pdf, sit)? In the docs, the only attribute I saw was "type" and all that seems to do is tell you whether it's a file or a directory. And to the post from Randy Adkins ... how do you zip the files once they're on the server? And what if they need to be a .sit file (the people downloading these files are on Macs and would probably prefer stuffit archives). H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = -Original Message- From: Steve Martin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 9:12 AM To: CF-Talk Subject: RE: What If You Don't Know The File Type? Once a file has been uploaded using CFFILE you have access to a bunch of FILE variables. Two of these variables will help you out here: FILE.ContentType FILE.ContentSubType For example, if a GIF file is uploaded, whether it has a .gif extension or not then the above variables will contain the values: image, gif respectively. You can store these values in your db against the file reference and combine them (image/gif) for use in CFCONTENT when delivering the files. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL and Cold Fusion Sessions
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_01C03DDB.518252E0 Content-Type: text/plain; charset="iso-8859-1" What do you mean session level cookies? Can you go into more detail? What is the difference between a regular cookie and a session level cookie? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:52 AM To: CF-Talk Subject: RE: AOL and Cold Fusion Sessions Probably because the AOL browser has session level cookies swiched off. What you should do to overcome this is create a variable in your application.cfm that is the CFID andd CFTOken appended together if cookies are switched off. Then append this variable to every hyperlink/form posting/cflocation in your site. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: 24 October 2000 16:45 To: CF-Talk Subject: AOL and Cold Fusion Sessions 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_01C03DD1.64900C00 Content-Type: text/plain; charset="iso-8859-1" Hey guys, I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. Thanks, Scott --_=_NextPart_001_01C03DD1.64900C00 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLEAOL and Cold Fusion Sessions/TITLE /HEAD BODY PFONT SIZE=2Hey guys,/FONT /P PFONT SIZE=2I'm having a mind boggeling problem. This problem only happens/FONT BRFONT SIZE=2from within the AOL browser environment. I have a site that requires/FONT BRFONT SIZE=2you to be logged in. Once you log in, you can go to other pages on/FONT BRFONT SIZE=2the site. If these pages detect you aren't logged in, the bounce you/FONT BRFONT SIZE=2back to the login page. In AOL, on certain pages, even though you/FONT BRFONT SIZE=2are logged in, it will bounce you back to the login screen. This/FONT BRFONT SIZE=2doesn't happen on my regular browser, just within AOL./FONT /P PFONT SIZE=2Is anybody familiar with any kind of special issues to deal with here?/FONT BRFONT SIZE=2I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are /FONT BRFONT SIZE=2stored in a cookie./FONT /P PFONT SIZE=2Thanks,/FONT /P PFONT SIZE=2Scott/FONT /P /BODY /HTML --_=_NextPart_001_01C03DD1.64900C00-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --_=_NextPart_001_01C03DDB.518252E0 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML
Nesting tags SP2? (was: An Idea about access and paragraphs)
I saw this tag, and it reminded me of an old question of mine. I know that you can nest and open/close tags (cf_tag/cf_tag) via ExecutionMode, CF_associate and all that. All good. Is anyone aware if CF 4.5.1 and beyond let you do that with CFXs? I could not do it in the past, and putting long data in attributes is kind of tricky. Maybe it is possible all together, but I just don't know how to do it... Jaime/ -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:55 AM To: CF-Talk Subject: RE: An Idea about access and paragraphs This is the CF_ParagraphFormat tag I wrote cause I hated the way ParagraphFormat() outputs code. Basically you get the user to enter their text in a TEXTAREA, save it as a memo field and then wrap CF_ParagraphFormat around the variable. It finds double carriage return/line feeds, formats them with P tags with whatever style info you supplied and reformats single carriage return/line feeds with BRs. Usage === CF_ParagraphFormat Style="font-size: 11pt; font-weight: bold; "#YourMemoFieldHere#/CF_ParagraphFormat CF_ParagraphFormat === CFPARAM NAME="attributes.Style" DEFAULT="" CFSET variables.Style="" CFIF Len(attributes.Style) CFSET variables.Style = " STYLE=""" attributes.Style /CFIF CFIF ThisTag.ExecutionMode is "end" CFSET ThisTag.GeneratedContent = "P" variables.Style "" Replace(Replace(ThisTag.GeneratedContent, Chr(13) Chr(10) Chr(13) Chr(10), "/PP" variables.Style "", "ALL"), Chr(13) Chr(10), "BR", "ALL") "/P" /CFIF Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: What If You Don't Know The File Type?
You can use the CFX_Zip which is what I use to compress files. It has the ability to create a ZIP file, update a ZIP file, uncompress a zip file, etc... It is on the Allaire site as well. HTH -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 12:49 PM To: CF-Talk Subject: RE: What If You Don't Know The File Type? At this point, we're not storing any information about the files in a db (we will eventually, but we're not to that point yet). Does cfdirectory have a method for determining the type of file (jpeg, pdf, sit)? In the docs, the only attribute I saw was "type" and all that seems to do is tell you whether it's a file or a directory. And to the post from Randy Adkins ... how do you zip the files once they're on the server? And what if they need to be a .sit file (the people downloading these files are on Macs and would probably prefer stuffit archives). H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = -Original Message- From: Steve Martin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 9:12 AM To: CF-Talk Subject: RE: What If You Don't Know The File Type? Once a file has been uploaded using CFFILE you have access to a bunch of FILE variables. Two of these variables will help you out here: FILE.ContentType FILE.ContentSubType For example, if a GIF file is uploaded, whether it has a .gif extension or not then the above variables will contain the values: image, gif respectively. You can store these values in your db against the file reference and combine them (image/gif) for use in CFCONTENT when delivering the files. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Zeus Webserver
Stewart, I passed your mail on to a guy I know who worked on it. His response is below. Steve -Original Message- From: Chris Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 17:56 To: '[EMAIL PROTECTED]' Subject: RE: Zeus Webserver Chris, This was summat to do with you wasn't it? Yep. Worked a lot on the key components of the Zeus3 Server. btw: I don't expect you to reply to this guy but feel free to do so if you so wish. Oops - Replied to you. Damn. Can you forward it on for me? How's the bald patch? Eh?? Hi All, Does anyone have any experience good or bad with this web server? Well, it's amazingly scalable. Performance is incredible. SGI, HP and others were throwing machines at us for us to optimise the server engine to get the best performance for their hardware platform It was almost a war between these guys! If you want sheer performance, then go for Zeus1. If you want a slightly reduced performance, but configurability and features coming out of your ears, then use Zeus3 (which still performs and scales in a way that BillyBob Gates only dreams of!!!) (Zeus2, BTW, was never-released architecture trial...). All configuration is via a web front end, and I loved using it. Give the guy's as Zeus a call. http://www.zeus.co.uk Their support team is excellent too, they really value their customers because they're a small company. Yeah, I rate the product and the company... Okay, the two guy's who wrote zeus1 from their halls of residence are friends of mine, and it's difficult to know what to say about it!!! The way I always look at it is this: You need to weigh up the pro's and con's of paying for zeus against something like Apache, which is free. As a 'product' Zeus is better than Apache - this is without considering performance. Most organisations LIKE support (which you don't get with Apache). Zeus's maintainance contracts cover virtually all scenarios (I seem to remember) and there's bound to be something to suit all. 30day trial versions are available for download on da web site... Zeus does kick butt, and is a configurable dream.. Ring the guy's at zeus, and try out the trial version. Or if you want some specific informal and unbiased info, then drop me an email and I'll see what I can dig up. Chris ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL and Cold Fusion Sessions
Are you using HTTPS? Nat Papovich ICQ 32676414 "I'm for truth no matter who tells it." -Malcolm X, 1965 -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 8:45 AM To: CF-Talk Subject: AOL and Cold Fusion Sessions 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_01C03DD1.64900C00 Content-Type: text/plain; charset="iso-8859-1" Hey guys, I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. Thanks, Scott --_=_NextPart_001_01C03DD1.64900C00 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLEAOL and Cold Fusion Sessions/TITLE /HEAD BODY PFONT SIZE=2Hey guys,/FONT /P PFONT SIZE=2I'm having a mind boggeling problem. This problem only happens/FONT BRFONT SIZE=2from within the AOL browser environment. I have a site that requires/FONT BRFONT SIZE=2you to be logged in. Once you log in, you can go to other pages on/FONT BRFONT SIZE=2the site. If these pages detect you aren't logged in, the bounce you/FONT BRFONT SIZE=2back to the login page. In AOL, on certain pages, even though you/FONT BRFONT SIZE=2are logged in, it will bounce you back to the login screen. This/FONT BRFONT SIZE=2doesn't happen on my regular browser, just within AOL./FONT /P PFONT SIZE=2Is anybody familiar with any kind of special issues to deal with here?/FONT BRFONT SIZE=2I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are /FONT BRFONT SIZE=2stored in a cookie./FONT /P PFONT SIZE=2Thanks,/FONT /P PFONT SIZE=2Scott/FONT /P /BODY /HTML --_=_NextPart_001_01C03DD1.64900C00-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL and Cold Fusion Sessions
Have you tried passing the CFID and CFTOKEN variables through the URL or form parameters to see if that remedies the problem? Are you also using cflock around your session variables? Shane Witbeck -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 12:52 PM To: CF-Talk Subject: RE: AOL and Cold Fusion Sessions 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_01C03DDA.BCE553E0 Content-Type: text/plain; charset="iso-8859-1" Nope, not using the IP number. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 12:39 PM To: CF-Talk Subject: RE: AOL and Cold Fusion Sessions I'm having a mind boggeling problem. This problem only happens from within the AOL browser environment. I have a site that requires you to be logged in. Once you log in, you can go to other pages on the site. If these pages detect you aren't logged in, the bounce you back to the login page. In AOL, on certain pages, even though you are logged in, it will bounce you back to the login screen. This doesn't happen on my regular browser, just within AOL. Is anybody familiar with any kind of special issues to deal with here? I'm using Cold Fusion Session Variables, and the CFID and CFTOKEN are stored in a cookie. You're not using the user's IP number in the session control scheme somehow, are you? AOL dial-up users are behind a shifting-IP proxy... their IP number changes in the middle of a session with some regularity. -ron Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --_=_NextPart_001_01C03DDA.BCE553E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: AOL and Cold Fusion Sessions/TITLE /HEAD BODY PFONT SIZE=3D2Nope, not using the IP number./FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: [EMAIL PROTECTED] [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Tuesday, October 24, 2000 12:39 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: RE: AOL and Cold Fusion Sessions/FONT /P BR PFONT SIZE=3D2gt; I'm having a mind boggeling problem. This = problem only happens/FONT BRFONT SIZE=3D2gt; from within the AOL browser environment. I have = a site that requires/FONT BRFONT SIZE=3D2gt; you to be logged in. Once you log in, you can = go to other pages on/FONT BRFONT SIZE=3D2gt; the site. If these pages detect you aren't = logged in, the bounce you/FONT BRFONT SIZE=3D2gt; back to the login page. In AOL, on certain = pages, even though you/FONT BRFONT SIZE=3D2gt; are logged in, it will bounce you back to the = login screen. This/FONT BRFONT SIZE=3D2gt; doesn't happen on my regular browser, just = within AOL./FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; Is anybody familiar with any kind of special = issues to deal with here?/FONT BRFONT SIZE=3D2gt; I'm using Cold Fusion Session Variables, and = the CFID and CFTOKEN are/FONT BRFONT SIZE=3D2gt; stored in a cookie./FONT /P PFONT SIZE=3D2You're not using the user's IP number in the session = control scheme somehow,/FONT BRFONT SIZE=3D2are you? AOL dial-up users are behind a shifting-IP = proxy... their IP number/FONT BRFONT SIZE=3D2changes in the middle of a session with some = regularity./FONT /P PFONT SIZE=3D2-ron/FONT /P BR BR PFONT = SIZE=3D2---= -/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2Unsubscribe: A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= /A or send a message with 'unsubscribe' in the body to = [EMAIL PROTECTED]/FONT/P /BODY /HTML --_=_NextPart_001_01C03DDA.BCE553E0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives:
RE: Nesting tags SP2? (was: An Idea about access and paragraphs)
I saw this tag, and it reminded me of an old question of mine. I know that you can nest and open/close tags (cf_tag/cf_tag) via ExecutionMode, CF_associate and all that. All good. Is anyone aware if CF 4.5.1 and beyond let you do that with CFXs? I could not do it in the past, and putting long data in attributes is kind of tricky. I don't think so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Migrating to Unix and ORACLE!
One thing to be aware of is that not all of the extra tags that people sometimes get used to using are not available on Unix... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Nesting tags SP2? (was: An Idea about access and paragraphs)
I saw this tag, and it reminded me of an old question of mine. I know that you can nest and open/close tags (cf_tag/cf_tag) via ExecutionMode, CF_associate and all that. All good. Is anyone aware if CF 4.5.1 and beyond let you do that with CFXs? I could not do it in the past, and putting long data in attributes is kind of tricky. Maybe it is possible all together, but I just don't know how to do it... Jaime/ Far as I know, no. In the CFX's I written I usually try to get around nesting issues by having them return data in SQL queries (which whatever name you choose) that you can loop through n-levels deep. But that's about the extend of such things I believe. --min Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: SQL UPDATE question (was Update Query/Output question from a newbie)
Mike, You need to remove the quotes from your ID field (which is a number, I assume...) CFQUERY DATASOURCE="dbcms" UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_id = #distrib_id# /CFQUERY Any help with this will be much appreciated. My Query is as follows: CFQUERY DATASOURCE="dbcms" UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_id = '#distrib_id#' /CFQUERY I have a hidden field in my update form for the distributor ID: INPUT TYPE="hidden" NAME="distrib_id" Value="#distrib_id#" The error I receive is: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. SQL = "UPDATE tbldistrib SET distrib_name='Calico Corners III', distrib_city='Charlston', distrib_state='SOUTH CAROLINA', distrib_phone='555-555-' WHERE distrib_id = '31'" Data Source = "DBCMS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:29) in the template file c:\inetpub\wwwroot\cms\updatedata.cfm. Thanks for your time, Mike Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Zeus Web Server
Has anyone ever used, or worked with the Zeus web server software (www.zeus.co.uk)? I'm wondering if it will work with CF .. any opinions/guesses? Todd Ashworth Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: how to prevent link from using IE window
Dont use mailto. Use a form instead. That way, you won't be launching any other programs. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Christopher P. Maher [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 22, 2000 4:45 PM To: CF-Talk Subject: how to prevent link from using IE window I have a CF application that uses various statements to prevent browser caching. This works well except when a user clicks on a link in, say, an e-mail. Then that link opens in the instance of IE my application is using. Because of the browser anti-caching when the user hits the back button to return to my page, they are told that the page has expired. Refresh and they loose their work. Is there some way to prevent this from happening (short of making Netscape the default browser)? The only solution that is practical would be something I can put into the HTML. I cannot configure user computers. Basically I want only MY application to run in that particular instance of IE. Hope that makes sense. Thanks --- Christopher P. Maher mailto:[EMAIL PROTECTED] Maher Associates, Inc. Actuarial and Computer Consulting http://www.maherassociates.com -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Zeus Web Server
Please see the message posted 50 minutes ago titled: Re: Zeus Webserver Donchahateitwhenthathappens? Seriously though, why all the sudden interest in Zeus? You guys seeing ads or articles about it somewhere? -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:43 PM To: CF-Talk Subject: Zeus Web Server Has anyone ever used, or worked with the Zeus web server software (www.zeus.co.uk)? I'm wondering if it will work with CF .. any opinions/guesses? Todd Ashworth -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Zeus Web Server
Has anyone ever used, or worked with the Zeus web server software (www.zeus.co.uk)? I'm wondering if it will work with CF .. any opinions/guesses? Funny you should mention that - it was mentioned just a few messages ago. It should work with CF. It may not work well with CF, but it should work. CF can be used as a "traditional" CGI application, which can be used with any web server available on the OSes which CF supports. The Zeus Web Server does provide an ISAPI interface, which CF also supports, but CF only provides an ISAPI DLL on Windows, so you'd need a Windows version of Zeus (I don't know if there is one) if you wanted the performance benefits of web server API integration - and you do, trust me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF in permanent infinite restart loop
Sounds like you've got a bad script on the server somewhere which is causing an infinite loop and locking up the server. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 10:14 AM To: CF-Talk Subject: CF in permanent infinite restart loop Somehow our CF 4.01 on Solaris 2.6 had gotten caught in an infinite loop of restarts. About every ten seconds it restarts, and constantly refuses all cfm service. I've tried stopping/starting CF, iPlanet webserver, and the Unix computer. I've tried Allaire's recomendation of "stop -force", then delete ServicePid and ServiceRunning (KB 11501) - but that hasn't worked. The start script is okay (replaced with a backup) and the odbc.ini file is okay. No templates can run because the server is too busy constantly restarting itself - so it's not a template problem. Any ideas out there? thanks, Chris Norloff -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Zeus Web Server
Ugh! I feel like such a moron. I though I read that on the ISP-Webhosting mailing list. I really need to cut back ... Todd Ashworth - Original Message - From: "Cameron Childress" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 24, 2000 2:11 PM Subject: RE: Zeus Web Server | Please see the message posted 50 minutes ago titled: Re: Zeus Webserver | | Donchahateitwhenthathappens? | | Seriously though, why all the sudden interest in Zeus? You guys seeing ads | or articles about it somewhere? | | -Cameron | | | Cameron Childress | ElliptIQ Inc. | p.770.460.7277.232 | f.770.460.0963 | | -Original Message- | From: Todd Ashworth [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, October 24, 2000 2:43 PM | To: CF-Talk | Subject: Zeus Web Server | | | Has anyone ever used, or worked with the Zeus web server software | (www.zeus.co.uk)? I'm wondering if it will work with CF .. any | opinions/guesses? | | Todd Ashworth | | | -- | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists | or send a message with 'unsubscribe' in the body to | [EMAIL PROTECTED] | | -- -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: An Idea about access and paragraphs
Try this when outputting data which you feel should contain paragraph breaks: #Replace(message_body, "#CHR(10)#", "br", "ALL")# -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 10:23 AM To: CF-Talk Subject: An Idea about access and paragraphs Hi everyone, So, here's my idea. Access cannot literally store paragraphs however you can always put in P at the start of each paragraph/line and achieve the the paragraphs. The drawback to this is that if it is left up to the regular user, they'll probably mess it up. So, this is the idea. Is there a way to detect a paragraph break, then when you submit the page, the paragraph break is detected, and then replaced with a P tag. Therefor all the user has to do, is put in a normal paragraph. Mark Smeets/stranger0/ICQ #1062196 "Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two" - Wild Wild West Official Splitting Adam Homepage http://www.splittingadam.com/ Over the Wall Productions and Web Designs http://www.solarcourt.com/ _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Mysterious Request Scope
It's similar to variables scope, except it is globally available across CFMODULE and custom tags. At 07:54 AM 10/24/00 +0100, Mark Johnson wrote: I have seen a few references to the REQUEST scope by many on this list. Is this a standard scope that is available to all CF pages? What is stored in this structure? Is there any information on it in the CF documentation? When does it get built? Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Internet World Fall Conference
Hello, Patti Mayer here, from Neotech-Associates. If anyone has a topic they would like to speak about we can still take care of you for the conference. I know the conference is close, but, I will do whatever you need to help you get there. This is a great opportunity for you to show your business to over 50,000 interested people. We are making it even easier, if you want to be a speaking sponsor, it would be free with a banner or brochure sponsorship. Let me know. [EMAIL PROTECTED] http://www.neotech-associates.com/IWORLD You can sign up from our web site, as easy as can be. ColdFusion Business and Career Conference at Internet World Time is running out to sponsor the Fall Internet World ColdFusion Business and Career Conference, taking place on October 27, 2000. Drawing 50,000 visitors in 1999, Internet World is the largest Internet Industry Tradeshow around, with vendors such as Allaire showing off their product and service lines. Unfortunately, the smaller Web Development Consulting, ASPs and web technology firms often get left out, leaving hundreds of thousands of dollars in potential customer revenue to companies with larger marketing and PR budgets. This year, by developing the ColdFusion Business and Career Conference, Neotech Associates has created a rare opportunity for the smaller companies who would like to grow their business and interact with a Tradeshow crowd. The event is being promoted through various sources such as Allaire, Fusion Authority and on the Tradeshow floor at sponsoring vendor booths. One representative from the promoting company, Neotech Associates states, "The little guy may have a product that works just as well if not better than more prominent products. Now is the time for him to get the word out." All sponsors are encouraged to invite people they meet and potential clients to the conference, adding that additional element of unmatched credibility. Sponsoring this event is also an amazing opportunity, the company claims. "All firms utilizing ColdFusion for consulting projects or technology products are invited to participate for as little as $250. Try to get promotional tradeshow exposure at this rate anywhere else." The goal of the conference is to show off what can be done with ColdFusion and complementary technologies without costing participants 15k+ for trande show floor booths. CF Integration with Flash Wireless devices are some of the topics that tend to wow this crowd, but there is definitely a place for standard consultancies delivering everyday solutions." We're striking a balance -- encouraging companies to communicate their product services in an informative, non-salesy manner," states the promoter. "We want conference visitors to leave thinking that the speaker communicated very useful information. We also want developers in the audience to think, wow, what a great company to work for!" In support of the Conference, one sponsor, Natex Communications (http://www.natex.com) states, "If my company can afford customers, I can definitely afford to participate in this amazing event." There are still a few sponsorships available. Speakers are invited to discuss marketing techniques for ColdFusion-based products and/or services from their corporate perspective; the ins and outs of winning government contracts for ColdFusion development; project management techniques and development cycles (as recommended by your company); good Human Resources practices for hiring, retaining and cross-training your ColdFusion development staff; and many other topics. Neotech is also accepting proposals. Tables are available for a limited number of companies who would like to pass out literature and be engaged in business discussions. Corporate logos and addresses can be placed in the conference brochure, which will be passed out on the Tradeshow Floor during Fall Internet World. To sponsor this event, to register for your Free Internet World Pass, or for general information, go to http://www.neotech-associates.com/IWORLD. -- Neotech Thanks You For Your Support. http://www.neotech-associates.com/IWORLD Email- [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
What about Apache? (was Re: Zeus Web Server)
Actually, I am not curious, because I am getting ready to set up some servers and am trying to decide on the OS to use, etc. In light of your comments about the .dll .. wouldn't you have the same problems with Apache on Linux, which would make NT the better all around choice for ColdFusion apps? Todd Ashworth | Funny you should mention that - it was mentioned just a few messages ago. | | It should work with CF. It may not work well with CF, but it should work. | | CF can be used as a "traditional" CGI application, which can be used with | any web server available on the OSes which CF supports. The Zeus Web Server | does provide an ISAPI interface, which CF also supports, but CF only | provides an ISAPI DLL on Windows, so you'd need a Windows version of Zeus (I | don't know if there is one) if you wanted the performance benefits of web | server API integration - and you do, trust me. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Problem with email form validation
I'm sorry, but it still submits the form. It must be because of the scripts created by ColdFusion. - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, October 24, 2000 12:02 PM Subject: RE: Problem with email form validation you need to add a "return false;" in there. like this function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); return false; } return true; } otherwise, the script will always return true, and always think the email is correct. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Problem with email form validation
I did this and it still doesn't work. It must be related to the scripts created by ColdFusion for the CFForms. - Original Message - From: "Bob Silverberg" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, October 24, 2000 12:09 PM Subject: RE: Problem with email form validation Firstly, you should have your CheckEmail function return false if the validation fails - it looks like you haven't specified that within the function. Then, in your form tag, call the function by doing: onSubmit="return CheckEmail();" Bob -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fields are correct except for the email format, this scripts correctly tells me that the email is not in a proper format, but after I click on OK, the form is sent anyways. Here is one of the scripts I tried: script language="JavaScript" function ValidEmail(item) { var lsAT; var lsDOT; lsAT = item.value.indexOf("@"); lsDOT = item.value.indexOf("."); if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT + 1 = lsDOT ) { return false; } return true; } function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); } return true; } /script Any help would greatly be apreciated. TIA! _ Michael -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: query problem
From: "Dominic J. Doucet-Lorang" [EMAIL PROTECTED] Is there some way of incorperating the datediff function into a query? I am trying to get only records that have a date difference of 30 days. Here is the query: CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC" select distinct forsikring.*,kunde.* from forsikring, kunde where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND forsikring.id = kunde.id and Abs(datediff("d", dos, #dos2#) LTE 30 /CFQUERY datediff('d',dos,#dos2#) use ' instead of " Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: What about Apache? (was Re: Zeus Web Server)
It also appears to support NSAPI, which should run on ZEUS/Solaris (though I didn't get into detail on the Zeus page). CF on Linux uses an Apache module rather than CGI. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:59 PM To: CF-Talk Subject: What about Apache? (was Re: Zeus Web Server) Actually, I am not curious, because I am getting ready to set up some servers and am trying to decide on the OS to use, etc. In light of your comments about the .dll .. wouldn't you have the same problems with Apache on Linux, which would make NT the better all around choice for ColdFusion apps? Todd Ashworth | Funny you should mention that - it was mentioned just a few messages ago. | | It should work with CF. It may not work well with CF, but it should work. | | CF can be used as a "traditional" CGI application, which can be used with | any web server available on the OSes which CF supports. The Zeus Web Server | does provide an ISAPI interface, which CF also supports, but CF only | provides an ISAPI DLL on Windows, so you'd need a Windows version of Zeus (I | don't know if there is one) if you wanted the performance benefits of web | server API integration - and you do, trust me. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Slightly OT: Cable Modem and TZO
Hi everyone, I am currently subscribed as a @Home (cable modem) user. I would like to host my own personal CF website (.com) on my own server. Has anyone ever heard of TZO? Is anyone hosting their own server using @Home (with or without TZO)? Thanks, Deb Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Slightly OT: Cable Modem and TZO
Check the AUP ... @Home does not allow public web servers on their residential service ... maybe with their commercial @Work. Never heard of TZO. Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:32 PM To: CF-Talk Subject: Slightly OT: Cable Modem and TZO Hi everyone, I am currently subscribed as a @Home (cable modem) user. I would like to host my own personal CF website (.com) on my own server. Has anyone ever heard of TZO? Is anyone hosting their own server using @Home (with or without TZO)? Thanks, Deb Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Finding a query in a file
Something like this will probably work for you: cfquery([[:space:]]+[[:alnum:]]+=("[^"]+"|[^[:space:]]+))+[[:space:]]* This will deal with the case of having non-alphanumeric tag attributes in random order. -Rick -Original Message- From: Christopher S Martin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 12:25 To: CF-Talk Subject: Finding a query in a file Hi everyone, i have written a regex that should (i think) return an instance of any cfquery name=blah datasource=foo in a page. I read a page into meory first, and call it page_buffer. The regex looks like this: ReFindNoCase("cfquery +name=[a-z]+[0-9]* +datasource=[a-z]+", #page_buffer#) For some reason, however, this does not turn up any mathces. Could any of you regex wiards out there tell me why? Chris Martin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Slightly OT: Cable Modem and TZO
I was doing some myself. You can host it via IP Address if you run a static IP from @Home. If you want a web address such as www.myplace.com or something then you have to see who will host your DNS record. Last time I checked @Home would not do that unless it was a business. Also if you use straight IP address, please beware that @Home service updates their Gateway periodically thus in your network properties the Gateway is no longer valid. Things to consider. Sorry but I think it is the few things you should know prior to doing so. I do have a friend who has been doing his from home with @Home service. -Original Message- From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:32 PM To: CF-Talk Subject: Slightly OT: Cable Modem and TZO Hi everyone, I am currently subscribed as a @Home (cable modem) user. I would like to host my own personal CF website (.com) on my own server. Has anyone ever heard of TZO? Is anyone hosting their own server using @Home (with or without TZO)? Thanks, Deb Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]