RE: Can JavaScript be included in CFMAIL
Your mail reader probably disables the java script code for security reasons. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: J.Milks [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 2:42 PM To: CF-Talk Subject: Can JavaScript be included in CFMAIL This is a multi-part message in MIME format. --=_NextPart_000_01D6_01C0295A.4AD2D360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I am trying to include some JavaScript into a CFMAIL message of type = HTML, but it is not working. When I view the source, the script is = there, but it is not executing. Any ideas? Jim --=_NextPart_000_01D6_01C0295A.4AD2D360 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVFONT face=3DArial size=3D2I am trying to include some JavaScript = into a=20 CFMAIL message of type HTML, but it is not working. When I view the = source, the=20 script is there, but it is not executing./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Any ideas?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Jim/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_01D6_01C0295A.4AD2D360-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Outlook information
FWIW, you can do this stuff in ASP - there's something called a Digital Dashboard, with pre-developed applications to access the Inbox, Calendar, COntacts etc. You could combine ASP pages with Coldfusion if that's possible in your case. http://www.microsoft.com/solutions/km/digitaldashboard.htm Seth Ward -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 27 September 2000 18:13 To: CF-Talk Subject: Getting Outlook information My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A cfquery problem.
Vin There isn't an easy way of doing this in SQL. The usual way AFAIK is to grab the entire query each time and then navigate to the right row of the query results. If you cache the CFQUERY it's not a problem preformance-wise. Otherwise it is! Nick -Original Message- From: Vincent [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 6:36 AM To: CF-Talk Subject: A cfquery problem. hi, I guess this is more of an SQL problem... what I wanted was for me to be able to select a group of rows in my cfquery statement. eg: cfquery name="get_items" datasource="users" maxrows = 10 SELECT itemnum FROM items WHERE user_id = 12345 /cfquery Now this will get me the top 10 rows, yes! Now what Im looking at is rows 10-20, then 20-30etc Is this possible. I know of one way, but its kinda a long cut. thanks regards, VIN ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A cfquery problem.
I suggest trying to utilise the STARTROW and MAXROWS with your query. CFOUTPUT QUERY="query_name" GROUP="query_column" GROUPCASESENSITIVE="yes/no" STARTROW="start_row" MAXROWS="max_rows_output" -Original Message- From: Vincent [SMTP:[EMAIL PROTECTED]] Sent: 29 September 2000 06:36 To: CF-Talk Subject: A cfquery problem. hi, I guess this is more of an SQL problem... what I wanted was for me to be able to select a group of rows in my cfquery statement. eg: cfquery name="get_items" datasource="users" maxrows = 10 SELECT itemnum FROM items WHERE user_id = 12345 /cfquery Now this will get me the top 10 rows, yes! Now what Im looking at is rows 10-20, then 20-30etc Is this possible. I know of one way, but its kinda a long cut. thanks regards, VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: A cfquery problem.
Vincent I don't know of any way you can do this in SQL but just a simple query and a post works great. This should work for you. Adjust the cache time span to meet your needs. -Mark :o) Learning = (Asking + Teaching) CFQUERY NAME="get_items" DATASOURCE="users" CACHEDWITHIN="#CreateTimeSpan(0,0,5,0)#" SELECT itemnum, user_id FROM items WHERE user_id = 12345 /CFQUERY CFSET MaxRows = 10 CFPARAM NAME="Begin" DEFAULT="1" CFPARAM NAME="itemnum" DEFAULT="" CFPARAM NAME="user_id " DEFAULT="" CFOUTPUT QUERY="get_items" STARTROW=#Begin# MAXROWS=#MaxRows# #itemnum#br /CFOUTPUT CFSET NextTen = Begin + MaxRows CFOUTPUT CFIF NextTen LTE get_items.RecordCount FORM ACTION="get_items.cfm" METHOD="post" INPUT TYPE="hidden" NAME="ItemNumber" VALUE="#itemnum#" INPUT TYPE="hidden" NAME="Begin" VALUE="#NextTen#" INPUT TYPE="submit" VALUE="Next #MaxRows#" /FORM /CFIF /CFOUTPUT - Original Message - From: Vincent [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 10:36 PM Subject: A cfquery problem. hi, I guess this is more of an SQL problem... what I wanted was for me to be able to select a group of rows in my cfquery statement. eg: cfquery name="get_items" datasource="users" maxrows = 10 SELECT itemnum FROM items WHERE user_id = 12345 /cfquery Now this will get me the top 10 rows, yes! Now what Im looking at is rows 10-20, then 20-30etc Is this possible. I know of one way, but its kinda a long cut. thanks regards, VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Linux, MySql, NT, Access - which?
Hi all, I'm re-coding a web site of mine in Cold Fusion, and I've been happy so far doing it on Windows NT and Access, mainly because I'm a sucker for a GUI and it's so easy to make mods to an Access Database. Having said that I have use of an excellent server in Telehouse Docklands that's running Linux; so my question to you is, should I go for Linux and MySql or stick with the ease (IMO) of NT and Access? Incidentally if I go over to MySql, is there an easy and bug-free way of converting Access Databases to MySql? I look forward to anyone's comments.. Cheers Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Email Trigger?
Use iMS from www.Coolfusion.com... Justin - Original Message - From: "Karl Simanonok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 5:55 PM Subject: Email Trigger? No, I do not want email sent at a certain time or upon a user action. I want a Cold Fusion template to be executed when I send email to an email address. It can be an email account on the same server if that helps (you'd think so). I know I can do it by using a scheduled task to check for new email at specified intervals, but scheduled tasks are frequently unreliable and either I'd have to have very short intervals of checking or I'd have to be content with waiting (and hoping) for the scheduled task to run. So intstead I would like to be able to trigger a CF template some other way, using email. Maybe there's a CFX out there for this purpose, or some obscure CF function that I haven't heard of using this way? Regards, Karl Simanonok Original Message: Date: Tue, 26 Sep 2000 16:51:01 -0400 From: Simon Horwith [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: Email Trigger Message-ID: [EMAIL PROTECTED] you want an e-mail sent at a certain date/time, or upon user action? -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 2:25 PM To: CF-Talk Subject: Email Trigger Does anyone know of a way to send email that will trigger a CF template to be executed, WITHOUT having to set up a scheduled task? Regards, Karl Simanonok -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Linux, MySql, NT, Access - which?
on 9/29/00 6:37 PM, W Luke at [EMAIL PROTECTED] wrote: I have use of an excellent server in Telehouse Docklands that's running Linux; so my question to you is, should I go for Linux and MySql or stick with the ease (IMO) of NT and Access? Incidentally if I go over to MySql, is there an easy and bug-free way of converting Access Databases to MySql? MySQL will kick Access's butt if you have much of a load on the system. There are a few nice GUI tools that make it almost as nice to use MySQL as it is to use Access - try having a look at Download.com or similar. There are a couple of AccessMySQL utilities that I've seens but I've never been able to get them working 100% -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: A cfquery problem.
On 9/29/00, Vincent penned: cfquery name="get_items" datasource="users" maxrows = 10 SELECT itemnum FROM items WHERE user_id = 12345 /cfquery Now this will get me the top 10 rows, yes! Now what Im looking at is rows 10-20, then 20-30etc Is this possible. I know of one way, but its kinda a long cut. Hi Vin. Maxrows will go in the cfoutput portion of your query. cfoutput query="get_items" maxrows="#maxrows#" startrow="#startrow#" Startrow will be the dynamic variable. On the initial search, you will pass a value of "1". Or you can pass nothing and use cfparam to set a default of "1". CFPARAM NAME="startrow" DEFAULT="1" CFPARAM NAME="maxrows" DEFAULT="10" Then to do your next and previous buttons, you will generally use 2 forms and place this before them: cfset PrevStart = StartRow - MaxRows cfset NextStart = StartRow + MaxRows cfif PrevStart GTE 1 form action="samepage.cfm" method="post" (form stuff) input type="hidden" name="startrow" value="#PrevStart#" input type="hidden" name="maxrows" value="#maxrows#" input type="Submit" value="Previous #maxrows# Records" /form /cfif cfif NextStart LTE Get_Items.RecordCount form action="samepage.cfm" method="post" (form stuff) input type="hidden" name="startrow" value="#NextStart#" input type="hidden" name="maxrows" value="#maxrows#" input type="Submit" value="Next #maxrows# Records" /form /cfif You can also do some neat stuff like checking if there are less than maxrows records left and show the Next button accordingly. cfset remaining = Get_Items.RecordCount - startrow + 1 This will go AFTER the cfset PrevStart/NextStart code. In a search returning 28 records, when you return records 11 thru 20, the value of remaining would be 8. 28 - 21 (the value of startrow) = 7 + 1 = 8 Then you could set accordingly. cfif remaining GT maxrows input type="Submit" value="Next #maxrows# Records" cfelseif remaining LTE maxrows and remaining GT "1" input type="Submit" value="Final #remaining# Records" cfelseif remaining is "1" input type="Submit" value="Final Record" /cfif You can use the same parameters at the top of the search results: CFIF Get_Items.Recordcount IS "1" Displaying 1 item found CFELSE Displaying records #startrow# thru cfif Get_Items.Recordcount LTE (startrow + maxrows - 1) #Get_Items.Recordcount#cfelse #Abs(startrow + maxrows - 1)#/cfif of #Get_Items.Recordcount# records found /CFIF HTH -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Medadata
Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) Thanks! Juandres -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
thanks
hey, Mark Adams Mike Connolly Nick DeVoil Thanks guys ! regards VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Medadata
What database you using ...in Oracle have a look at the all_tab_columns ( I think) table -- From: Juan Andres Alvarez Valenzuela[SMTP:[EMAIL PROTECTED]] Sent: 29 September 2000 10:55 To: CF-Talk Subject: Medadata Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) Thanks! Juandres -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Medadata
Hola Juan, Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) In MsSql you can use the StoredProcs such called sp_tables witch will return all the tables in a DB including the sys tables. There are other that do different things , sp_columns etc... In Access you can get at the table names from a systable , it's called MsysObjects ,but it has alot of other stuff in there. To view the table in access go to tools-options-view and tick hidden objects and system objects Hasta Lleugo ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: INSERT INTO with loop problem
Michael
Have you tried using the temporary variables in your INTO clause
as well as in your VALUES clause?
Nick
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 7:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Metadata 2
sorry guys I forgot to mention I want to do that from ColdFusion using ODBC (ie. no matter wich database is) ideas? gracias ; ) Juandres - Original Message - From: JustinMacCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 12:14 PM Subject: Re: Medadata Hola Juan, Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) In MsSql you can use the StoredProcs such called sp_tables witch will return all the tables in a DB including the sys tables. There are other that do different things , sp_columns etc... In Access you can get at the table names from a systable , it's called MsysObjects ,but it has alot of other stuff in there. To view the table in access go to tools-options-view and tick hidden objects and system objects Hasta Lleugo ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFX_Hostip
Hmmm I seem to have misplaced this tag, and i can't remember when or how i...erm...came by it.anyone have a copy or know who produced it? Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Metadata 2
ODBC coneects you to a database. The type of the database determines what tables you have to look at to get the metadata. -- From: Juan Andres Alvarez Valenzuela[SMTP:[EMAIL PROTECTED]] Sent: 29 September 2000 11:24 To: CF-Talk Subject: Metadata 2 sorry guys I forgot to mention I want to do that from ColdFusion using ODBC (ie. no matter wich database is) ideas? gracias ; ) Juandres - Original Message - From: JustinMacCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 12:14 PM Subject: Re: Medadata Hola Juan, Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) In MsSql you can use the StoredProcs such called sp_tables witch will return all the tables in a DB including the sys tables. There are other that do different things , sp_columns etc... In Access you can get at the table names from a systable , it's called MsysObjects ,but it has alot of other stuff in there. To view the table in access go to tools-options-view and tick hidden objects and system objects Hasta Lleugo ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFX_Hostip
This what you are looking for? http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476D3-2830-11D4-AA 9700508B94F380method=Full ~Justin - Original Message - From: "Stewart McGowan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 11:24 AM Subject: CFX_Hostip Hmmm I seem to have misplaced this tag, and i can't remember when or how i...erm...came by it.anyone have a copy or know who produced it? Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Medadata
Which DB? -Original Message- From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 10:56 AM To: CF-Talk Subject: Medadata Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) Thanks! Juandres -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Metadata
well, I thought that exists a generic form to do that through ODBC for all databases. Juandres - Original Message - From: DeVoil, Nick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 11:54 AM Subject: RE: Medadata Which DB? -Original Message- From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 10:56 AM To: CF-Talk Subject: Medadata Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) Thanks! Juandres -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
AutoNumbers and INSERTS
Hi, I'm inserting a load of data into a Table of an Access Database. The ID field is generated by AutoNumber. As soon as the record has been inserted, I need to output what that ID was. How can I do this? Cheers Will... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HeadHunters?
No one's called me. I must be getting a bad reputation. LOL -- Bud Schneehagen - Tropical Web Creations You're letting your cat's answer the phone again aren't you? :) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
I'm having trouble displaying the pdf in netscape it doesn't give me the navigational toolbar at the top of the document. Any ideas what would cause netscape to act this way? Thanks, Dave -Original Message- From: Hayes, David [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:54 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? FYI - It's working fine on my machine; acrobat reader loads and the pdf is displayed properly. -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:40 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? 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_01C0297B.7F2629C8 Content-Type: text/plain; charset="iso-8859-1" Rob, thanks for the feedback. For PDF files I am using the standard MIME types. Here is my code. cfcontent type="application/pdf" file="F:\projectdata\1\1\test.pdf" deletefile="No" You can go to http://www.edificium.com/imagetest/getstuff.cfm?bob=pdf to see the (awful mess of a) result On the second part of your message, if I do use the CF directory mappings, aren't I suddenly unable to user the img src="..." tag - is there a work around? Thanks fo ryou help Nadir -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 12:48 AM To: CF-Talk Subject: Re: Protecting Content / content leeching... A CF method? on 9/28/00 7:28 AM, Nadir Ait-Laoussine at [EMAIL PROTECTED] wrote: Now, I've been recommended to user CFCONTENT, the problem with CFCONTENT is that it just spews out the content, so a PDF file (even if I specify the mime type) will come not come out as a PDF file, but some garbled text. What MIME type are you using for PDFs? What you describe works perfectly for me. You could also try using CF directory mappings - these will prevent anyone directly accessing the files if you point them outside the Web root directory. Rob Keniger [EMAIL PROTECTED] __ __ big bang solutions http://www.bigbang.net.au p +61 7 3311 2733 f +61 7 3311 2744 __ __ -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C0297B.7F2629C8 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: Protecting Content / content leeching... A CF = method?/TITLE /HEAD BODY PFONT SIZE=3D2Rob, thanks for the feedback./FONT /P PFONT SIZE=3D2For PDF files I am using the standard MIME = types./FONT /P PFONT SIZE=3D2Here is my code./FONT /P PFONT SIZE=3D2lt;cfcontent type=3Dquot;application/pdfquot; = file=3Dquot;F:\projectdata\1\1\test.pdfquot; = deletefile=3Dquot;Noquot;gt;/FONT /P PFONT SIZE=3D2You can go to /FONT BRFONT SIZE=3D2A = HREF=3D"http://www.edificium.com/imagetest/getstuff.cfm?bob=3Dpdf" = TARGET=3D"_blank"http://www.edificium.com/imagetest/getstuff.cfm?bob=3D= pdf/A to see the (awful mess of a) result/FONT /P BR PFONT SIZE=3D2On the second part of your message, if I do use the = CF directory mappings, aren't I suddenly unable to user thenbsp; = lt;img src=3Dquot;...quot;gt; tag - is there a work = around?/FONT/P PFONT SIZE=3D2Thanks fo ryou help/FONT BRFONT SIZE=3D2Nadir/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Rob Keniger [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Thursday, September 28, 2000 12:48 AM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: Re: Protecting Content / content = leeching... A CF method?/FONT /P BR PFONT SIZE=3D2on 9/28/00 7:28 AM, Nadir Ait-Laoussine at = [EMAIL PROTECTED] wrote:/FONT /P PFONT SIZE=3D2gt; Now, I've been/FONT BRFONT SIZE=3D2gt; recommended to user CFCONTENT, the problem with = CFCONTENT is that it just/FONT BRFONT SIZE=3D2gt; spews out the content, so a PDF file (even if I = specify the mime type) will/FONT BRFONT SIZE=3D2gt; come not come out as a PDF file, but some = garbled text./FONT /P PFONT SIZE=3D2What MIME type are you using for PDFs? What you = describe
RE: CFX_Hostip
Not the same one, but it does what I need, thanks Justin, I think the original was something I purloined Stew -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 11:57 To: CF-Talk Subject: Re: CFX_Hostip This what you are looking for? http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476D3-2830-11D4-AA 9700508B94F380method=Full ~Justin - Original Message - From: "Stewart McGowan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 11:24 AM Subject: CFX_Hostip Hmmm I seem to have misplaced this tag, and i can't remember when or how i...erm...came by it.anyone have a copy or know who produced it? Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Metadata 2
u could use the win32::odbc perl extension and get the table names that way, I think the method is tablelist() or something similair Stew -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 11:46 To: CF-Talk Subject: RE: Metadata 2 ODBC coneects you to a database. The type of the database determines what tables you have to look at to get the metadata. -- From: Juan Andres Alvarez Valenzuela[SMTP:[EMAIL PROTECTED]] Sent: 29 September 2000 11:24 To: CF-Talk Subject: Metadata 2 sorry guys I forgot to mention I want to do that from ColdFusion using ODBC (ie. no matter wich database is) ideas? gracias ; ) Juandres - Original Message - From: JustinMacCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 12:14 PM Subject: Re: Medadata Hola Juan, Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) In MsSql you can use the StoredProcs such called sp_tables witch will return all the tables in a DB including the sys tables. There are other that do different things , sp_columns etc... In Access you can get at the table names from a systable , it's called MsysObjects ,but it has alot of other stuff in there. To view the table in access go to tools-options-view and tick hidden objects and system objects Hasta Lleugo ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HeadHunters?
Yes, I am getting them to and haven't even sent out any apps or feelers. Larry Juncker Senior Cold Fusion Programmer Heartland Internet -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:55 PM To: CF-Talk Subject: HeadHunters? Is anyone else magically getting job offers from headhunters who know your name or is it just me? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Linux, MySql, NT, Access - which?
At 18:53 9/29/00 +1000, you wrote: on 9/29/00 6:37 PM, W Luke at [EMAIL PROTECTED] wrote: I have use of an excellent server in Telehouse Docklands that's running Linux; so my question to you is, should I go for Linux and MySql or stick with the ease (IMO) of NT and Access? Incidentally if I go over to MySql, is there an easy and bug-free way of converting Access Databases to MySql? I have some vb code you can copy and paste into a module (or something..) in access and then run it, it will generate a text file with SQL statements to create the tables in SQL, and I think it puts the data in there, too. Had to modify it a bit to get it working, but it works now. Let me know if you want it. RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HeadHunters?
We have been getting that *and* headhunters are also calling our company up trying to get us to hire people completely unrelated to anything we do. Go figure ... Todd Ashworth - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:56 AM Subject: RE: HeadHunters? | Yes, I am getting them to and haven't even sent out any apps or feelers. | | Larry Juncker | Senior Cold Fusion Programmer | Heartland Internet | | -Original Message- | From: Robert Everland [mailto:[EMAIL PROTECTED]] | Sent: Thursday, September 28, 2000 1:55 PM | To: CF-Talk | Subject: HeadHunters? | | | Is anyone else magically getting job offers from headhunters who | know your name or is it just me? | | Robert Everland III | Web Developer | Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can JavaScript be included in CFMAIL
You could include the file (.js extension) and let the user double click it. If you do this, be sure to write your javascript (or should I say jscript) so that it meets the syntactical requirements of the windows script host. ~Simon -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:34 AM To: CF-Talk Subject: RE: Can JavaScript be included in CFMAIL Your mail reader probably disables the java script code for security reasons. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: J.Milks [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 2:42 PM To: CF-Talk Subject: Can JavaScript be included in CFMAIL This is a multi-part message in MIME format. --=_NextPart_000_01D6_01C0295A.4AD2D360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I am trying to include some JavaScript into a CFMAIL message of type = HTML, but it is not working. When I view the source, the script is = there, but it is not executing. Any ideas? Jim --=_NextPart_000_01D6_01C0295A.4AD2D360 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVFONT face=3DArial size=3D2I am trying to include some JavaScript = into a=20 CFMAIL message of type HTML, but it is not working. When I view the = source, the=20 script is there, but it is not executing./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Any ideas?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Jim/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_01D6_01C0295A.4AD2D360-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Linux, MySql, NT, Access - which?
- Original Message - From: "Ryan" [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Friday, September 29, 2000 2:00 PM Subject: Re: Linux, MySql, NT, Access - which? At 18:53 9/29/00 +1000, you wrote: on 9/29/00 6:37 PM, W Luke at [EMAIL PROTECTED] wrote: I have use of an excellent server in Telehouse Docklands that's running Linux; so my question to you is, should I go for Linux and MySql or stick with the ease (IMO) of NT and Access? Incidentally if I go over to MySql, is there an easy and bug-free way of converting Access Databases to MySql? I have some vb code you can copy and paste into a module (or something..) in access and then run it, it will generate a text file with SQL statements to create the tables in SQL, and I think it puts the data in there, too. Had to modify it a bit to get it working, but it works now. Let me know if you want it. Sounds dead handy - would love a look, thanks. Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: AutoNumbers and INSERTS
- Original Message - From: "Homer Simpson" [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Friday, September 29, 2000 1:38 PM Subject: RE: AutoNumbers and INSERTS You could try adding the data with a CFQUERY INSER and then immediately after do a CFQUERY SELECT ID FROM My_Table WHERE blah = whatwasjustadded AND blah2 = whatwasalsoadded /CFQUERY including as much info as possible so that you only get one record returned and then output the ID as you would normally Yeah, that's what I thought - it just seemed a bit messy doing it that way :o) Cheers Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
I'm kinda confused (hah!) but isn't it technically impossible to protect any content that the person can see? In order to see an image/pdf/text file it has to be downloaded - therefore it is accessable. There is no possible way to protect an image from being taken (SnagIT). or am i off subject? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 7:02 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm having trouble displaying the pdf in netscape it doesn't give me the navigational toolbar at the top of the document. Any ideas what would cause netscape to act this way? Thanks, Dave -Original Message- From: Hayes, David [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:54 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? FYI - It's working fine on my machine; acrobat reader loads and the pdf is displayed properly. -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:40 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? 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_01C0297B.7F2629C8 Content-Type: text/plain; charset="iso-8859-1" Rob, thanks for the feedback. For PDF files I am using the standard MIME types. Here is my code. cfcontent type="application/pdf" file="F:\projectdata\1\1\test.pdf" deletefile="No" You can go to http://www.edificium.com/imagetest/getstuff.cfm?bob=pdf to see the (awful mess of a) result On the second part of your message, if I do use the CF directory mappings, aren't I suddenly unable to user the img src="..." tag - is there a work around? Thanks fo ryou help Nadir -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 12:48 AM To: CF-Talk Subject: Re: Protecting Content / content leeching... A CF method? on 9/28/00 7:28 AM, Nadir Ait-Laoussine at [EMAIL PROTECTED] wrote: Now, I've been recommended to user CFCONTENT, the problem with CFCONTENT is that it just spews out the content, so a PDF file (even if I specify the mime type) will come not come out as a PDF file, but some garbled text. What MIME type are you using for PDFs? What you describe works perfectly for me. You could also try using CF directory mappings - these will prevent anyone directly accessing the files if you point them outside the Web root directory. Rob Keniger [EMAIL PROTECTED] __ __ big bang solutions http://www.bigbang.net.au p +61 7 3311 2733 f +61 7 3311 2744 __ __ -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C0297B.7F2629C8 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: Protecting Content / content leeching... A CF = method?/TITLE /HEAD BODY PFONT SIZE=3D2Rob, thanks for the feedback./FONT /P PFONT SIZE=3D2For PDF files I am using the standard MIME = types./FONT /P PFONT SIZE=3D2Here is my code./FONT /P PFONT SIZE=3D2lt;cfcontent type=3Dquot;application/pdfquot; = file=3Dquot;F:\projectdata\1\1\test.pdfquot; = deletefile=3Dquot;Noquot;gt;/FONT /P PFONT SIZE=3D2You can go to /FONT BRFONT SIZE=3D2A = HREF=3D"http://www.edificium.com/imagetest/getstuff.cfm?bob=3Dpdf" = TARGET=3D"_blank"http://www.edificium.com/imagetest/getstuff.cfm?bob=3D= pdf/A to see the (awful mess of a) result/FONT /P BR PFONT SIZE=3D2On the second part of your message, if I do use the = CF directory mappings, aren't I suddenly unable to user thenbsp; = lt;img src=3Dquot;...quot;gt; tag - is there a work = around?/FONT/P PFONT SIZE=3D2Thanks fo ryou help/FONT BRFONT SIZE=3D2Nadir/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Rob Keniger [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Thursday, September 28, 2000 12:48 AM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: Re: Protecting Content / content = leeching... A CF method?/FONT /P BR PFONT
Re: HeadHunters?
I get those too. They were especially heavy on my first week on the job here, but I still occasionally get a call or email... I have no idea where they get my name. Jamie (I know I've had a long week when I look at the subject line and think "Why is CF-TALK talking about a Front 242 song?") -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, September 29, 2000 9:06 AM Subject: Re: HeadHunters? We have been getting that *and* headhunters are also calling our company up trying to get us to hire people completely unrelated to anything we do. Go figure ... Todd Ashworth - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:56 AM Subject: RE: HeadHunters? | Yes, I am getting them to and haven't even sent out any apps or feelers. | | Larry Juncker | Senior Cold Fusion Programmer | Heartland Internet | | -Original Message- | From: Robert Everland [mailto:[EMAIL PROTECTED]] | Sent: Thursday, September 28, 2000 1:55 PM | To: CF-Talk | Subject: HeadHunters? | | | Is anyone else magically getting job offers from headhunters who | know your name or is it just me? | | Robert Everland III | Web Developer | Dixon Ticonderoga --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: AutoNumbers and INSERTS
Hi Will, There are two real possibilities: 1) stick with autonumbering. Wrap your insert and a SELECT Max(ID) inside a single CFTRANSACTION. Vaguely ugly. 2) Create your own Primary Key. 2a) Create your own incremental ID from a separate table. Needs CFTANSACTION. 2b) Create an incremental key by first selecting the current Max ID. (see the FuseBox tag MaxID for this) Needs CFTRANSACTION. 2c) Create your own random key. Use CF's built-in uuid function, or make your own with randrange, dates, etc, in combination. Excellent if you deal with several replicas which are merged from time to time. Personally, I use CF_MaxID and CFTRANSACTION. Best of luck, Lee Bjork Borkman Bjork.Net - ColdFusion Tags by Bjork "W Luke" [EMAIL PROTECTED] wrote: Hi, I'm inserting a load of data into a Table of an Access Database. The ID field is generated by AutoNumber. As soon as the record has been inserted, I need to output what that ID was. How can I do this? Cheers Will... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
Well what I would do is make a coldfusion template up that called it from a location that was inaccessible from a webserver. That way you could have a log in and password and even have a database that tells it how many times someone can view it. Or have a date as to when it expires so they can be no leeching. bob Everland -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 9:37 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm kinda confused (hah!) but isn't it technically impossible to protect any content that the person can see? In order to see an image/pdf/text file it has to be downloaded - therefore it is accessable. There is no possible way to protect an image from being taken (SnagIT). or am i off subject? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 7:02 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm having trouble displaying the pdf in netscape it doesn't give me the navigational toolbar at the top of the document. Any ideas what would cause netscape to act this way? Thanks, Dave -Original Message- From: Hayes, David [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:54 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? FYI - It's working fine on my machine; acrobat reader loads and the pdf is displayed properly. -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:40 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? 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_01C0297B.7F2629C8 Content-Type: text/plain; charset="iso-8859-1" Rob, thanks for the feedback. For PDF files I am using the standard MIME types. Here is my code. cfcontent type="application/pdf" file="F:\projectdata\1\1\test.pdf" deletefile="No" You can go to http://www.edificium.com/imagetest/getstuff.cfm?bob=pdf to see the (awful mess of a) result On the second part of your message, if I do use the CF directory mappings, aren't I suddenly unable to user the img src="..." tag - is there a work around? Thanks fo ryou help Nadir -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 12:48 AM To: CF-Talk Subject: Re: Protecting Content / content leeching... A CF method? on 9/28/00 7:28 AM, Nadir Ait-Laoussine at [EMAIL PROTECTED] wrote: Now, I've been recommended to user CFCONTENT, the problem with CFCONTENT is that it just spews out the content, so a PDF file (even if I specify the mime type) will come not come out as a PDF file, but some garbled text. What MIME type are you using for PDFs? What you describe works perfectly for me. You could also try using CF directory mappings - these will prevent anyone directly accessing the files if you point them outside the Web root directory. Rob Keniger [EMAIL PROTECTED] __ __ big bang solutions http://www.bigbang.net.au p +61 7 3311 2733 f +61 7 3311 2744 __ __ -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C0297B.7F2629C8 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: Protecting Content / content leeching... A CF = method?/TITLE /HEAD BODY PFONT SIZE=3D2Rob, thanks for the feedback./FONT /P PFONT SIZE=3D2For PDF files I am using the standard MIME = types./FONT /P PFONT SIZE=3D2Here is my code./FONT /P PFONT SIZE=3D2lt;cfcontent type=3Dquot;application/pdfquot; = file=3Dquot;F:\projectdata\1\1\test.pdfquot; = deletefile=3Dquot;Noquot;gt;/FONT /P PFONT SIZE=3D2You can go to /FONT BRFONT SIZE=3D2A = HREF=3D"http://www.edificium.com/imagetest/getstuff.cfm?bob=3Dpdf" = TARGET=3D"_blank"http://www.edificium.com/imagetest/getstuff.cfm?bob=3D= pdf/A to see the (awful mess of a) result/FONT /P BR PFONT SIZE=3D2On the second part of your message, if I do use the = CF directory mappings, aren't I suddenly unable to user thenbsp; = lt;img
RE: HeadHunters?
The answer is quite simple. Would all the headhunters on the CF-Talk list please step forward. It is becoming a policy (in the UK) for Headhunters to specialise in one area and get to know the area enough to be able to talk in general terms about it. They even turn up to CFUG meetings and listen in/hand out business cards :) -- From: Todd Ashworth[SMTP:[EMAIL PROTECTED]] Sent: 29 September 2000 14:17 To: CF-Talk Subject: Re: HeadHunters? We have been getting that *and* headhunters are also calling our company up trying to get us to hire people completely unrelated to anything we do. Go figure ... Todd Ashworth - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:56 AM Subject: RE: HeadHunters? | Yes, I am getting them to and haven't even sent out any apps or feelers. | | Larry Juncker | Senior Cold Fusion Programmer | Heartland Internet | | -Original Message- | From: Robert Everland [mailto:[EMAIL PROTECTED]] | Sent: Thursday, September 28, 2000 1:55 PM | To: CF-Talk | Subject: HeadHunters? | | | Is anyone else magically getting job offers from headhunters who | know your name or is it just me? | | Robert Everland III | Web Developer | Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need some help here, unknown error SQL 7008N
James,
REXX is an IBM programming language (runs interpretative, not compiled),
and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc...
REXX is to those OS's as Basic is to DOS, yet has some parsing
power of perl.
Anyway, sound like the datatypes are incorrectly passed from your
SQL statements to the types of the database fields. (ie: if
ID is numeric remove the ' ' and/or the date fields are Date type,
then also remove the ' ', thus:
'#date#' becomes '#date# and
'#form.id#' becomes #form.id#
Hope this helps!
Jim
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 11:17 AM
To: CF-Talk
Subject: Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format.
--327729A9AA7CC339FC1F4ECE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I checked to see what the error meant and it said this:
SQL7008N REXX variable "variable" contains inconsistent data.
Cause: A variable that contained inconsistent data was passed to REXX.
The command cannot be processed.
Action: If the variable is an SQLDA, verify that the data and length
fields have been assigned correctly. If it is a REXX variable, verify
that the type of data is appropriate to the command where it is being
used.
What is a REXX varible anyway?
I checked my data types and lengths and they all check out. What could
be causing this error??? I am using AS/400 on the back-end.
cfquery name="NewRequest" datasource="OIMDBADM"
insert into oimdbadm.newreq (time, date, agency, reqtype,
requester, req_email, phone, due_date, title, descrip, id, assigned)
values ('#time#', '#date#', '#form.agency#', '#form.reqtype#',
'#form.requester#', '#form.req_email#', '#form.phone#',
'#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#',
'#form.assigned#')
/cfquery
--327729A9AA7CC339FC1F4ECE
Content-Type: text/x-vcard; charset=us-ascii;
name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
filename="jtaavon.vcf"
begin:vcard
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and
Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom
203;Baltimore;MD;21201;
fn:James Taavon
end:vcard
--327729A9AA7CC339FC1F4ECE--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ColdFusion Flash4
This is a multi-part message in MIME format. --=_NextPart_000_0002_01C02A2C.E10D5990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am wondering if there are ways to pass information between flash and coldfusion. I am thinking of using a login using flash with cf pages. Dominic --=_NextPart_000_0002_01C02A2C.E10D5990 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IigNAQaQCAAEAAABAAEAAQeQBgAI5AQAAADoAAEIgAcAGElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAgACAAEGgAMADgAAANAHCQAdAA8AMQUAQgEB A5AGAFwFAAAlCwACAAELACMAAAMAJgAACwApAAADADYAAB4AcAAB FENvbGRGdXNpb24gJiBGbGFzaDQAAgFxAAEWAcAqHByIlnnJe5XnEdSyzgAB Ag6NugEdDAEaU01UUDpET01JTklDQEdSRU5MQU5ELkNPTQsAAQ4AQAAG DgDuIgUcKsABAgEKDgEYAColP7coXtQRqM4AAQIOjbjCgAAACwAfDgECAQkQ AQAAAP8AAAD7SAEAAExaRnUbmOZtAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj aArAc/BldDAgBxMCgwBQEGZYcHJxDlAQ330KgXZJCJB3awuAZDQMYGMHAFALAwu1IEkgYW2cIHcC IASBC4BnIAaQaCB0aASQZRYQF1F3xGF5BCB0byAKsAQRSwuAAhByAMB0aQIgICpiETB3CeEgDvFz aIsWEBSwIAjhZGZ1AJB9AiAuFfQXIAuAFJEW0G+nFwAawRbBYSAJAGcLgH8cNRnUA/AXIBpgFwAK sGe9B5AuCqIKhAqBEgMyFNB9HtNEA3ALgA3gHsQUEQABIXAACwABgAggBgAAwEYA A4UDAAOACCAGAADARgAQhQMAB4AIIAYAAMAA AABGAFKFAAAnagEAHgAJgAggBgAAwEYAVIUAAAEEOS4w AB4ACoAIIAYAAMBGADaFAAABAQAeAAuACCAGAADA RgA3hQAAAQEAHgAMgAggBgAAwEYAOIUAAAEB AAsADYAIIAYAAMBGAIKFAAABCwA6gAggBgAAwAAA AEYADoUDADyACCAGAADARgARhQMAPYAIIAYA AMBGABiFCwBSgAggBgAAwEYABoUDAFOA CCAGAADARgABhQIB+A8BEColP7coXtQRqM4AAQIOjbgC AfoPAQAAABAqJT+3KF7UEajOAAECDo24AgH7DwEAAACOADihuxAF5RAaobsIACsq VsIAAFBTVFBSWC5ETEwAAE5JVEH5v7gBAKoAN9luRDpcV0lOTlRcUHJvZmlsZXNc ZGpkbFxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91 dGxvb2sucHN0AwD+DwUDAA00/TcAAAIBfwABNDxORUJCS0lNT0NLQ0VETkxK S0ZPR0VFRkpDQkFBLmRvbWluaWNAZ3JlbmxhbmQuY29tPgADAAYQPT5xiAMABxB4AwAQEAAA AAADABEQAB4ACBABZQAAAElBTVdPTkRFUklOR0lGVEhFUkVBUkVXQVlTVE9QQVNTSU5G T1JNQVRJT05CRVRXRUVORkxBU0hBTkRDT0xERlVTSU9OSUFNVEhJTktJTkdPRlVTSU5HQUxPR0lO VVNJTkdGTEEAwQE= --=_NextPart_000_0002_01C02A2C.E10D5990-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion Flash4
yes you can. you might want to join the flashcoders list at : http://chattyfig.figleaf.com/ the guy you want to e-mail in particular is Brandon Hall. He also maintains that list and server at figleaf. ~Simon -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 9:50 AM To: CF-Talk Subject: ColdFusion Flash4 This is a multi-part message in MIME format. --=_NextPart_000_0002_01C02A2C.E10D5990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am wondering if there are ways to pass information between flash and coldfusion. I am thinking of using a login using flash with cf pages. Dominic --=_NextPart_000_0002_01C02A2C.E10D5990 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IigNAQaQCAAEAAABAAEAAQeQBgAI5AQAAADoAAEIgAcAGElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAgACAAEGgAMADgAAANAHCQAdAA8AMQUAQgEB A5AGAFwFAAAlCwACAAELACMAAAMAJgAACwApAAADADYAAB4AcAAB FENvbGRGdXNpb24gJiBGbGFzaDQAAgFxAAEWAcAqHByIlnnJe5XnEdSyzgAB Ag6NugEdDAEaU01UUDpET01JTklDQEdSRU5MQU5ELkNPTQsAAQ4AQAAG DgDuIgUcKsABAgEKDgEYAColP7coXtQRqM4AAQIOjbjCgAAACwAfDgECAQkQ AQAAAP8AAAD7SAEAAExaRnUbmOZtAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj aArAc/BldDAgBxMCgwBQEGZYcHJxDlAQ330KgXZJCJB3awuAZDQMYGMHAFALAwu1IEkgYW2cIHcC IASBC4BnIAaQaCB0aASQZRYQF1F3xGF5BCB0byAKsAQRSwuAAhByAMB0aQIgICpiETB3CeEgDvFz aIsWEBSwIAjhZGZ1AJB9AiAuFfQXIAuAFJEW0G+nFwAawRbBYSAJAGcLgH8cNRnUA/AXIBpgFwAK sGe9B5AuCqIKhAqBEgMyFNB9HtNEA3ALgA3gHsQUEQABIXAACwABgAggBgAAwEYA A4UDAAOACCAGAADARgAQhQMAB4AIIAYAAMAA AABGAFKFAAAnagEAHgAJgAggBgAAwEYAVIUAAAEEOS4w AB4ACoAIIAYAAMBGADaFAAABAQAeAAuACCAGAADA RgA3hQAAAQEAHgAMgAggBgAAwEYAOIUAAAEB AAsADYAIIAYAAMBGAIKFAAABCwA6gAggBgAAwAAA AEYADoUDADyACCAGAADARgARhQMAPYAIIAYA AMBGABiFCwBSgAggBgAAwEYABoUDAFOA CCAGAADARgABhQIB+A8BEColP7coXtQRqM4AAQIOjbgC AfoPAQAAABAqJT+3KF7UEajOAAECDo24AgH7DwEAAACOADihuxAF5RAaobsIACsq VsIAAFBTVFBSWC5ETEwAAE5JVEH5v7gBAKoAN9luRDpcV0lOTlRcUHJvZmlsZXNc ZGpkbFxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91 dGxvb2sucHN0AwD+DwUDAA00/TcAAAIBfwABNDxORUJCS0lNT0NLQ0VETkxK S0ZPR0VFRkpDQkFBLmRvbWluaWNAZ3JlbmxhbmQuY29tPgADAAYQPT5xiAMABxB4AwAQEAAA AAADABEQAB4ACBABZQAAAElBTVdPTkRFUklOR0lGVEhFUkVBUkVXQVlTVE9QQVNTSU5G T1JNQVRJT05CRVRXRUVORkxBU0hBTkRDT0xERlVTSU9OSUFNVEhJTktJTkdPRlVTSU5HQUxPR0lO VVNJTkdGTEEAwQE= --=_NextPart_000_0002_01C02A2C.E10D5990-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format.
--F68D756517EC607E868C5C20
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Jim,
Weird. While I would never do this, I decided to drop and re-create the
table since it was only 12 columns. After I did that, it worked like a
champ. Anyway, thanks for the tip, I will keep it in mind for the
future.
James
"Reilly, Jim" wrote:
James,
REXX is an IBM programming language (runs interpretative, not compiled),
and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc...
REXX is to those OS's as Basic is to DOS, yet has some parsing
power of perl.
Anyway, sound like the datatypes are incorrectly passed from your
SQL statements to the types of the database fields. (ie: if
ID is numeric remove the ' ' and/or the date fields are Date type,
then also remove the ' ', thus:
'#date#' becomes '#date# and
'#form.id#' becomes #form.id#
Hope this helps!
Jim
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 11:17 AM
To: CF-Talk
Subject: Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format.
--327729A9AA7CC339FC1F4ECE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I checked to see what the error meant and it said this:
SQL7008N REXX variable "variable" contains inconsistent data.
Cause: A variable that contained inconsistent data was passed to REXX.
The command cannot be processed.
Action: If the variable is an SQLDA, verify that the data and length
fields have been assigned correctly. If it is a REXX variable, verify
that the type of data is appropriate to the command where it is being
used.
What is a REXX varible anyway?
I checked my data types and lengths and they all check out. What could
be causing this error??? I am using AS/400 on the back-end.
cfquery name="NewRequest" datasource="OIMDBADM"
insert into oimdbadm.newreq (time, date, agency, reqtype,
requester, req_email, phone, due_date, title, descrip, id, assigned)
values ('#time#', '#date#', '#form.agency#', '#form.reqtype#',
'#form.requester#', '#form.req_email#', '#form.phone#',
'#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#',
'#form.assigned#')
/cfquery
--327729A9AA7CC339FC1F4ECE
Content-Type: text/x-vcard; charset=us-ascii;
name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
filename="jtaavon.vcf"
begin:vcard
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and
Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom
203;Baltimore;MD;21201;
fn:James Taavon
end:vcard
--327729A9AA7CC339FC1F4ECE--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--F68D756517EC607E868C5C20
Content-Type: text/x-vcard; charset=us-ascii;
name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
filename="jtaavon.vcf"
begin:vcard
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201;
fn:James Taavon
end:vcard
--F68D756517EC607E868C5C20--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Outlook information - Success
Thanks for the help so far. I downloaded digital dashboard, but I am not running NT2K yet, so I can't implement it to the general populace. HOWEVER, there is a page of code in the digital dashboard that will retrieve your Outlook email. I just copied the code onto a ColdFusion page and it worked instantly. I did not change 1 single line of the code. What the code does is query the system for the Outlook mail information, and use that to open the mailbox. Security is my next investigation. If two people share a computer I am not sure what will happen. If anyone wants the code to do this, just email me. It is very short. Tim Tim Claremont Xerox Corporation 800 Phillips Road 111-06J Webster, NY 14580 Phone: 716-265-8573 Pager: 716-239-3514 -Original Message- From: seth ward [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:52 AM To: CF-Talk Subject: RE: Getting Outlook information FWIW, you can do this stuff in ASP - there's something called a Digital Dashboard, with pre-developed applications to access the Inbox, Calendar, COntacts etc. You could combine ASP pages with Coldfusion if that's possible in your case. http://www.microsoft.com/solutions/km/digitaldashboard.htm Seth Ward -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 27 September 2000 18:13 To: CF-Talk Subject: Getting Outlook information My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarlistsbodylists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: INSERT INTO with loop problem
Thanks. I tried it. It didn't work.
I still get:
Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
- Original Message -
From: "DeVoil, Nick" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 5:09 AM
Subject: RE: INSERT INTO with loop problem
Michael
Have you tried using the temporary variables in your INTO clause
as well as in your VALUES clause?
Nick
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 7:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: INSERT INTO with loop problem
Hi!
I thoughtr that it worked, butr it didn't.
(I had forgot to save my changes)
I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 4:54 PM
Subject: RE: INSERT INTO with loop problem
It might be the single quotes around everything; I'm assuming some of the
fields you reference in your "INSERT INTO", such as ID, are numeric.
Also, make sure you have a space after Projects; you show
Projects(ProjectID,...
What behavior and/or error messages are you getting?
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
--
--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion Flash4
Are you going to be making your flash pages in Flash or Director? I'm guessing director I have run into problems using flash/director and transporting data with them (not just with cold fusion, this is more of a universal thing). For example, i've never been able to pass variables through flash. Your best option would be to make it out of director (unless you perfer fs to director lingo) I'm not sure exactily how to do this but it would be something like this (in director) Your form frame put "enter your username" into field "username" put "enter your password" into field "password" after you submit you take those two feild variables and put them on a link structure like this global x, y put feild "password" into x (arrrh! i allready forgot the syntax for putting field data into a variable, but you need to do that) put field "username" into y a href = "http://www.mypage.com/coldfusionsubmit.cfm?username=ypassword=x" or something to that extent never tried it, worth a shot -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 8:50 AM To: CF-Talk Subject: ColdFusion Flash4 This is a multi-part message in MIME format. --=_NextPart_000_0002_01C02A2C.E10D5990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am wondering if there are ways to pass information between flash and coldfusion. I am thinking of using a login using flash with cf pages. Dominic --=_NextPart_000_0002_01C02A2C.E10D5990 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IigNAQaQCAAEAAABAAEAAQeQBgAI5AQAAADoAAEIgAcAGElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAgACAAEGgAMADgAAANAHCQAdAA8AMQUAQgEB A5AGAFwFAAAlCwACAAELACMAAAMAJgAACwApAAADADYAAB4AcAAB FENvbGRGdXNpb24gJiBGbGFzaDQAAgFxAAEWAcAqHByIlnnJe5XnEdSyzgAB Ag6NugEdDAEaU01UUDpET01JTklDQEdSRU5MQU5ELkNPTQsAAQ4AQAAG DgDuIgUcKsABAgEKDgEYAColP7coXtQRqM4AAQIOjbjCgAAACwAfDgECAQkQ AQAAAP8AAAD7SAEAAExaRnUbmOZtAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj aArAc/BldDAgBxMCgwBQEGZYcHJxDlAQ330KgXZJCJB3awuAZDQMYGMHAFALAwu1IEkgYW2cIHcC IASBC4BnIAaQaCB0aASQZRYQF1F3xGF5BCB0byAKsAQRSwuAAhByAMB0aQIgICpiETB3CeEgDvFz aIsWEBSwIAjhZGZ1AJB9AiAuFfQXIAuAFJEW0G+nFwAawRbBYSAJAGcLgH8cNRnUA/AXIBpgFwAK sGe9B5AuCqIKhAqBEgMyFNB9HtNEA3ALgA3gHsQUEQABIXAACwABgAggBgAAwEYA A4UDAAOACCAGAADARgAQhQMAB4AIIAYAAMAA AABGAFKFAAAnagEAHgAJgAggBgAAwEYAVIUAAAEEOS4w AB4ACoAIIAYAAMBGADaFAAABAQAeAAuACCAGAADA RgA3hQAAAQEAHgAMgAggBgAAwEYAOIUAAAEB AAsADYAIIAYAAMBGAIKFAAABCwA6gAggBgAAwAAA AEYADoUDADyACCAGAADARgARhQMAPYAIIAYA AMBGABiFCwBSgAggBgAAwEYABoUDAFOA CCAGAADARgABhQIB+A8BEColP7coXtQRqM4AAQIOjbgC AfoPAQAAABAqJT+3KF7UEajOAAECDo24AgH7DwEAAACOADihuxAF5RAaobsIACsq VsIAAFBTVFBSWC5ETEwAAE5JVEH5v7gBAKoAN9luRDpcV0lOTlRcUHJvZmlsZXNc ZGpkbFxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91 dGxvb2sucHN0AwD+DwUDAA00/TcAAAIBfwABNDxORUJCS0lNT0NLQ0VETkxK S0ZPR0VFRkpDQkFBLmRvbWluaWNAZ3JlbmxhbmQuY29tPgADAAYQPT5xiAMABxB4AwAQEAAA AAADABEQAB4ACBABZQAAAElBTVdPTkRFUklOR0lGVEhFUkVBUkVXQVlTVE9QQVNTSU5G T1JNQVRJT05CRVRXRUVORkxBU0hBTkRDT0xERlVTSU9OSUFNVEhJTktJTkdPRlVTSU5HQUxPR0lO VVNJTkdGTEEAwQE= --=_NextPart_000_0002_01C02A2C.E10D5990-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: INSERT INTO with loop problem
You don't need single quotes around your field names portion ( use
Description#lang.abrev# rather than 'Description#lang.abrev#') and put a
comma after Done in your fields list.
I would also recommend that you output the SQL statement you are creating to
make sure it looks right, all the commas and single quotes.
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 9:16 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
Hi!
I thoughtr that it worked, butr it didn't.
(I had forgot to save my changes)
I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 4:54 PM
Subject: RE: INSERT INTO with loop problem
It might be the single quotes around everything; I'm assuming some of the
fields you reference in your "INSERT INTO", such as ID, are numeric.
Also, make sure you have a space after Projects; you show
Projects(ProjectID,...
What behavior and/or error messages are you getting?
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
--
--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
...array
I have a little project, i'm thinking I should use an array, but i've never used an array in cold fusion. I have in other langs though. If you check out http://collab.lightrodsoft.com/lrscheck/ (you dont have to enter in real information, it doesnt write to a db) it is a series of questionairs. This is what I'm thinking each time someone guesses an answer it goes into an array myguesses = [a,b,a,c,d] at the end it gets compared to the list of answeres in the db theansweres = [a,b,c,a,b] Now i need to compare these two to see how many match. How do i go about doing this in cold fusion? Does anyone have any good examples of doing questionares in CF and have some suggestions to how to store the q/a in the db? Thanks, Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Linux, MySql, NT, Access - which?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It is fairly easy to export access into a csv format and mysql will gladly import that (and rather quickly too). You just need to write the sql to create the tables matching access schemas and off you go. BTW the relation (?) view of your database (in access) is your friend when it comes to PK/FK... Cheers, Mike - -Original Message- From: W Luke [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 6:30 AM To: CF-Talk Subject:Re: Linux, MySql, NT, Access - which? - - Original Message - From: "Ryan" [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Friday, September 29, 2000 2:00 PM Subject: Re: Linux, MySql, NT, Access - which? At 18:53 9/29/00 +1000, you wrote: on 9/29/00 6:37 PM, W Luke at [EMAIL PROTECTED] wrote: I have use of an excellent server in Telehouse Docklands that's running Linux; so my question to you is, should I go for Linux and MySql or stick with the ease (IMO) of NT and Access? Incidentally if I go over to MySql, is there an easy and bug-free way of converting Access Databases to MySql? I have some vb code you can copy and paste into a module (or something..) in access and then run it, it will generate a text file with SQL statements to create the tables in SQL, and I think it puts the data in there, too. Had to modify it a bit to get it working, but it works now. Let me know if you want it. Sounds dead handy - would love a look, thanks. Will - -- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOdSl7HYFmKomMlANEQIo3gCdEimqOLSwdNGInRorKUXe9xvwekUAn3sI kdsWWfufUo9IqpySjLw6zq4E =HxVE -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Client Session variables?
Dear All, What is the different between Client Session variables? From Rif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need some help here, unknown error SQL 7008N
Jim:
A couple of points --
"Reilly, Jim" wrote:
James,
REXX is an IBM programming language (runs interpretative, not compiled),
and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc...
REXX is to those OS's as Basic is to DOS, yet has some parsing
power of perl.
Actually, there are REXX compilers for VM (since 1989), MVS and PC
platforms (yes, I'm a longtime user of REXX). However, more interesting
is why James is getting this error. I know nothing about the AS/400
really, or the DBs that run on it.
I am a big user of DB/2 on the mainframe. DB/2 comes with RxSQL, which
allows you to write SQL apps against the DB in the REXX language. The
only way I can think of this error occurring on the MF is to execute an
RxSQL program that had some sort of problem, which is what SQLDA (SQL
data area) is complaining about, and ASSume that there is a comparable
situation on his AS/400.
From the code James has below, it looks like a standard CF insert, I
ASSume (again) the connection to the DB is either via a native or ODBC
driver. As such, this error should not be received. James' best bet
would be to speak to the DBA.
-Gerry
Gerard T. Pauline
Mgr, Internet/DB Applictions
Computer Systems, DoIT
Pace University
Anyway, sound like the datatypes are incorrectly passed from your
SQL statements to the types of the database fields. (ie: if
ID is numeric remove the ' ' and/or the date fields are Date type,
then also remove the ' ', thus:
'#date#' becomes '#date# and
'#form.id#' becomes #form.id#
Hope this helps!
Jim
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 11:17 AM
To: CF-Talk
Subject: Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format.
--327729A9AA7CC339FC1F4ECE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I checked to see what the error meant and it said this:
SQL7008N REXX variable "variable" contains inconsistent data.
Cause: A variable that contained inconsistent data was passed to REXX.
The command cannot be processed.
Action: If the variable is an SQLDA, verify that the data and length
fields have been assigned correctly. If it is a REXX variable, verify
that the type of data is appropriate to the command where it is being
used.
What is a REXX varible anyway?
I checked my data types and lengths and they all check out. What could
be causing this error??? I am using AS/400 on the back-end.
cfquery name="NewRequest" datasource="OIMDBADM"
insert into oimdbadm.newreq (time, date, agency, reqtype,
requester, req_email, phone, due_date, title, descrip, id, assigned)
values ('#time#', '#date#', '#form.agency#', '#form.reqtype#',
'#form.requester#', '#form.req_email#', '#form.phone#',
'#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#',
'#form.assigned#')
/cfquery
--327729A9AA7CC339FC1F4ECE
Content-Type: text/x-vcard; charset=us-ascii;
name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
filename="jtaavon.vcf"
begin:vcard
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and
Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom
203;Baltimore;MD;21201;
fn:James Taavon
end:vcard
--327729A9AA7CC339FC1F4ECE--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: INSERT INTO with loop problem
What do you meen by outputing the SQL statements?
Here's where I'm at now:
CFquery datasource="CSM"
INSERT INTO Projects (ProjectID,ID,Done
cfloop
query="lang",Description#lang.Abrev#,details#lang.Abrev#,/cfloop
Image,FormatImage)
VALUES(#ProjectID#,#ID#,#Done#,
cfloop query="lang"
CFSET tempdesc=evaluate('Description#lang.Abrev#')
CFSET tempdet=evaluate('details#lang.Abrev#')
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 11:23 AM
Subject: RE: INSERT INTO with loop problem
You don't need single quotes around your field names portion ( use
Description#lang.abrev# rather than 'Description#lang.abrev#') and put a
comma after Done in your fields list.
I would also recommend that you output the SQL statement you are creating
to
make sure it looks right, all the commas and single quotes.
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 9:16 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
Hi!
I thoughtr that it worked, butr it didn't.
(I had forgot to save my changes)
I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 4:54 PM
Subject: RE: INSERT INTO with loop problem
It might be the single quotes around everything; I'm assuming some of
the
fields you reference in your "INSERT INTO", such as ID, are numeric.
Also, make sure you have a space after Projects; you show
Projects(ProjectID,...
What behavior and/or error messages are you getting?
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Email Trigger?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Check out the features of sendmail (get the bat book), via the aliases file, you can pipe email to a program for a particular user. That script can do whatever your next step is. HTH Mike - -Original Message- From: Eric Dawson [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 2:34 PM To: CF-Talk Subject:Re: Email Trigger? what did you want to trigger? There may be other ways to trigger the action you need. I don't know how you would receive the pop mail except to schedule pickup of the mail. Ideas? Eric From: Karl Simanonok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Email Trigger? Date: Thu, 28 Sep 2000 09:55:54 -0700 No, I do not want email sent at a certain time or upon a user action. I want a Cold Fusion template to be executed when I send email to an email address. It can be an email account on the same server if that helps (you'd think so). I know I can do it by using a scheduled task to check for new email at specified intervals, but scheduled tasks are frequently unreliable and either I'd have to have very short intervals of checking or I'd have to be content with waiting (and hoping) for the scheduled task to run. So intstead I would like to be able to trigger a CF template some other way, using email. Maybe there's a CFX out there for this purpose, or some obscure CF function that I haven't heard of using this way? Regards, Karl Simanonok __ ___ 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOdSp9nYFmKomMlANEQL4LwCgv28Qd+XxIcRA7I6EkePcacx5mp0An0iF VQkyqNAiVHt28w6xlYqiFQ+s =4qDA -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ...array
Can't you just use a list and compare the two? On Fri, 29 Sep 2000, Gavin Myers spake thusly: I have a little project, i'm thinking I should use an array, but i've never used an array in cold fusion. I have in other langs though. If you check out http://collab.lightrodsoft.com/lrscheck/ (you dont have to enter in real information, it doesnt write to a db) it is a series of questionairs. This is what I'm thinking each time someone guesses an answer it goes into an array myguesses = [a,b,a,c,d] at the end it gets compared to the list of answeres in the db theansweres = [a,b,c,a,b] Now i need to compare these two to see how many match. How do i go about doing this in cold fusion? Does anyone have any good examples of doing questionares in CF and have some suggestions to how to store the q/a in the db? Thanks, Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ColdFusion SP2
I wish I knew! Share your secrets!! :-) At 02:51 PM 9/28/00 +0100, James Smith wrote: I'll bet you are running NT or Win2K. You loose your bet, I have win98. It crashes Win98 very quickly. It has the same resource leaks under NT, but NT is just better at handling it. Not mine it doesn't -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Outlook information - Success
Its been about a year since I played with MS Digital Dashboard. I think the is a ActiveX component. It only work if 1. Outlook is install on that client computer. 2. Outlook has been configured ActiveX component only show what outlook can show. From Rif -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 15:10 To: CF-Talk Subject: RE: Getting Outlook information - Success Thanks for the help so far. I downloaded digital dashboard, but I am not running NT2K yet, so I can't implement it to the general populace. HOWEVER, there is a page of code in the digital dashboard that will retrieve your Outlook email. I just copied the code onto a ColdFusion page and it worked instantly. I did not change 1 single line of the code. What the code does is query the system for the Outlook mail information, and use that to open the mailbox. Security is my next investigation. If two people share a computer I am not sure what will happen. If anyone wants the code to do this, just email me. It is very short. Tim Tim Claremont Xerox Corporation 800 Phillips Road 111-06J Webster, NY 14580 Phone: 716-265-8573 Pager: 716-239-3514 -Original Message- From: seth ward [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:52 AM To: CF-Talk Subject: RE: Getting Outlook information FWIW, you can do this stuff in ASP - there's something called a Digital Dashboard, with pre-developed applications to access the Inbox, Calendar, COntacts etc. You could combine ASP pages with Coldfusion if that's possible in your case. http://www.microsoft.com/solutions/km/digitaldashboard.htm Seth Ward -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 27 September 2000 18:13 To: CF-Talk Subject: Getting Outlook information My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarlistsbodylists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OMG!!!!!
Ditto. We have done lots of work with unicode, Chinese, Korean, Hebrew, Greek, Russian, etc. SQL 7 handles the data fine and CF has no problems interpreting it at all. The only issues we have ever ran into have been with Unicode and JavaScript, not CF. Mark Johnson The Unbound Bible Team www.unboundbible.org -Original Message- From: Gregory Gooden (Annex) [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 6:36 AM To: CF-Talk Subject: RE: OMG! Based on 3 different Japanese sites that we've been developing currently, we've run into ZERO issues with storing japanese characters into SQL 7, and doing standard searches, parsing, etc. with that text. I've seen UNICODE issues mentioned in this list, but we've certainly not run into any issues SO far (knock on wood).. Perhaps VERITY might present an interesting situation, but we're not using that, so can't comment on it. :) Gregory --- annex.com, Inc. - http://www.annex.com/ --- - If you EcoBuild it, they will come. - - http://www.ecobuilder.com/ - --- -Original Message- From: avex [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:21 PM To: CF-Talk Subject: Re: OMG! It's tricky but it is possible, But if all you your doing is outputting Japanese text from a database, or inserting Japanese text from a form submission into a database it works fine. hard coded text in your HTML also works fine. Hi...thanks for your reply. but i am confusedwhere is the actual problem with japanese? And yes I will just have people entering japanese into forms, submitting and have it go into an access 2000 database. And then later I have the japanese text displayed within normal cfoutputs and database queries. Do I need to do anything with access? Or SQL Server (because I intend to migrate everything to there soon). thanks chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Outlook information - Success
I'd like to look at it. From: "Claremont, Timothy S" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Getting Outlook information - Success Date: Fri, 29 Sep 2000 10:09:59 -0400 Thanks for the help so far. I downloaded digital dashboard, but I am not running NT2K yet, so I can't implement it to the general populace. HOWEVER, there is a page of code in the digital dashboard that will retrieve your Outlook email. I just copied the code onto a ColdFusion page and it worked instantly. I did not change 1 single line of the code. What the code does is query the system for the Outlook mail information, and use that to open the mailbox. Security is my next investigation. If two people share a computer I am not sure what will happen. If anyone wants the code to do this, just email me. It is very short. Tim Tim Claremont Xerox Corporation 800 Phillips Road 111-06J Webster, NY 14580 Phone: 716-265-8573 Pager: 716-239-3514 -Original Message- From: seth ward [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:52 AM To: CF-Talk Subject: RE: Getting Outlook information FWIW, you can do this stuff in ASP - there's something called a Digital Dashboard, with pre-developed applications to access the Inbox, Calendar, COntacts etc. You could combine ASP pages with Coldfusion if that's possible in your case. http://www.microsoft.com/solutions/km/digitaldashboard.htm Seth Ward -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 27 September 2000 18:13 To: CF-Talk Subject: Getting Outlook information My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarlistsbodylists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion SP2 -install issues
Point taken. We're signed up for full kits (require regular registration #) as well as update kits for SP2. Thanks - Date: Thu, 28 Sep 2000 09:27:23 -0400 From: "Al Musella, DPM" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: ColdFusion SP2 -install issues Message-ID: [EMAIL PROTECTED] I don't remember if SP1 worked this way or not, but my biggest request would be for EVERY new version of CF - be able to be installed without having installed a previous version. I ran into trouble once where my webserver died. I had to rebuild everything. I forget which version of CF it was, but it wouldn't install. I had to install the previous version first. Luckily I had CDs of many versions with me (the server is co-located an hour from my house). I installed the next most recent version, then tried to install the current version, and it still wasn't happy. I had to go back, unistall CF, then install an even older version, then the current version allowed me to install it. It was a big waste of time - while my webserver was down. It would have been much worse if I didn't have the previous cds with me. That may be an acceptable form of copy protection for a game, but not for a server product, where lost time is money. Al Musella, DPM President Musella Foundation For Brain Tumor Research Information virtualtrials.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: conditional where statement
Try
SELECT *
FROM Tbl
WHERE 0 = 1
CFIF parameterexists(id)
OR id = #id#
/CFIF
CFIF parameterexists(name)
OR name = #name#
/CFIF
is this correct or am i missing something?
select *
from tbl
where cfif isdefined(")
id = #id#
/cfif
or
cfif isdefined(")
name = #name#
/cfif
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ColdFusion SP2
I'll bet you are running NT or Win2K. You loose your bet, I have win98. It crashes Win98 very quickly. It has the same resource leaks under NT, but NT is just better at handling it. Not mine it doesn't How are you keeping it from crashing your Win98? What settings are you using? Mine regularly exhausts the GDI resources on my Win98 PC causes me to either crash outright or reboot to restore my GDI. I honestly don't know, if I did I would tell you but this is not a problem I have fixed, it is a problem I have never had so without providing a complete copy of my registry and all the settings for every program that may be conflicting there isn't a lot I can tell you. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: INSERT INTO with loop problem
I mean output to the page to verify what statement you're creating.
(It just occurs to me that your line breaks may be causing a problem; you
either need to use continuation characters on put the fields list and values
list stuff on single lines.)
CFOUTPUT
INSERT INTO Projects (ProjectID,ID,Done
cfloop
query="lang",Description#lang.Abrev#,details#lang.Abrev#,/cfloop
Image,FormatImage)
VALUES(#ProjectID#,#ID#,#Done#,
cfloop query="lang"
CFSET tempdesc=evaluate('Description#lang.Abrev#')
CFSET tempdet=evaluate('details#lang.Abrev#')
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/CFOUTPUT
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 9:38 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
What do you meen by outputing the SQL statements?
Here's where I'm at now:
CFquery datasource="CSM"
INSERT INTO Projects (ProjectID,ID,Done
cfloop
query="lang",Description#lang.Abrev#,details#lang.Abrev#,/cfloop
Image,FormatImage)
VALUES(#ProjectID#,#ID#,#Done#,
cfloop query="lang"
CFSET tempdesc=evaluate('Description#lang.Abrev#')
CFSET tempdet=evaluate('details#lang.Abrev#')
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 11:23 AM
Subject: RE: INSERT INTO with loop problem
You don't need single quotes around your field names portion ( use
Description#lang.abrev# rather than 'Description#lang.abrev#') and put a
comma after Done in your fields list.
I would also recommend that you output the SQL statement you are creating
to
make sure it looks right, all the commas and single quotes.
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 9:16 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
Hi!
I thoughtr that it worked, butr it didn't.
(I had forgot to save my changes)
I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 4:54 PM
Subject: RE: INSERT INTO with loop problem
It might be the single quotes around everything; I'm assuming some of
the
fields you reference in your "INSERT INTO", such as ID, are numeric.
Also, make sure you have a space after Projects; you show
Projects(ProjectID,...
What behavior and/or error messages are you getting?
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: combining SQL queries
CFQUERY NAME="GetSenderDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# /CFQUERY CFQUERY NAME="GetOrdererDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# /CFQUERY CFQUERY NAME="GetApproverDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# /CFQUERY Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How can I do this (Query external data source)?
Please pardon the lousy subject line. I did not know how to paraphrase what I need to do! I have an internal web page here at work that I made in coldfusion. I also have another page that I made for the real world. My external site has a table with a bunch of information that website visitors can enter information into. (It is a registry for old Pontiacs). I want to run a query on that external site that just returns the number of records in the registry table. Hence, Here on my internal web page (Actually the "Outlook Today" page) I just want a line that says "There are X records in your Pontiac Registry". The dilemma, as I see it, is querying a datasource that is not on my local coldfusion server. If I have to, I will add a new DSN to the server that points to the database out there on the internet. Is this possible? Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: INSERT INTO with loop problem
The commas inside your loop are going to cause problems. You have
cfloop,desc,details,/cfloop. Going through this loop will give you
doubled up commas - ,desc,details,,desc,details,,desc,details,
Dan
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 7:38 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
What do you meen by outputing the SQL statements?
Here's where I'm at now:
CFquery datasource="CSM"
INSERT INTO Projects (ProjectID,ID,Done
cfloop
query="lang",Description#lang.Abrev#,details#lang.Abrev#,/cfloop
Image,FormatImage)
VALUES(#ProjectID#,#ID#,#Done#,
cfloop query="lang"
CFSET tempdesc=evaluate('Description#lang.Abrev#')
CFSET tempdet=evaluate('details#lang.Abrev#')
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 11:23 AM
Subject: RE: INSERT INTO with loop problem
You don't need single quotes around your field names portion ( use
Description#lang.abrev# rather than 'Description#lang.abrev#') and put a
comma after Done in your fields list.
I would also recommend that you output the SQL statement you are creating
to
make sure it looks right, all the commas and single quotes.
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 9:16 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
Hi!
I thoughtr that it worked, butr it didn't.
(I had forgot to save my changes)
I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 4:54 PM
Subject: RE: INSERT INTO with loop problem
It might be the single quotes around everything; I'm assuming some of
the
fields you reference in your "INSERT INTO", such as ID, are numeric.
Also, make sure you have a space after Projects; you show
Projects(ProjectID,...
What behavior and/or error messages are you getting?
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:04 PM
To: CF-Talk
Subject: INSERT INTO with loop problem
Hi!
I used a CFQUERY to UPDATE a table and it works fine,
but I can't get it to work with an INSERT INTO.
I use the UPDATE instead of CFUPDATE beucause
of the loop. I couldn't get it to work at all with CFUPDATE.
Here it is:
CFquery datasource="CSM"
INSERT INTO Projects(ProjectID,ID,Donecfloop
query="lang",'Description#lang.abrev#','Details#lang.Abrev#',/cfloopImage
,FormatImage)
VALUES('#ProjectID#','#ID#','#Done#'
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
Here is the working UPDATE:
CFQUERY datasource="CSM"
UPDATE Projects
SET
cfloop query="lang"
CFSET tempdesc=evaluate("Description#lang.Abrev#")
CFSET tempdet=evaluate("details#lang.Abrev#")
Description#lang.Abrev#='#tempdesc# ',
Details#lang.Abrev#='#tempdet# ',
/cfloop
Done=#Done#,
Image='#Image#',
FormatImage='#formatImage#'
WHERE ProjectID=#FORM.ProjectID#
/cfquery
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: combining SQL queries
Why do you want to combin then ? -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 19:21 To: CF-Talk Subject: OT: combining SQL queries CFQUERY NAME="GetSenderDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# /CFQUERY CFQUERY NAME="GetOrdererDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# /CFQUERY CFQUERY NAME="GetApproverDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# /CFQUERY Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Getting Outlook information (Here is the code)
As I have been deluged with requests for the code...here it is...
?xml version="1.0" ?
- WebPart
TitleInbox/Title
DescriptionUses outlook view control to view your inbox/Description
- Content
- ![CDATA[
table border="0" cellpadding="0" cellspacing="0"
style="width:100%;"
tr
td nowrap valign="bottom"span class="topBarSpan"
span id="spanMessages1_WPQ_"
onclick="MyMessages_WPQ_.folder='Inbox';MyMessages_WPQ_.view='Messages with
AutoPreview'; changeMessagesTab_WPQ_(this);"
style="font-weight:bold"Messages/span
span id="spanMessages2_WPQ_"
onclick="MyMessages_WPQ_.folder='Inbox';MyMessages_WPQ_.view='Unread
Messages'; changeMessagesTab_WPQ_(this);"Unread/span
span id="spanMessages3_WPQ_"
onclick="MyMessages_WPQ_.folder='Drafts';MyMessages_WPQ_.view='Messages with
AutoPreview'; changeMessagesTab_WPQ_(this);"Drafts/span
span id="spanMessages4_WPQ_"
onclick="MyMessages_WPQ_.folder='Sent Items';MyMessages_WPQ_.view='Messages
with AutoPreview'; changeMessagesTab_WPQ_(this);"Sent Items/span
/span
/td
td width="8%" align="left" valign="bottom"
span id="NewItem_WPQ_" style="cursor:hand"
onClick="new_Message_WPQ_()"
nbsp;nbsp;New
/span
/td
td width="8%" align="left" valign="bottom"
span id="DelItem_WPQ_" style="cursor:hand"
onClick="delete_Message_WPQ_()"
nbsp;nbsp;Delete
/span
/td
/tr
/table
object ID="MyMessages_WPQ_"
CLASSID="CLSID:0006F063---C000-0046"
style="width:100%;height:100%"
codebase="http://activex.microsoft.com/activex/controls/office/outlctlx.CAB#
ver=9,0,2814"
param NAME="View" VALUE
param NAME="Folder" VALUE="Inbox"
param NAME="Namespace" VALUE="MAPI"
param NAME="Restriction" VALUE=""
param NAME="DeferUpdate" VALUE="0"
/object
/body
script language="javascript"
function changeMessagesTab_WPQ_(currentdiv)
{
spanMessages1_WPQ_.style.fontWeight="normal"
spanMessages2_WPQ_.style.fontWeight="normal"
spanMessages3_WPQ_.style.fontWeight="normal"
spanMessages4_WPQ_.style.fontWeight="normal"
currentdiv.style.fontWeight="bold"
}
/script
script language = "vbscript"
sub new_Message_WPQ_()
MyMessages_WPQ_.NewDefaultItem
end sub
sub delete_Message_WPQ_()
MyMessages_WPQ_.Delete
end sub
/script
]]
/Content
ContentLink /
ContentType0/ContentType
IsVisible1/IsVisible
AllowRemove1/AllowRemove
HasFrame1/HasFrame
AllowMinimize1/AllowMinimize
FrameState0/FrameState
RequiresIsolation0/RequiresIsolation
RefreshInterval0/RefreshInterval
CacheBehavior0/CacheBehavior
CacheTimeout0/CacheTimeout
Width /
Height300px/Height
DetailLink /
CustomizationLink /
XSL /
XSLLink /
Namespace /
LastModifiedSat, 24 Jun 2000 23:10:17 GMT/LastModified
IsIncluded1/IsIncluded
MasterPartLink /
PartOrder0/PartOrder
PartStorage /
Zone3/Zone
/WebPart
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF and Apache on Windows NT
We're running Apache on NT with CF Enterprise with 7 million hits per year on our intranet. Works great. Tom At 09:40 PM 9/28/00, you wrote: Does anyone have a production-level application running on Apache using CF (and Spectra)?I am investigating using it, but the warnings for Win32 have me concerned. Switching to UNIX is not an option unfortunately, although I wish we could -- politics you know. TIA, Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
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_01C02A2A.BB0551EA Content-Type: text/plain; charset="iso-8859-1" Gavin, you are not confused, just off base. :) The issue is not to make a document not available to someone who can see it but to someone who cannot see it... Case in point... the img src="..." tag will let you know that a file is located at /a/b/file.jpg so you could go to the location bar and look for that image. You could get tricky and try to view other files located at that location... /a/b/anotherfile.jpg. For us, that is a problem. The img tag reveals a little too much information. So the concern is not so much the document itself, but rather the ability to figure out where it is located. It's been recommended to me to use CF mappings to substitue for that, problem is that CF mappings, as far as I know, do not work with the IMG tag, let alone the EMBED tag. So I am left with the CFCONTENT tag, problem with the content tag is that it takes over the entire screen. I've tried to embed it in a layer or IFRAME, but it still takes over the whole window. There are a few PERL scripts out there that "mask" the path to the file. So by typing www.mydomain.com/getstuff.cgi?image.jpg, the script would display the image but masking it's location (which in reality is not a web location, but a physical location on the web server [c:\...]) This works well except that all the scripts that I have tried choke (by that I mean render only part of) the file. regardless of the MIME type. I think the problem is that those scripts were written on UNIX, and we are on WIN2K. So that is where we are. Note that the last option (the PERL option) is still not exactly what we are looking for because of 1. security problems with CGI scripts in general 2. it does not work with the IMG tag. Nadir -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 9:37 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm kinda confused (hah!) but isn't it technically impossible to protect any content that the person can see? In order to see an image/pdf/text file it has to be downloaded - therefore it is accessable. There is no possible way to protect an image from being taken (SnagIT). or am i off subject? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 7:02 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm having trouble displaying the pdf in netscape it doesn't give me the navigational toolbar at the top of the document. Any ideas what would cause netscape to act this way? Thanks, Dave -Original Message- From: Hayes, David [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:54 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? FYI - It's working fine on my machine; acrobat reader loads and the pdf is displayed properly. -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:40 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? 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_01C0297B.7F2629C8 Content-Type: text/plain; charset="iso-8859-1" Rob, thanks for the feedback. For PDF files I am using the standard MIME types. Here is my code. cfcontent type="application/pdf" file="F:\projectdata\1\1\test.pdf" deletefile="No" You can go to http://www.edificium.com/imagetest/getstuff.cfm?bob=pdf to see the (awful mess of a) result On the second part of your message, if I do use the CF directory mappings, aren't I suddenly unable to user the img src="..." tag - is there a work around? Thanks fo ryou help Nadir -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 12:48 AM To: CF-Talk Subject: Re: Protecting Content / content leeching... A CF method? on 9/28/00 7:28 AM, Nadir Ait-Laoussine at [EMAIL PROTECTED] wrote: Now, I've been recommended to user CFCONTENT, the problem with CFCONTENT is that it just spews out the content, so a PDF file (even if I specify the mime type) will come not come out as a PDF file, but some garbled text. What MIME type are you using for PDFs? What you describe works perfectly for me. You could also try using CF directory mappings - these will prevent anyone directly accessing the files if you point them outside the Web root directory. Rob Keniger [EMAIL PROTECTED] __ __ big bang solutions http://www.bigbang.net.au
bye for a while :)
Dear everyone i'm off on my first vacation for a couple of years so i'll be unsubscribing for a while have fun with out me Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: bye for a while :)
have a good vacation :) ~Simon -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 11:32 AM To: CF-Talk Subject: bye for a while :) Dear everyone i'm off on my first vacation for a couple of years so i'll be unsubscribing for a while have fun with out me Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
"problem is that CF mappings, as far as I know, do not work with the IMG tag, let alone the EMBED tag" setup global variable with a mapping then use in the img tag, that works fine CFSET application.root_path="datanet" CFSET application.image_path="#application.root_path#/Images/" IMG name="menu" src="CFOUTPUT#application.image_path#//CFOUTPUTmenu.gif" width="600" height="65" border="0" usemap="#m_menu" and now i really am off :) Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: combining SQL queries
You can do this with the UNION operator in SQL. You write one CFQUERY, and the SQL inside does a UNION between three individual selects. If you want to be able to differentiate between the result sets, you would also select a constant, so it would look something like this: CFQUERY NAME="GetDetails" DATASOURCE="#datasource#" SELECT 'Sender' as DetType, UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# UNION SELECT 'Orderer' as DetType, UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# UNION SELECT 'Approver' as DetType, UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# /CFQUERY If you don't want to eliminate duplicates, you would use UNION ALL Bob P.S. Field types need to be compatible for this to work, but I am assuming they are in your case as the names are all the same. -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 2:21 PM To: CF-Talk Subject: OT: combining SQL queries CFQUERY NAME="GetSenderDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# /CFQUERY CFQUERY NAME="GetOrdererDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# /CFQUERY CFQUERY NAME="GetApproverDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# /CFQUERY Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: combining SQL queries
I think you mean this SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# AND UserNumber=#GetOrder.UserNumber# AND UserNumber=#GetOrder.ApprovalBy# Bare in mind that each row returned will have the UserName, FirstName, LastName, Email columns "Gene Kraybill" [EMAIL PROTECTED] on 09/29/2000 02:20:31 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc:(bcc: Jerry Tolentino/SIAC) Subject: OT: combining SQL queries CFQUERY NAME="GetSenderDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# /CFQUERY CFQUERY NAME="GetOrdererDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# /CFQUERY CFQUERY NAME="GetApproverDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# /CFQUERY Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
i get it now... okay to show an image but to mask the source it is coming from... well, this isn't totally secure but what about renaming each file to something like logo_aoighoaihgoaoo31905u3051.jpg welcome_apgaahha939393593595931.jpg hello_09q3570931209275029602.jpg contactus_3-699696969696.jpg even though they know where the files are coming from, if they dont have names like "Logo.jpg" they wouldn't be able to just guess the other files in there. the logo_ part of it helps the programmer to know what file it is.. but the wopitywoihwohgow.jpg part makes it almost impossible for someone to just guess it -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 10:34 AM To: CF-Talk Cc: Kristina Patterson; Michael Kilkelly Subject: RE: Protecting Content / content leeching... A CF method? 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_01C02A2A.BB0551EA Content-Type: text/plain; charset="iso-8859-1" Gavin, you are not confused, just off base. :) The issue is not to make a document not available to someone who can see it but to someone who cannot see it... Case in point... the img src="..." tag will let you know that a file is located at /a/b/file.jpg so you could go to the location bar and look for that image. You could get tricky and try to view other files located at that location... /a/b/anotherfile.jpg. For us, that is a problem. The img tag reveals a little too much information. So the concern is not so much the document itself, but rather the ability to figure out where it is located. It's been recommended to me to use CF mappings to substitue for that, problem is that CF mappings, as far as I know, do not work with the IMG tag, let alone the EMBED tag. So I am left with the CFCONTENT tag, problem with the content tag is that it takes over the entire screen. I've tried to embed it in a layer or IFRAME, but it still takes over the whole window. There are a few PERL scripts out there that "mask" the path to the file. So by typing www.mydomain.com/getstuff.cgi?image.jpg, the script would display the image but masking it's location (which in reality is not a web location, but a physical location on the web server [c:\...]) This works well except that all the scripts that I have tried choke (by that I mean render only part of) the file. regardless of the MIME type. I think the problem is that those scripts were written on UNIX, and we are on WIN2K. So that is where we are. Note that the last option (the PERL option) is still not exactly what we are looking for because of 1. security problems with CGI scripts in general 2. it does not work with the IMG tag. Nadir -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 9:37 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm kinda confused (hah!) but isn't it technically impossible to protect any content that the person can see? In order to see an image/pdf/text file it has to be downloaded - therefore it is accessable. There is no possible way to protect an image from being taken (SnagIT). or am i off subject? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 7:02 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? I'm having trouble displaying the pdf in netscape it doesn't give me the navigational toolbar at the top of the document. Any ideas what would cause netscape to act this way? Thanks, Dave -Original Message- From: Hayes, David [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:54 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? FYI - It's working fine on my machine; acrobat reader loads and the pdf is displayed properly. -Original Message- From: Nadir Ait-Laoussine [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:40 PM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? 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_01C0297B.7F2629C8 Content-Type: text/plain; charset="iso-8859-1" Rob, thanks for the feedback. For PDF files I am using the standard MIME types. Here is my code. cfcontent type="application/pdf" file="F:\projectdata\1\1\test.pdf" deletefile="No" You can go to http://www.edificium.com/imagetest/getstuff.cfm?bob=pdf to see the (awful mess of a) result On the second part of your message, if I do use the CF directory mappings, aren't I suddenly unable to user the img src="..." tag - is there a work around? Thanks fo ryou help Nadir -Original Message- From: Rob Keniger
Re: TO ALL: Request for ColdFusion SP2 Input
At 08:50 AM 9/27/00 , you wrote: ColdFusion Service Pack 2 is under construction, and I'd like to get your feedback on what you believe to be Must-Be-Fixed items. i know one of the items that makes me very uncomfortable is the apparent code incompatibility on the locking issues. i.e. code written for CF server 4.5.1 locking doesn't easily work on 4.0 and vice versa.. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: bye for a while :)
Have a nice hol Stew, I'll look after your server while you're away ;o) Neil - Original Message - From: Stewart McGowan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 4:32 PM Subject: bye for a while :) Dear everyone i'm off on my first vacation for a couple of years so i'll be unsubscribing for a while have fun with out me Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF and Apache on Windows NT
hmm... scary. - Original Message - From: "Tom Nunamaker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:30 AM Subject: Re: CF and Apache on Windows NT We're running Apache on NT with CF Enterprise with 7 million hits per year on our intranet. Works great. Tom At 09:40 PM 9/28/00, you wrote: Does anyone have a production-level application running on Apache using CF (and Spectra)?I am investigating using it, but the warnings for Win32 have me concerned. Switching to UNIX is not an option unfortunately, although I wish we could -- politics you know. TIA, Mary --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: TO ALL: Request for ColdFusion SP2 Input
To some this may seem trivial but, the PDF documentation HAS to get fixed. For many this is the only documentation that they have for 4.5.x and quite frankly, it sucks. It's not the content, it's the usability. In earlier versions, especially the 4.0.x series, the included and downloadable PDF documentation was thorough and well built. There were bookmarks, thumbnails, and the links all worked. Starting with CFAS 4.5 the PDF's have none of these, which makes them almost useless. "Hmmm, was CFREGISTRY on page 171 or 117? What page number is the end of tags and the beginning of functions? Why don't these darn bookmarks work!?" You get the picture. Not everyone uses Studio and many CF servers have the HTML documentation removed. If PDF was only supposed to be a supplement my opinion would be different but, for upgraders, purchasers of electronic distributions, or those who do not use Studio the PDF docs are all that they have. Unfortunately, Allaire's documentation has always had problems, whether it be incompleteness, inaccuracy, lateness, or terrible physical quality. The documentation group, Margaret et al., made great strides in the 4.0.x series but, things seem to be crumbling again. Regards, * Steve Bernard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: TO ALL: Request for ColdFusion SP2 Input
To some this may seem trivial but, the PDF documentation HAS to get fixed. For many this is the only documentation that they have for 4.5.x and quite frankly, it sucks. It's not the content, it's the usability. In earlier versions, especially the 4.0.x series, the included and downloadable PDF documentation was thorough and well built. There were bookmarks, thumbnails, and the links all worked. Starting with CFAS 4.5 the PDF's have none of these, which makes them almost useless. "Hmmm, was CFREGISTRY on page 171 or 117? What page number is the end of tags and the beginning of functions? Why don't these darn bookmarks work!?" You get the picture. Not everyone uses Studio and many CF servers have the HTML documentation removed. If PDF was only supposed to be a supplement my opinion would be different but, for upgraders, purchasers of electronic distributions, or those who do not use Studio the PDF docs are all that they have. Unfortunately, Allaire's documentation has always had problems, whether it be incompleteness, inaccuracy, lateness, or terrible physical quality. The documentation group, Margaret et al., made great strides in the 4.0.x series but, things seem to be crumbling again. Regards, * Steve Bernard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
JS does not work in Netscape but does in IE
Could you someone tell me what is wrong with this code.? It works fine in
IE, but not in Netscape.
What I have is two select boxes and want at least one to be something other
then null.
The form name is Mailme and the two select names are CurrentLoanInfo and
NewMortinfo
Thank you
David
function Validate()
{ var bIsValid = true;
if (bIsValid (!ValidCurrentLoanInfo() !ValidNewMortInfo()))
{ error(document.mailme.CurrentLoanInfo,"You must select a Current Loan
and/or a New Mortgage option.");
bIsValid = false;
}
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: INSERT INTO with loop problem
Thank you Dan Haley and David Hayes!!
You have saved my day!
By using the debugging tool, I have found where
the extra commas appeared. I also fixed a few
data type mismatch and it now works!
Just in case it interests anyone, here's the final working script:
CFquery datasource="CSM"
INSERT INTO Projects (ProjectID,ID,Donecfloop
query="lang",Description#lang.Abrev#,details#lang.Abrev#/cfloop,Image,For
matImage)
VALUES(#ProjectID#,#ID#,#Done#cfloop query="lang"CFSET
tempdesc=evaluate("Description#lang.Abrev#")CFSET
tempdet=evaluate("details#lang.Abrev#"),'#tempdesc# ','#tempdet#
'/cfloop,'#Image#',#formatImage#)
/cfquery
Now I will go celebrate!
_
Michael Gagnon
- Original Message -
From: "Dan Haley" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 12:20 PM
Subject: RE: INSERT INTO with loop problem
The commas inside your loop are going to cause problems. You have
cfloop,desc,details,/cfloop. Going through this loop will give you
doubled up commas - ,desc,details,,desc,details,,desc,details,
Dan
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 7:38 AM
To: CF-Talk
Subject: Re: INSERT INTO with loop problem
What do you meen by outputing the SQL statements?
Here's where I'm at now:
CFquery datasource="CSM"
INSERT INTO Projects (ProjectID,ID,Done
cfloop
query="lang",Description#lang.Abrev#,details#lang.Abrev#,/cfloop
Image,FormatImage)
VALUES(#ProjectID#,#ID#,#Done#,
cfloop query="lang"
CFSET tempdesc=evaluate('Description#lang.Abrev#')
CFSET tempdet=evaluate('details#lang.Abrev#')
,'#tempdesc# ','#tempdet# ',/cfloop
Image='#Image#',
FormatImage='#formatImage#')
/cfquery
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Refresh Question?
How can I stop multiple records being added to the database when a user clicks refresh on a form action page? Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
...list...array
okay, i've been getting into lists and arrays but i cant find very much good reference 1: is a list just a 1d array? 2: how do you carry a list/array through pages? Is the only way to do it via application.cfm and locking the list/array? 3: i can figgure out how to make a new array, pretty tough arraynew(1) ;), but how do you make a new list? couldnt find the function for it... I'm pretty famaliar with arrays, they arent a very tough concept, my main problem is syntax, wich i can put togethor via developin web applications (the cf standard book). How to compare them to another when done, how to add the person picked the letter b on the third question... most of this stuff i can figgure out by looking at the functions.. my main problem is question #2. cfset myarray = array() when i do this: cfset myarray[1]="1" cfset myarray[2]="2" cfset myarray[3]="3" It bascially does this: myarray = [1,2,3] right? a list really looks seems to act like a 1d array -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cutting edge or what ???
Is it? ... ... or does Cold fusion even function at all under Windows 2000? Are there big issues I should know about before replacing my CF4.5/NT4.0 installation with Win2000? Does IIS work the same as it does under NT4.0? -Russ -- Russell Jones Webmaster ImproveNow.com Phone: 207.236.0146 e-mail: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting Content / content leeching... A CF method?
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_01C02A30.6C80DB13 Content-Type: text/plain; charset="iso-8859-1" Thank you Stewart -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 11:39 AM To: CF-Talk Subject: RE: Protecting Content / content leeching... A CF method? "problem is that CF mappings, as far as I know, do not work with the IMG tag, let alone the EMBED tag" setup global variable with a mapping then use in the img tag, that works fine CFSET application.root_path="datanet" CFSET application.image_path="#application.root_path#/Images/" IMG name="menu" src="CFOUTPUT#application.image_path#//CFOUTPUTmenu.gif" width="600" height="65" border="0" usemap="#m_menu" and now i really am off :) Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C02A30.6C80DB13 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: Protecting Content / content leeching... A CF = method?/TITLE /HEAD BODY PFONT SIZE=3D2Thank you Stewart/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Stewart McGowan [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:Stewart.McGowan@w= eir-tech.co.uk/A]/FONT BRFONT SIZE=3D2Sent: Friday, September 29, 2000 11:39 AM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: RE: Protecting Content / content = leeching... A CF method?/FONT /P BR PFONT SIZE=3D2quot;problem is that CF mappings, as far as I know, = do not work with the IMG/FONT BRFONT SIZE=3D2tag, let alone the EMBED tagquot;/FONT /P BR PFONT SIZE=3D2setup global variable with a mapping then use in the = img tag, that works/FONT BRFONT SIZE=3D2fine/FONT /P PFONT SIZE=3D2lt;CFSET = application.root_path=3Dquot;datanetquot;gt;/FONT BRFONT SIZE=3D2lt;CFSET = application.image_path=3Dquot;#application.root_path#/Images/quot;gt;= /FONT /P PFONT SIZE=3D2lt;IMG name=3Dquot;menuquot;/FONT BRFONT = SIZE=3D2src=3Dquot;lt;CFOUTPUTgt;#application.image_path#/lt;/CFOUT= PUTgt;menu.gifquot; width=3Dquot;600quot;/FONT BRFONT SIZE=3D2height=3Dquot;65quot; border=3Dquot;0quot; = usemap=3Dquot;#m_menuquot;gt;/FONT /P BR PFONT SIZE=3D2and now i really am off :)/FONT /P PFONT SIZE=3D2Stew/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=3D2To Unsubscribe visit A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli= sts/cf_talk" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= body=3Dlists/cf_talk/A or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body./FONT/P /BODY /HTML --_=_NextPart_001_01C02A30.6C80DB13-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: AutoNumbers and INSERTS
this is one way... there are many others... cftransaction (first query) cfquery name="getmax" datasource="#session.dsn#" SELET max (id_column_name) as maxid FROM tablename /cfquery /cftransaction -- 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: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 5:00 AM To: CF-Talk Subject: AutoNumbers and INSERTS Hi, I'm inserting a load of data into a Table of an Access Database. The ID field is generated by AutoNumber. As soon as the record has been inserted, I need to output what that ID was. How can I do this? Cheers Will... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
admin tool
I was just wondering how many of the other ColdFusion developers handle admin tools. I'm trying to determine what approach will save me the most time in the future. Won -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: bye for a while :)
Thanks for unsubscribing! No auto-response that Stew is not in the office. -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 11:40 AM To: CF-Talk Subject: RE: bye for a while :) have a good vacation :) ~Simon -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 11:32 AM To: CF-Talk Subject: bye for a while :) Dear everyone i'm off on my first vacation for a couple of years so i'll be unsubscribing for a while have fun with out me Regards Stew -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Client Session variables?
Client variables are persistent from session to session for a single user. Session variables are persistent only from one instance of a broswer being opened. Won Lee Software Engineer, kpe Allaire Certified ColdFusion Developer P: 212.609.1145, 212.652.9655 -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 10:17 AM To: CF-Talk Subject: Client Session variables? Dear All, What is the different between Client Session variables? From Rif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF and Apache on Windows NT
Oops, wrong thread. :) I've tried the Outlook object on our intranet and it seems to work great. However, I do wonder if this will pose any security risks. Michael - Original Message - From: "Michael Slatoff" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:55 AM Subject: Re: CF and Apache on Windows NT hmm... scary. - Original Message - From: "Tom Nunamaker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:30 AM Subject: Re: CF and Apache on Windows NT We're running Apache on NT with CF Enterprise with 7 million hits per year on our intranet. Works great. Tom At 09:40 PM 9/28/00, you wrote: Does anyone have a production-level application running on Apache using CF (and Spectra)?I am investigating using it, but the warnings for Win32 have me concerned. Switching to UNIX is not an option unfortunately, although I wish we could -- politics you know. TIA, Mary --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: TO ALL: Request for ColdFusion SP2 Input
I gave up on this dream months ago. I now exclusively use the online documentation. Someone else has made a new version of this just don't expect allaire to do anything about it. I mentioned it to Ben Freuh when he was in town and I have heard nor seen anything come of it, why should allaire have to appease thier customers anyways. Bob Everland -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 11:53 AM To: CF-Talk Subject: RE: TO ALL: Request for ColdFusion SP2 Input To some this may seem trivial but, the PDF documentation HAS to get fixed. For many this is the only documentation that they have for 4.5.x and quite frankly, it sucks. It's not the content, it's the usability. In earlier versions, especially the 4.0.x series, the included and downloadable PDF documentation was thorough and well built. There were bookmarks, thumbnails, and the links all worked. Starting with CFAS 4.5 the PDF's have none of these, which makes them almost useless. "Hmmm, was CFREGISTRY on page 171 or 117? What page number is the end of tags and the beginning of functions? Why don't these darn bookmarks work!?" You get the picture. Not everyone uses Studio and many CF servers have the HTML documentation removed. If PDF was only supposed to be a supplement my opinion would be different but, for upgraders, purchasers of electronic distributions, or those who do not use Studio the PDF docs are all that they have. Unfortunately, Allaire's documentation has always had problems, whether it be incompleteness, inaccuracy, lateness, or terrible physical quality. The documentation group, Margaret et al., made great strides in the 4.0.x series but, things seem to be crumbling again. Regards, * Steve Bernard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Protecting Content / content leeching... A CF method?
The method I have used in the past goes something like this...
index.cfm
--
img src="picture.cfm"
--
picture.cfm
--
cfcontent file="E:\Web Design\Clients\cfcontenttest\logo.gif"
type="image/gif"
--
You can then use any path you like in the file attribute of the cfcontent
tag to push a picture from a non-web-accessible directory. It can be
dynamic as well if you choose, for example
img src="picture.cfm?picture=1"
all the user will see as the image name is "picture.cfm?picture=1".
I am sure if you wanted you could use
img src="picture.cfm?picture=#encode('logo.gif', 'mykey')#"
and really confuse the viewer :-)
Hope this gives you a start in the correct direction.
- Original Message -
From: "Stewart McGowan" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 4:39 PM
Subject: RE: Protecting Content / content leeching... A CF method?
"problem is that CF mappings, as far as I know, do not work with the IMG
tag, let alone the EMBED tag"
setup global variable with a mapping then use in the img tag, that works
fine
CFSET application.root_path="datanet"
CFSET application.image_path="#application.root_path#/Images/"
IMG name="menu"
src="CFOUTPUT#application.image_path#//CFOUTPUTmenu.gif" width="600"
height="65" border="0" usemap="#m_menu"
and now i really am off :)
Stew
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Refresh Question?
bunch of ways could have a function like this form.cfm !---this just keeps the inputs-- form_submit_query.cfm !---this runs the query write, as soon as this is done relocate them to the thank you-- form_submit_thank_you.cfm !---this is the thank you for submitting my form, since it is a relocation it doesnt contain any query stuff-- there's probally a ton of other ways -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 11:08 AM To: CF-Talk Subject: Refresh Question? How can I stop multiple records being added to the database when a user clicks refresh on a form action page? Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A cfquery problem.
In SQL Server you can do something like this: -- creates empty table / must be fast since it locks sys tables SELECT itemnum, IDENTITY(int) AS rownumber INTO #TempItems FROM items WHERE 1 = 2 INSERT #TempItems SELECT itemnum FROM items WHERE user_id = 12345 Then to get a particular set of data - say rcords btw 100 and 200 - you can write: SELECT items.* FROM items INNER JOIN #TempItems ON #TempItems.itemnumber = items.itemnumber WHERE rownumber = 100 AND rownumber = 200 This avoids transferring of large results between the db and CF. You can put all this in a stored procedure and just pass a few paramaters @user_id, @startrow, @endrow.. Oracle has better support for this - you can use rowid directly. P. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 5:09 AM To: CF-Talk Subject: Re: A cfquery problem. On 9/29/00, Vincent penned: cfquery name="get_items" datasource="users" maxrows = 10 SELECT itemnum FROM items WHERE user_id = 12345 /cfquery Now this will get me the top 10 rows, yes! Now what Im looking at is rows 10-20, then 20-30etc Is this possible. I know of one way, but its kinda a long cut. Hi Vin. Maxrows will go in the cfoutput portion of your query. cfoutput query="get_items" maxrows="#maxrows#" startrow="#startrow#" Startrow will be the dynamic variable. On the initial search, you will pass a value of "1". Or you can pass nothing and use cfparam to set a default of "1". CFPARAM NAME="startrow" DEFAULT="1" CFPARAM NAME="maxrows" DEFAULT="10" Then to do your next and previous buttons, you will generally use 2 forms and place this before them: cfset PrevStart = StartRow - MaxRows cfset NextStart = StartRow + MaxRows cfif PrevStart GTE 1 form action="samepage.cfm" method="post" (form stuff) input type="hidden" name="startrow" value="#PrevStart#" input type="hidden" name="maxrows" value="#maxrows#" input type="Submit" value="Previous #maxrows# Records" /form /cfif cfif NextStart LTE Get_Items.RecordCount form action="samepage.cfm" method="post" (form stuff) input type="hidden" name="startrow" value="#NextStart#" input type="hidden" name="maxrows" value="#maxrows#" input type="Submit" value="Next #maxrows# Records" /form /cfif You can also do some neat stuff like checking if there are less than maxrows records left and show the Next button accordingly. cfset remaining = Get_Items.RecordCount - startrow + 1 This will go AFTER the cfset PrevStart/NextStart code. In a search returning 28 records, when you return records 11 thru 20, the value of remaining would be 8. 28 - 21 (the value of startrow) = 7 + 1 = 8 Then you could set accordingly. cfif remaining GT maxrows input type="Submit" value="Next #maxrows# Records" cfelseif remaining LTE maxrows and remaining GT "1" input type="Submit" value="Final #remaining# Records" cfelseif remaining is "1" input type="Submit" value="Final Record" /cfif You can use the same parameters at the top of the search results: CFIF Get_Items.Recordcount IS "1" Displaying 1 item found CFELSE Displaying records #startrow# thru cfif Get_Items.Recordcount LTE (startrow + maxrows - 1) #Get_Items.Recordcount#cfelse #Abs(startrow + maxrows - 1)#/cfif of #Get_Items.Recordcount# records found /CFIF HTH -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Refresh Question?
use two separate cf templates, one does the SQL, the other the display logic. when the user refreshes they are then just refreshing the display page not the action page... /s -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 12:08 PM To: CF-Talk Subject: Refresh Question? How can I stop multiple records being added to the database when a user clicks refresh on a form action page? Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Client Session variables?
On 9/29/00, Rif Kiamil penned: Dear All, What is the different between Client Session variables? From Rif Dear Rif. They pretty much accomplish the same thing. Client variables are unique to each client, may be stored in cookies (if they are turned on), the registry (bad bad idea), or a database (best method). They will persist across sessions (if the server reboots, you don't lose the stuff in your shopping cart, etc.) and across servers in a clustered environment. Session variables are the same thing, unique to each client, but are stored in RAM. No good across servers or if the server crashes. There is a whole cflock debacle with session and application variables (which are similar to session variables in the way they are stored, but are available to everyone using the application). I still haven't figured that one out, so the easiest thing for me was to swear off session variables for good. The upside is, now everything I build will work in a clustered environment. Use client variables, written to a database, whenever possible. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cutting edge or what ???
Personally, I like the combination better. But I'm only using it in Intranet settings without extremely high-load. Ken - Original Message - From: Russell Jones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 12:07 PM Subject: cutting edge or what ??? Is it? ... ... or does Cold fusion even function at all under Windows 2000? Are there big issues I should know about before replacing my CF4.5/NT4.0 installation with Win2000? Does IIS work the same as it does under NT4.0? -Russ -- Russell Jones Webmaster ImproveNow.com Phone: 207.236.0146 e-mail: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cutting edge or what ???
We are running cf 4.5 on WIN2K with no problems... Allaire does not support anything older than 4.5 on WIN2K, though. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Russell Jones" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 12:07 PM Subject: cutting edge or what ??? Is it? ... ... or does Cold fusion even function at all under Windows 2000? Are there big issues I should know about before replacing my CF4.5/NT4.0 installation with Win2000? Does IIS work the same as it does under NT4.0? -Russ -- Russell Jones Webmaster ImproveNow.com Phone: 207.236.0146 e-mail: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Upgrading to 4.5
On 9/28/00, Daniel Allison penned: I am about to upgrade from CF 4.0.1 Enterprise to CF 4.5.1. Enterprise on NT 4.0. The database we use is SQL server 7 on a separate machine. Does anyone have any advice on what to look for and what pitfalls to avoid. Yes. Stick with 4.01. I have nothing but problems on any server I work on running 4.51. If it isn't one thing, it's two or three. Nary a problem with 4.01. Thank goodness I waited to play with it before installing it on mine. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Metadata 2
What kind of metadata you are looking for? I can give you some sample code/pointers on how to do a CFX (C++). I did mine out of a sample from MSDN (called cat.cpp or something like that). Uses MFC and other crap, but if you compile it in a single DLL you should be OK. They do many things metadata queries, and can be easily, but tediously extended. Jaime/ -Original Message- From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:25 AM To: CF-Talk Subject: Metadata 2 sorry guys I forgot to mention I want to do that from ColdFusion using ODBC (ie. no matter wich database is) ideas? gracias ; ) Juandres - Original Message - From: JustinMacCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 29, 2000 12:14 PM Subject: Re: Medadata Hola Juan, Anyone knows how can I get the metadata information from DB ? (ie. tables, fields, primary keys, datatypes, views) In MsSql you can use the StoredProcs such called sp_tables witch will return all the tables in a DB including the sys tables. There are other that do different things , sp_columns etc... In Access you can get at the table names from a systable , it's called MsysObjects ,but it has alot of other stuff in there. To view the table in access go to tools-options-view and tick hidden objects and system objects Hasta Lleugo ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ...list...array
A list is simply a delimited string. The delimiter is usually a comma. A list really isn't an Object in CF, it's more of a concept. I could say cfset myVar = "23,42,25,262" I could then treat myVar as a List if I wanted to, since a list is simply a delimited string. So now I could use all the List functions that CF provides on it. cfset v = ListFind(myVar, 25) returns true The delimiter can be other things besides a comma, so for instance an IP address could be treated as a list, where the delimiter is a . cfset ip = "10.0.1.2" cfset ClassC = ListGetAt(ip, 3, ".") Returns 1 cfset ClassD = ListGetAt(ip, 4, ".") Returns 2 Or a unix path name cfset path = "/usr/local/sbin/foo" cfset Root = ListGetAt(path, 2, "/") Returns "usr" __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 12:11 PM To: CF-Talk Subject: ...list...array okay, i've been getting into lists and arrays but i cant find very much good reference 1: is a list just a 1d array? 2: how do you carry a list/array through pages? Is the only way to do it via application.cfm and locking the list/array? 3: i can figgure out how to make a new array, pretty tough arraynew(1) ;), but how do you make a new list? couldnt find the function for it... I'm pretty famaliar with arrays, they arent a very tough concept, my main problem is syntax, wich i can put togethor via developin web applications (the cf standard book). How to compare them to another when done, how to add the person picked the letter b on the third question... most of this stuff i can figgure out by looking at the functions.. my main problem is question #2. cfset myarray = array() when i do this: cfset myarray[1]="1" cfset myarray[2]="2" cfset myarray[3]="3" It bascially does this: myarray = [1,2,3] right? a list really looks seems to act like a 1d array -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
