RE: Re: cffileACCEPT attribute
Will this work?
cffile action="upload" destnation="c:\temp" accept="GIF,JPG"
I did try it but again it was allowing file of any type to be
uploaded.
You have to specify the MIME types exactly. You might want to get a list of
MIME types, if you don't already know them. I've included a sample file,
which will submit a file to itself if it's a GIF or JPEG. The MIME type for
a GIF is "image/gif", not "images/gif". In addition, CFFILE will throw an
error if you send the wrong MIME type in CF 4.5.1.
!--- uploadme.cfm ---
CFIF IsDefined("Form.myaction")
CFTRY
CFFILE ACTION="UPLOAD"
FILEFIELD="myfile"
DESTINATION="C:\Inetpub\wwwroot\test\cffile"
NAMECONFLICT="OVERWRITE"
ACCEPT="image/gif,image/jpeg,image/pjpeg"
CFCATCH
Wrong file type!
/CFCATCH
/CFTRY
/CFIF
html
head
titlefile upload filter/title
/head
body
form action="uploadme.cfm" method="post" enctype="multipart/form-data"
input type="file" name="myfile"
input type="submit" name="myaction"
/form
/body
/html
!--- end uploadme.cfm ---
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.eGroups.com/list/cf-talk
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.
Jumping Sessions??
I have a very interesting issue I would like to ask you all about. At work, we recently released a "poll" program that allows people to choose what type of job they would like to get. Sort of like pre-applying for either a new/your current job (hey, I dont come up with these ideas, I just implement em for the business folks!) Now here is the problem; We released this to the public yesterday. It seems to work great, but early this morning the errors rolled in. LOTS OF EM. After some diagnosing, we determined all the errors we related to one problem, session variables. To protect infomation (specifically employee numbers) we pass them via session variables. On every page, we run queries against Sybase to pull their name, infomation, etc. Now the problem is that people are "jumping" sessions. So user A will see user B information. It seems consistent, so you dont switch users from page to page, maybe once in the session, but from then on, you remain this other user. When we first saw this problem, we attempted reducing the session timeout to no avail. The sessions are all locked already and it is not experiencing any real load. We are running Solaris with Netscape Enterprise Server and Cold Fusion 4.0 installed on the same box. The database is a massive Sybase system running on its own environment. Sessions are being done without URL variables. This is the ONLY thing we are storing in the session variable. This is a real concern and its very important that we solve this as some people in the company are already fighting against Cold Fusion in favor of Java and this error makes CF look awful as it was a high profile failure. I contacted Allaire only to be told to open a ticket and have posted a message on the forums with a few responses but no solutions. Any help would be greatly appreciated! Thanks!! Mike Grundvig P.S. All people using the application are on NS 4.7 with cookies enabled. This is all intranet based on Mac and PC systems, including NT. -- Archives: http://www.eGroups.com/list/cf-talk 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.
Strange CF Error Message
Hi CFers, We're running an e-commerce site on 2 Dell PowerEdge servers using Cold Fusion, VB COM Objects, Microsoft Transaction Server, and SQL Server 7. The site is now in live-testing phase, and we get this error message every now and then, most frequently when the site is accessed for the first time after inactivity: Error Occurred While Processing Request Error Diagnostic Information Unable to acquire lock for single threaded sessions within timeout period. Please raise the request timeout limit to lengthen the time available to acquire the lock. The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (1:152) in the template file D:\APPDIR\..\APPLICATION.CFM. We checked the 'Single-threaded Sessions' option in CF Admin and set all the other locking options to 'No Checking'. We use no explicit Client or Application variables, only Session variables. We use no CFLOCKs at all. The request timeout value is 60 seconds. Has anyone ever encountered this error? We are quite stumped as it is ... all comments appreciated! Thanks, --- Eldo Lukman Multimedia Programmer Monitor Interactive Communications Pty Ltd ACN: 050 036 283 Level 2, 4-14 Foster Street Surry Hills, NSW 2010 AUSTRALIA Telephone: +61 2 9219 8956 Facsimile: +61 2 9219 8950 E-mail: [EMAIL PROTECTED] Mobile: 0418 265 829 Web Site: http://www.monitorinteractive.com.au/ --- -- Archives: http://www.eGroups.com/list/cf-talk 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.
TEST
Sorry, Previous mail did not go through. Testing. Les Mizzell *** Who needs Intel? Athlon Inside!!! -- Archives: http://www.eGroups.com/list/cf-talk 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-setting frames/pdf files
This is a multi-part message in MIME format.
--Boundary_(ID_pi7mAtNrV68mOSn3aPqKfQ)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE
Hello everyone,
I have a multi-part problem/question to you gurus out there:
We have a template with 2 frames which works great:
frameset rows=3D"80,*" cols=3D"*" frameborder=3D"NO" border=3D"0" fr=
amespacing=3D"0"
frame name=3D"topFrame" scrolling=3D"NO" noresize
src=3D"../login/ieframeinstructions.cfm"
frameset cols=3D"350,*" frameborder=3D"NO" border=3D"0" framespaci=
ng=3D"0"
frame name=3D"leftFrame" noresize scrolling=3D"yes"
src=3D"ctdoallcart.cfm?po=3D#po#action=3D#action#"
frame name=3D"mainFrame" src=3D"dacatalog.cfm"
/frameset
/frameset
In the mainframe we are displaying a PDF file which we have edited to
contain URL=92s to re-display ctdoallcart.cfm in the leftFrame.
Unfortunately, there is only a Url link and no a href link so we ca=
nnot
specify a target. We have also tried linking a javascript, but that =
gets
messy because it trys to execute that javascript inside of the ADOBE =
frame
work for some reason.
So, I guess my question is how do I clear the frame set and reset it?=
My
work around solution. We tried to download the Adobe Developer Kit an=
d it
bugs out on us.
Any suggestions or help would be greatly appreciated.
Thanks
Elizabeth
--Boundary_(ID_pi7mAtNrV68mOSn3aPqKfQ)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org=
/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8=
859-1"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{mso-style-parent:"";
=09margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
=09{margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
=09{mso-style-type:personal-compose;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
@page Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.25in 1.0in 1.25in;
=09mso-header-margin:.5in;
=09mso-footer-margin:.5in;
=09mso-paper-source:0;}
div.Section1
=09{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'Hello everyone,o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'![if !supportEmptyParas]nbsp;![endif]o:p/o:p/span/=
font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'I have a multi-part problem/question to you gurus out there:o=
:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'![if !supportEmptyParas]nbsp;![endif]o:p/o:p/span/=
font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'We have a template with 2 framesspan style=3D"mso-spacerun: y=
es"nbsp;
/spanwhich works great:o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'![if !supportEmptyParas]nbsp;![endif]o:p/o:p/span/=
font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'![if !supportEmptyParas]nbsp;![endif]o:p/o:p/span/=
font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
CF Training?
This is a multi-part message in MIME format. --=_NextPart_000_0009_01BFCB33.E53B42A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all! I have read CFWACK4.0 cover to cover (along with doing all the = exercises) and am starting on the Advanced book. I'm wondering if I = should attend the training courses by Allaire, FT to CF and Advanced CF = development. I have starting writing applications on the side for = people, but I would like to make this my full-time career (I love this = stuff!). OK CF gurus, how do I get my foot in the door for a career in = CF? My background (I'll keep this short) is a BA in Biology with a = minor in math and some misc additional courses that mean just as little. = The important stuff I've been working on though is self-study in CF, = SQL, Visual Basic, NetObjects Fusion and Access. Please advise!! Thanks, Christine --=_NextPart_000_0009_01BFCB33.E53B42A0 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 content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; I have read = CFWACK4.0 cover to=20 cover (along with doing all the exercises) and am starting on the = Advanced=20 book.nbsp; I'm wondering if I should attend the training courses by = Allaire, FT=20 to CF and Advanced CF development.nbsp; I have starting writing = applications on=20 the side for people, but I would like to make this my full-time career = (I love=20 this stuff!).nbsp; OK CF gurus, how do I getnbsp;my foot in the door = for a=20 career in CF?nbsp; /FONTFONT face=3DArial size=3D2My background = (I'll keep this=20 short) is a BA in Biology with a minor in math and some = miscnbsp;additional=20 courses that mean just as little.nbsp; Thenbsp;important stuff I've = been=20 working on though is self-study in CF, SQL, Visual Basic, NetObjects = Fusion and=20 Access.nbsp;nbsp; Please advise!!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; Thanks,nbsp;=20 Christine/FONT/DIV/BODY/HTML --=_NextPart_000_0009_01BFCB33.E53B42A0-- -- Archives: http://www.eGroups.com/list/cf-talk 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: [Re: personal oracle 8i]
Thanks. So you are saying that I must install the personal oracle server and personal oracle client in the same machine, and configure the CF server to connect to the database using sql net from oracle personal client? Irwan "Larry Meadors" [EMAIL PROTECTED] wrote: I got it working. Did you install the client part on the server? The default driver that comes w/NT won't do. Larry [EMAIL PROTECTED] 05/31/00 10:04AM Does anybody ever use CF server connect to Personal Oracle 8i? I tried but it can't work. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.eGroups.com/list/cf-talk 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: I want my #$# on the first of the month.
From memory...
CreateODBCDate( CreateDate(Year(Now(), Month(DateAdd("m", 1, Now())), 1))
At 16:32 31/05/00 -0400, you wrote:
I have been on a 23 hour coding spree to finish up a project. How do
you create an odbc date value for the first of next month? I thought
i had it but something is escaping me. I am tired and this is the
last thing.
thanks
Tim Hill
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
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: I want my #$# on the first of the month.
Find the current month, create a date for the first of this month, then
add one month to that date.
#CreateODBCDate(DateAdd("m", 1,
CreateDate(Year(Now()), DatePart("m", Now()), 1)))#
Jim
-Original Message-
From: Timothy C. Hill [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, May 31, 2000 8:11 PM
Subject: I want my #$# on the first of the month.
I have been on a 23 hour coding spree to finish up a project. How do
you create an odbc date value for the first of next month? I thought
i had it but something is escaping me. I am tired and this is the
last thing.
thanks
Tim Hill
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000
--
Archives: http://www.eGroups.com/list/cf-talk
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: I want my #$# on the first of the month.
I am not guru - but try this - cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput hope that does the trick. Elizabeth -Original Message- From: Timothy C. Hill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 1:33 PM To: [EMAIL PROTECTED] Subject: I want my #$# on the first of the month. I have been on a 23 hour coding spree to finish up a project. How do you create an odbc date value for the first of next month? I thought i had it but something is escaping me. I am tired and this is the last thing. thanks Tim Hill -- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk 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: open window (JS)
In the A HREF tag do this: A HREF="Javascript:void()" onClick="function()"" Dave - Original Message - From: Jason Egan [EMAIL PROTECTED] To: Cf-Talk [EMAIL PROTECTED] Sent: Wednesday, May 31, 2000 2:08 PM Subject: open window (JS) I am trying to open a image preview window - I've used fusebox to the best of my ability. I am also using a '/' for url parameters rather than '? =' .. I have a url as such: admin/index.cfm/fuseaction/properties/propid/CB1 This page contains a link to open a window - the window opens and displays correctly, but the link has to point somewhere, so I put the same url as the href="index.cfm/fuseaction/properties/propid/CB1" - reloading the page is probably unnecessary. If I use #'s in the href like you normally would then the page displayed is like have a url of: admin/index.cfm. Any pointers on how I can open the window and not reload the page? Thanks, je -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: I want my #$# on the first of the month.
I am not guru - but try this - cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput hope that does the trick. Elizabeth -Original Message- From: Timothy C. Hill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 1:33 PM To: [EMAIL PROTECTED] Subject: I want my #$# on the first of the month. I have been on a 23 hour coding spree to finish up a project. How do you create an odbc date value for the first of next month? I thought i had it but something is escaping me. I am tired and this is the last thing. thanks Tim Hill -- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk 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.
pdf and frameset
This is a multi-part message in MIME format.
--Boundary_(ID_zEdQwEwGCXBXy1lOfLDriA)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE
Hello everyone,
I have a multi-part problem/question to you gurus out there:
We have a template with 2 frames which works great:
frameset rows=3D"80,*" cols=3D"*" frameborder=3D"NO" border=3D"0" fr=
amespacing=3D"0"
frame name=3D"topFrame" scrolling=3D"NO" noresize
src=3D"../login/ieframeinstructions.cfm"
frameset cols=3D"350,*" frameborder=3D"NO" border=3D"0" framespaci=
ng=3D"0"
frame name=3D"leftFrame" noresize scrolling=3D"yes"
src=3D"ctdoallcart.cfm?po=3D#po#action=3D#action#"
frame name=3D"mainFrame" src=3D"dacatalog.cfm"
/frameset
/frameset
In the mainframe we are displaying a PDF file which we have edited to
contain URL=92s to re-display ctdoallcart.cfm in the leftFrame.
Unfortunately, there is only a Url link and no a href link so we ca=
nnot
specify a target. We have also tried linking a javascript, but that =
gets
messy because it trys to execute that javascript inside of the ADOBE =
frame
work for some reason.
So, I guess my question is how do I clear the frame set and reset it?=
My
work around solution. We tried to download the Adobe Developer Kit an=
d it
bugs out on us.
Any suggestions or help would be greatly appreciated.
Thanks
Elizabeth
--Boundary_(ID_zEdQwEwGCXBXy1lOfLDriA)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org=
/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8=
859-1"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{mso-style-parent:"";
=09margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
=09{margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
=09{mso-style-type:personal-compose;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
span.EmailStyle17
=09{mso-style-type:personal;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
span.EmailStyle18
=09{mso-style-type:personal;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
@page Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.25in 1.0in 1.25in;
=09mso-header-margin:.5in;
=09mso-footer-margin:.5in;
=09mso-paper-source:0;}
div.Section1
=09{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'Hello everyone,o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'nbsp;o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'I have a multi-part problem/question to you gurus out there:o=
:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'nbsp;o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'We have a template with 2 framesspan style=3D"mso-spacerun: y=
es"nbsp;
/spanwhich works great:o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'nbsp;o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan
Re: I want my #$# on the first of the month.
Tim,
jeez, I hope you figured this out by now but if not...
cfset thismonth = Now()
cfset nextmonth = DateAdd("m", 1, thismonth)
cfset NMyear = DatePart("", nextmonth)
cfset NMmonth = DatePart("m", nextmonth)
cfset NMday = 1
cfset finalval = CreateODBCDate(CreateDate(NMyear, NMmonth, NMday))
This may be the long way to do this - and will hopefully be
self-explanatory. I would probably do some sort of ugly
functionwithina(functionwithina(function))) kinda thing in real
life. Don't know if that's a good thing though...
hth,
Kevin
At 04:32 PM 5/31/00 -0400, you wrote:
I have been on a 23 hour coding spree to finish up a project. How do
you create an odbc date value for the first of next month? I thought
i had it but something is escaping me. I am tired and this is the
last thing.
thanks
Tim Hill
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000
--
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
--
Archives: http://www.eGroups.com/list/cf-talk
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.
Query Question
Hi All, I am having a heck of a time conceptualizing this query. I basically have two tables I am working with one is a Company Database with beside address and contact have a check box field that is labeled PRIVATE (YES/NO). I also have a database of records that have an items of which there may be duplicates from several companies. itemdesccompany 500item1com1 600item2com1 600item3com3 600item4com4 If the company record is marked as private. Then when I select all with a value of 600, How do I except records where the company record has private="yes" Find all records in database with a value of 600 except those from a company that is marked PRIVATE Kelly -- Archives: http://www.eGroups.com/list/cf-talk 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: I want my #$# on the first of the month.
note sure of the syntax exactly. date(year(date) + (month(date)=12), mod(month(date),12)+1,1) From: "Timothy C. Hill" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: I want my #$# on the first of the month. Date: Wed, 31 May 2000 16:32:45 -0400 I have been on a 23 hour coding spree to finish up a project. How do you create an odbc date value for the first of next month? I thought i had it but something is escaping me. I am tired and this is the last thing. thanks Tim Hill -- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000 -- Archives: http://www.eGroups.com/list/cf-talk 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 -- Archives: http://www.eGroups.com/list/cf-talk 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: I want my #$# on the first of the month.
Not very elegant, but here it is...
cfset new_date = #CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))#
Currently outputs: {d '2000-06-01'}
Good luck.
Judah
At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote:
I have been on a 23 hour coding spree to finish up a project. How do
you create an odbc date value for the first of next month? I thought
i had it but something is escaping me. I am tired and this is the
last thing.
thanks
Tim Hill
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
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.
browser detection
Anyone know of a way to write a statement like this that works? This is the idea: I need to write an "if" statement based on if netscape is being used. I would like to use the HTTP_USER_AGENT like this: cfif HTTP_USER_AGENT IS NOT "" cfif HTTP_USER_AGENT LIKE '%netscape%' put netscape version here/cfif cfif HTTP_USER_AGENT LIKE '%ie%' put ie version here/cfif /cfif Any help is much appreciated! Britta -- Archives: http://www.eGroups.com/list/cf-talk 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: Sql for selecting date ranges
Shawn, Sounds like BETWEEN should work for you: SELECT foo... FROM bar... WHERE adatefield BETWEEN #firstdateval# AND #seconddateval# You'll want to be careful if your adatefield contains time data - not sure how that would affect query results - though the query will run. hth, Kevin At 03:08 PM 5/31/00 -0700, you wrote: What is the best way to go about selecting date ranges. Like selecting everything from today's date up to 5 or 6 days from now? Shawn Regan -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.eGroups.com/list/cf-talk 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.
Forcing a page to refresh on back-up
I sure hope someone's still awake! I'd like a page to refresh if a user uses his/her "back" button to get to it. I don't want the previous form information filled in once they've submitted, then backed up. I searched for an easy solution tonight, but must have been looking in the wrong places, Thanks Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.
Gold Points CF site
Hey gang- I'm trying to get hold of anyone currently working on the Goldpoints.com site. Thanks. Scott Beach [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.
CFSCRIPT
Is it more efficient to use CFML scripting rather than tags? For example, I have some code that loops and does some calculations. At the moment I have this using lots of CFSET and CFLOOP tags... would it be quicker to put all this inside a CFSCRIPT tag. Thanks -- Archives: http://www.eGroups.com/list/cf-talk 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: Lost Data
This does not sound good You probably truncated your tables. At this
point my only hope of recovery would be advice from Dave Watts:-)
-Original Message-
From: ldang {Lily Dang} [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 12:18
To: '[EMAIL PROTECTED]'
Subject: RE: Lost Data
Importance: High
Hi Everyone,
Please help! My co-worker and I made a significant amount of data
disappeared from a SQL server database when we were in the process of
transfering the database from SQL Server to Access 2000.
We generated SQL scripts, created a machine datasource, and run it to a new
Access 2000 database. However, somewhere in the process, all the data got
lost except the tables structure. The problem is that we don't have any
backup.
We still have the SQL scripts, what do we do?
Any help is greatly appreciated,
Thanks,
Lily
--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Another question on performance
If the "extra fields" are computed from other fields in the SQL query and/or external data (known at the time of the query), you might consider computing these fields as part of the SQL query itself... using scalar functions or T/SQL statements (SQL Server). From what I have heard/read/experienced, the SQL engine can probably do this a lot more efficiently that any CF routines you could write. Dick At 10:10 AM +1000 6/1/2000, Nick Slay wrote: ok... so when it comes to performance, it's better to use strutctures than arrays and both of those are better than lists. But what about queries? Queries that are generated using QueryNew as opposed to SQL statements. I have a SQL Query result set that I need to loop through, calculate a bunch of extra fields, and then store that off for looping through later. At the moment I create a new query, take the fields I want from the SQL result set, and add them, plus the new fields into a new query. There are probably more efficient ways of doing this... Does anyone know whether creating another query, and looping through it later is going to be better or worse than creating an array of structures and looping through those instead? For that matter would I be better to add a column to the query that I got from SQL Server, and then loop through that again? Thanks for any feedback! -- Archives: http://www.eGroups.com/list/cf-talk 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.
Testing - Delete Me!!
Last one did not make it this is a test Sorry ;-} -- Archives: http://www.eGroups.com/list/cf-talk 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: Forcing a page to refresh on back-up
Someone passed this along to me and it seems to work:
CFSET Offset="-12"
CFHEADER NAME="Expires" VALUE="#DateFormat(DateAdd('h',offset,Now()), 'dd
mmm ')# #TimeFormat(DateAdd('h',offset,Now()), 'hh:mm:ss')# GMT"
CFHEADER NAME="Pragma" VALUE="no-cache"
CFHEADER NAME="cache-control" VALUE="no-cache, no-store, must-revalidate"
In your context, be careful that you don't upset the user, they may be
trying to hit the back button on their browser because they made an honest
mistake and want to make a change without re-filling out the entire form all
over again.
On your action page you may want to give them a button, link, etc to submit
a new entry while keeping some pertinent information (Name, Address, City...
etc.) or submit a new blank entry. Just a thought.
Sincerely,
Rob Sherman
Developer / Allaire Certified Instructor
--
Email:[EMAIL PROTECTED]
ICQ:_3266081
AIM:__RobSSherm
Yahoo!:RobSherman_CFDev
Office:__(310) 543-1622
Office Fax:__(310) 543-0512
VMail/Fax:__(310) 754-6016 ext. 5630
--
Archives: http://www.eGroups.com/list/cf-talk
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: CFSCRIPT
Is it more efficient to use CFML scripting rather than tags? For example, I have some code that loops and does some calculations. At the moment I have this using lots of CFSET and CFLOOP tags... would it be quicker to put all this inside a CFSCRIPT tag. OK, here's how CFScript works speed wise (in v4 anyways) Sets are faster in CFScript, Loops are slower in CFScript, so, it'd be fastest to; CFLoop ... loop condition ... CFScript ... set variables and calculations ... /CFScript /CFLoop Looping in v4 CFScript is horribly slow compared to standard tags... Also, remember to CFSetting EnableCFOutputOnly="Yes" which speeds up the output from loops to the browser HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk 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: CFSILENT not working?
I tried using cfsilent to suppress the output of an ArrayAppend() function, and CF server yelled at me. =) Apparently it doesn't recognize the tag, which sort of goes along with the fact that CF Studio doesn't try to autocomplete when I type cfsil Anyone else have this problem? Both apps are v4.5. Being as I don't know 4.5 yet, why not do what I do in 4... cfset t=ArrayAppend(myArray,myValue) Works for me... but as I say, I don't know 4.5 yet g Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk 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: Query Cache Limit Question
Finally, I'd like to point out that many kinds of "what if" questions, commonly asked on the list, are best answered with five minutes of testing. Perhaps Allaire could also take this approach when writing their docs? :) From the current v4.5.1 Online Docs regarding Cache Settings in CF Administrator: "Limits the maximum number of cached queries that the server will maintain. Cached queries allow for retrieval of result sets from memory rather than through a database transaction. The maximum number of cached queries allowed at any given time is 100. When this value is reached, the oldest query is dropped from the cache and replaced with the specified query." That's likely where the mis-guided info originated. Ken -- Archives: http://www.eGroups.com/list/cf-talk 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: pdf and frameset
Elizabeth;
If I understand your objective correctly, one option would be to make the
original frameset into two frames ("top" and "bottom"). Write a separate
2-frame frameset (your columns) "left" and "right" and load it, by default,
into "bottom." When running your HREF out of "right", you can now target
"bottom" to reset both your "left" and "right" frames simultaneously. Hope
this helps.
Don
-Original Message-
From: Elizabeth Marcotte Selphcotte [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 10:45 PM
To: talk talk
Subject: pdf and frameset
This is a multi-part message in MIME format.
--Boundary_(ID_zEdQwEwGCXBXy1lOfLDriA)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE
Hello everyone,
I have a multi-part problem/question to you gurus out there:
We have a template with 2 frames which works great:
frameset rows=3D"80,*" cols=3D"*" frameborder=3D"NO" border=3D"0" fr=
amespacing=3D"0"
frame name=3D"topFrame" scrolling=3D"NO" noresize
src=3D"../login/ieframeinstructions.cfm"
frameset cols=3D"350,*" frameborder=3D"NO" border=3D"0" framespaci=
ng=3D"0"
frame name=3D"leftFrame" noresize scrolling=3D"yes"
src=3D"ctdoallcart.cfm?po=3D#po#action=3D#action#"
frame name=3D"mainFrame" src=3D"dacatalog.cfm"
/frameset
/frameset
In the mainframe we are displaying a PDF file which we have edited to
contain URL=92s to re-display ctdoallcart.cfm in the leftFrame.
Unfortunately, there is only a Url link and no a href link so we ca=
nnot
specify a target. We have also tried linking a javascript, but that =
gets
messy because it trys to execute that javascript inside of the ADOBE =
frame
work for some reason.
So, I guess my question is how do I clear the frame set and reset it?=
My
work around solution. We tried to download the Adobe Developer Kit an=
d it
bugs out on us.
Any suggestions or help would be greatly appreciated.
Thanks
Elizabeth
--Boundary_(ID_zEdQwEwGCXBXy1lOfLDriA)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org=
/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8=
859-1"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{mso-style-parent:"";
=09margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
=09{margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
=09{mso-style-type:personal-compose;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
span.EmailStyle17
=09{mso-style-type:personal;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
span.EmailStyle18
=09{mso-style-type:personal;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
@page Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.25in 1.0in 1.25in;
=09mso-header-margin:.5in;
=09mso-footer-margin:.5in;
=09mso-paper-source:0;}
div.Section1
=09{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'Hello everyone,o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'nbsp;o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'I have a multi-part problem/question to you gurus out there:o=
:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle18font size=3D2 color=
=3Dblack
face=3DArialspan style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p=
t;font-family:
Arial'nbsp;o:p/o:p/span/font/span/p
p
RE: I want my #$# on the first of the month.
I love threads like this, always interesting to see what people come up with. Just wanted to correct this one (and at least one other person that did something similar). cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput You can't just add 1 to the current month...what happens when it is December? You do indeed need to use the DateAdd function to do something like this. - | Mary Jo Sminkey [EMAIL PROTECTED] | | Lovettsville, VA USA http://www.dogpatch.org | | | | Tosh, UD, AD, VAD, PT (Old, Retired Dog) | | Taz, ADCH, UD, MX, AXJ, EAC, EJC, EGC, FM | - -- Archives: http://www.eGroups.com/list/cf-talk 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: Query Question
select company, item fromcompanies, items where companies.company = items.company and companies.private = 'NO' and items.item = 600 i think.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 11:06 PM To: [EMAIL PROTECTED] Subject: Query Question Hi All, I am having a heck of a time conceptualizing this query. I basically have two tables I am working with one is a Company Database with beside address and contact have a check box field that is labeled PRIVATE (YES/NO). I also have a database of records that have an items of which there may be duplicates from several companies. itemdesccompany 500item1com1 600item2com1 600item3com3 600item4com4 If the company record is marked as private. Then when I select all with a value of 600, How do I except records where the company record has private="yes" Find all records in database with a value of 600 except those from a company that is marked PRIVATE Kelly -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
stats
Hi there!
I'd like to create an application to generate stats of my site. First (to
count the number of visits) I thought I could do something like this:
In the application.cfm I increment a DB column everytime, but, within this
I'll increment that number for every page request, I'd like to increment
only once for user, how can I manipulate the session? would this work
cfif NOT IsDefined("Session.stats")
query updating the field ...
/cfif
cfset Session.stats = true
Ok, but what if I'd like to create a counter for each page requested? Is
there a way to discover what page the user is requesting?
Thanks guys
[]'s
Vinicius Carvalho
--
Archives: http://www.eGroups.com/list/cf-talk
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: I want my #$# on the first of the month.
cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput You can't just add 1 to the current month...what happens when it is December? You do indeed need to use the DateAdd function to do something like this. You don't NEED to use DateAdd, but it makes the code shorter. You COULD use something like this: cfif month(now()) IS 12 cfset myyear = year(now()) + 1 cfset thedate = createdate(myyear, 1, 1) cfelse cfset mymonth = month(now()) + 1 cfset thedate = createdate(year(now()), mymonth, 1) /cfif There are always alternative ways to do things. Tom -- Archives: http://www.eGroups.com/list/cf-talk 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.
stats
Hi there!
I'd like to create an application to generate stats of my site. First (to
count the number of visits) I thought I could do something like this:
In the application.cfm I increment a DB column everytime, but, within this
I'll increment that number for every page request, I'd like to increment
only once for user, how can I manipulate the session? would this work
cfif NOT IsDefined("Session.stats")
query updating the field ...
/cfif
cfset Session.stats = true
Ok, but what if I'd like to create a counter for each page requested? Is
there a way to discover what page the user is requesting?
Thanks guys
[]'s
Vinicius Carvalho
--
Archives: http://www.eGroups.com/list/cf-talk
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.
shopping cart?
Hi I'm looking to do my first shopping cart w/ CF. As the merchant for whom the site is being built doesn't accept credit cards, "submit order" is simply going to send a few emails and store some records in the database. Can anyone give me a few pointers on the best way to do this? Would CFTRANSACTION be useful? Thanks! * John * -- Archives: http://www.eGroups.com/list/cf-talk 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.
Creating PDF
This may have been asked, or even easy to do but; Can you create a pdf file and have it created with cf data? What does it take to to do this? Kelly -- Archives: http://www.eGroups.com/list/cf-talk 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: browser detection
From: Britta Wingenroth [mailto:[EMAIL PROTECTED]] This is the idea: I need to write an "if" statement based on if netscape is being used. I would like to use the HTTP_USER_AGENT like this: cfif HTTP_USER_AGENT IS NOT "" cfif HTTP_USER_AGENT LIKE '%netscape%' This is IE: Browser is Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) This is Netscape: Browser is Mozilla/4.72 [en] (Windows NT 5.0; I) It looks like the [en] is the Netscape indicator. Someone correct me if I'm wrong. Try using cfif http_user_agent contains "[en]" Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market your lists on the Net! [EMAIL PROTECTED] 941-541-9000 Ext. 210 -- Archives: http://www.eGroups.com/list/cf-talk 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: I want my #$# on the first of the month.
Or you could try this, maybe I'm crazy just seems easier FirstDayOfMonth(
date). Love the old 4.0 documentation, bookmarks anyone remember those, is
Allaire ever gonna give em back in the 4.5 documentation.
Robert Everland III
Web Developer
Dixon Ticonderoga
-Original Message-
From: Judah McAuley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 11:44 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: I want my #$# on the first of the month.
Not very elegant, but here it is...
cfset new_date =
#CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))#
Currently outputs: {d '2000-06-01'}
Good luck.
Judah
At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote:
I have been on a 23 hour coding spree to finish up a project. How do
you create an odbc date value for the first of next month? I thought
i had it but something is escaping me. I am tired and this is the
last thing.
thanks
Tim Hill
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Jumping Sessions??
The one time I've seen this happen was when the server admin didn't do a complete uninstall of an earlier version of cf server before upgrading. Somehow, there were two sets of session variables, and the variables didn't _really_ get set until the second time. (So, people had to double log in, etc.) Don't know if that's possible in your case, but something to consider. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk 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: browser detection
[en] stand for English. I think the (compatible;) is what differentiates. You may want to look into CFX_Browserhawk from the developers exchange. That is a custom tag to determine browser versions. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 8:58 AM To: [EMAIL PROTECTED] Subject: RE: browser detection From: Britta Wingenroth [mailto:[EMAIL PROTECTED]] This is the idea: I need to write an "if" statement based on if netscape is being used. I would like to use the HTTP_USER_AGENT like this: cfif HTTP_USER_AGENT IS NOT "" cfif HTTP_USER_AGENT LIKE '%netscape%' This is IE: Browser is Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) This is Netscape: Browser is Mozilla/4.72 [en] (Windows NT 5.0; I) It looks like the [en] is the Netscape indicator. Someone correct me if I'm wrong. Try using cfif http_user_agent contains "[en]" Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market your lists on the Net! [EMAIL PROTECTED] 941-541-9000 Ext. 210 -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: CFParam and radiobutton array validation
Hi Troy, I am not sure that my experience with a checkbox column in a query will give you some idea. The query could have any number of records so every column is like array of fields. I had a query which dynamically created using the information from a user submitted form. In that form there is a checkbox field. If that filed is "no", then I have to check all the fields associated with that particular checkbox field (or say the whole record). If any field in that record is empty I have to send the user back to re-fill the form. What I did is to loop through the query and check the checkbox column, if it is "no" then check the rest fields in that record. If any field is empty use "cfbreak" to stop the process and redirect the user back to the form. To help you to understand what I am talking about I past the related code here. If it is not useful just ignore it. I am only trying to help. cfloop Query="Session.ShipTo" cfif Not Session.ShipTo.ShipToYes cfif Session.ShipTo.FirstName is "" or Session.ShipTo.LastName is "" or Session.ShipTo.Address1 is "" or Session.ShipTo.City is "" or Session.ShipTo.State is "" or Session.ShipTo.Zip is "" or Session.ShipTo.Country is "" cfset ErrorMessage = "You did not fill out all the required fields!" cfset display = "Yes_2" cfbreak cfelse other code /cfif /cfif /cfloop - Original Message - From: Troy M. Wussow [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 31, 2000 11:48 AM Subject: CFParam and radiobutton array validation 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_01BFCB20.00811A70 Content-Type: text/plain; charset="iso-8859-1" If anyone has experience with CFPARAM and/or radio button arrays please take a look at the interactive quiz I developed with CF. I need a way to validate the radio button arrays and I am stumped. Right now I am using the CFPARAM tag to set a default value for each array in case someone skips a question, but I would rather prompt them to go back and complete the missed question. Please goto http://www.natsem.com/quizpage1.cfm Thank you for your assistance Troy M. Wussow Web Developer - MIS National Seminars Group [EMAIL PROTECTED] -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 9:53 AM To: [EMAIL PROTECTED] Subject: RE: Frames vs NoFrames Third and final, what is your opinion of frames? likes dislikes? and have you found any limitations to using frames. You can use the application browser as an excuse if you can prove that there is more than 5% use of other browsers in the business arena. I'm one of those advocates for "Whatever works best for the site"... Out of all of our sites, roughly 50-60% have frames, and with our new technology, that's dropping... only the specifically designed sites which have special effects on them use frames, and those do it for effect rather than for real navigation Check out; http://www.in-cosmetics.com/ for a tarty effect (that menu line which was hell to build) http://www.mgscoachworks.com/ for a specific design ethic We use frames on our own site (the one we're re-working now) to keep the middle page exactly the same size - the reason? Background texture. We've got loads of non-frame sites with differing looks, but it's the re-laying out of complex pages with tables which slows down non-frame sites. Limitations on Frames (some mentioned before) Bookmarks, direct links from outside, javascript dependance on more complex sites, search engines fail to get into site Limitations on non-Frames Slow load for complex pages (with tables in tables in tables etc.), re-displaying information which stays static (menus etc.), broken table structures which break Netscape (it's very particular) IMHO, specific information loads quicker on a Frame site, but it does mess some things up. Just a few thoughts. Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- -- -- Archives: http://www.eGroups.com/list/cf-talk 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_01BFCB20.00811A70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
Re: [Re: personal oracle 8i]
Exactly! ;-) [EMAIL PROTECTED] 06/01/00 09:11AM Thanks. So you are saying that I must install the personal oracle server and personal oracle client in the same machine, and configure the CF server to connect to the database using sql net from oracle personal client? Irwan "Larry Meadors" [EMAIL PROTECTED] wrote: I got it working. Did you install the client part on the server? The default driver that comes w/NT won't do. Larry [EMAIL PROTECTED] 05/31/00 10:04AM Does anybody ever use CF server connect to Personal Oracle 8i? I tried but it can't work. -- Archives: http://www.eGroups.com/list/cf-talk 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: CF Training?
You've already got a great set of technologies under your belt. That's a good start. I've taken the FT course already, and I strongly advise taking it if you're serious about ColdFusion as a career. A fair amount of what the course covers is stuff that you've already done throughout the book (I went the same route that you did...doing Forta's book first, then FT. What I found about the class is that it cemented my CF knowledge...kind of filled in the holes. I'm now working as a CF developer for an internet startup, and loving every minute of it. I'll be taking the Adv. CF class in the next couple of months (this month, if I can manage it). Fact is, training is always a good thing, and if you're just starting out, being able to show that you're a self-starter by explaining what you're teaching yourself, as well as showing that you're investing in your own skills by paying for the courses, and that you've been trained by authorized trainers, a lot of employers will give your resume a second look in a pile of people with the same or more experience. I'd also suggest trying to go to the Allaire CF Developer's Conference later this year. It's a GREAT place to rub elbows with potential employers, as well as learn a LOT of things you won't find in books. Check out the Allaire website for more details. The other thing is to find the CFUG (ColdFusion Users Group) in your area. Another great place to find people who represent companies hiring CF developers. Some of these companies will hire with part of the offer being sending you for more CF training. Good luck... -Kev -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 10:11 PM To: [EMAIL PROTECTED] Subject: CF Training? This is a multi-part message in MIME format. --=_NextPart_000_0009_01BFCB33.E53B42A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all! I have read CFWACK4.0 cover to cover (along with doing all the = exercises) and am starting on the Advanced book. I'm wondering if I = should attend the training courses by Allaire, FT to CF and Advanced CF = development. I have starting writing applications on the side for = people, but I would like to make this my full-time career (I love this = stuff!). OK CF gurus, how do I get my foot in the door for a career in = CF? My background (I'll keep this short) is a BA in Biology with a = minor in math and some misc additional courses that mean just as little. = The important stuff I've been working on though is self-study in CF, = SQL, Visual Basic, NetObjects Fusion and Access. Please advise!! Thanks, Christine --=_NextPart_000_0009_01BFCB33.E53B42A0 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 content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; I have read = CFWACK4.0 cover to=20 cover (along with doing all the exercises) and am starting on the = Advanced=20 book.nbsp; I'm wondering if I should attend the training courses by = Allaire, FT=20 to CF and Advanced CF development.nbsp; I have starting writing = applications on=20 the side for people, but I would like to make this my full-time career = (I love=20 this stuff!).nbsp; OK CF gurus, how do I getnbsp;my foot in the door = for a=20 career in CF?nbsp; /FONTFONT face=3DArial size=3D2My background = (I'll keep this=20 short) is a BA in Biology with a minor in math and some = miscnbsp;additional=20 courses that mean just as little.nbsp; Thenbsp;important stuff I've = been=20 working on though is self-study in CF, SQL, Visual Basic, NetObjects = Fusion and=20 Access.nbsp;nbsp; Please advise!!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; Thanks,nbsp;=20 Christine/FONT/DIV/BODY/HTML --=_NextPart_000_0009_01BFCB33.E53B42A0-- -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
SQL7 + CF studio pb !
I'm brand new to SQL server 7 and I have a little pb. Each time I want to access my tables through CF studio in the database Tab, I only get the system tables and not the one I created manually. I get an error when I try to access those newly created tables. Using the SQL server query analyser I've got no problem accessing thoses tables... Could a "SQL server Guru" help me on this ? Thanks Francis. -- Archives: http://www.eGroups.com/list/cf-talk 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 ListFind
Hi All, Does anyone here know of a JavaScript function to similar to ListFind? Duane Boudreau, Project/Beta Manager, eMPower Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 Fax: 603-594-0258 -- Archives: http://www.eGroups.com/list/cf-talk 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: Jumping Sessions??
Mike, Are you running a cluster of servers by any chance? If so, you'll have to use sticky sessions in order to ensure the user doesn't get delegated to a server other then the one they started off being connected to. If you're using a cluster, you should be able to use Client variables w/a common repository for storing the client variables-which means all servers would have access to the same pool of data. (Note: I'm not 100% sure that CF4 for Solaris supports alternate Client Variable Storage, but I think it does.) Is their a proxy server being used? If so, then it could be the proxy server causing the problems. You might try passing the CFID CFTOKEN (and possibly even a unique random variable) via the URL to help ensure the uniqueness of the request. Just some ideas... -Dan ++---+ | name | Dan G. Switzer, II| |company | PengoWorks.com| |www | http://www.pengoworks.com | | mailto | [EMAIL PROTECTED] | ++---+ -Original Message- From: Michael Grundvig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 8:55 PM To: [EMAIL PROTECTED] Subject: Jumping Sessions?? I have a very interesting issue I would like to ask you all about. At work, we recently released a "poll" program that allows people to choose what type of job they would like to get. Sort of like pre-applying for either a new/your current job (hey, I dont come up with these ideas, I just implement em for the business folks!) Now here is the problem; We released this to the public yesterday. It seems to work great, but early this morning the errors rolled in. LOTS OF EM. After some diagnosing, we determined all the errors we related to one problem, session variables. To protect infomation (specifically employee numbers) we pass them via session variables. On every page, we run queries against Sybase to pull their name, infomation, etc. Now the problem is that people are "jumping" sessions. So user A will see user B information. It seems consistent, so you dont switch users from page to page, maybe once in the session, but from then on, you remain this other user. When we first saw this problem, we attempted reducing the session timeout to no avail. The sessions are all locked already and it is not experiencing any real load. We are running Solaris with Netscape Enterprise Server and Cold Fusion 4.0 installed on the same box. The database is a massive Sybase system running on its own environment. Sessions are being done without URL variables. This is the ONLY thing we are storing in the session variable. This is a real concern and its very important that we solve this as some people in the company are already fighting against Cold Fusion in favor of Java and this error makes CF look awful as it was a high profile failure. I contacted Allaire only to be told to open a ticket and have posted a message on the forums with a few responses but no solutions. Any help would be greatly appreciated! Thanks!! Mike Grundvig P.S. All people using the application are on NS 4.7 with cookies enabled. This is all intranet based on Mac and PC systems, including NT. -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Forcing a page to refresh on back-up
Put these tags at the beginning of the file you don't want cached: CFHEADER name="expires" value="0" Cfheader name="Cache-Control" value="no-cache" cfheader name="Pragma" value="no-cache" At 11:59 PM 5/31/00, you wrote: I sure hope someone's still awake! I'd like a page to refresh if a user uses his/her "back" button to get to it. I don't want the previous form information filled in once they've submitted, then backed up. I searched for an easy solution tonight, but must have been looking in the wrong places, Thanks Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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. Joel Richards Web Developer Brainstorm Industries http://www.brainstormin.net/[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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 Training?
Join a startup or any firm that will take you as a web developer (HTML, CFML, SQL, VB, etc). Ideally they will already have a senior CF developer that you can pick up a few things from. You'll want to get at least 12-18 months under your belt after which you can pick which company you want to join. In my case I came from an econ background, took 8 months of classes in C/C++ at GWU, and was asked up by a startup web firm/friends to do HTML, ASP and CF.. so basically self taught as are a lot of people here. Just remember not to shy away from the challenging stuff, or stuff you haven't done. Thats where you learn the most. Hi all! I have read CFWACK4.0 cover to cover (along with doing all the = exercises) and am starting on the Advanced book. I'm wondering if I = should attend the training courses by Allaire, FT to CF and Advanced CF = development. I have starting writing applications on the side for = people, but I would like to make this my full-time career (I love this = stuff!). OK CF gurus, how do I get my foot in the door for a career in = CF? My background (I'll keep this short) is a BA in Biology with a = minor in math and some misc additional courses that mean just as little. = The important stuff I've been working on though is self-study in CF, = SQL, Visual Basic, NetObjects Fusion and Access. Please advise!! Thanks, Christine --=_NextPart_000_0009_01BFCB33.E53B42A0 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 content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; I have read = CFWACK4.0 cover to=20 cover (along with doing all the exercises) and am starting on the = Advanced=20 book.nbsp; I'm wondering if I should attend the training courses by = Allaire, FT=20 to CF and Advanced CF development.nbsp; I have starting writing = applications on=20 the side for people, but I would like to make this my full-time career = (I love=20 this stuff!).nbsp; OK CF gurus, how do I getnbsp;my foot in the door = for a=20 career in CF?nbsp; /FONTFONT face=3DArial size=3D2My background = (I'll keep this=20 short) is a BA in Biology with a minor in math and some = miscnbsp;additional=20 courses that mean just as little.nbsp; Thenbsp;important stuff I've = been=20 working on though is self-study in CF, SQL, Visual Basic, NetObjects = Fusion and=20 Access.nbsp;nbsp; Please advise!!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; Thanks,nbsp;=20 Christine/FONT/DIV/BODY/HTML --=_NextPart_000_0009_01BFCB33.E53B42A0-- -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: shopping cart?
CFTRANSACTION refers to database transactions not shopping transactions. Although the first time I saw it the first thing that popped into my head was credit card transactions. Sounds like what you're doing is pretty simple. A few CFMAIL's and an INSERT and your order is placed. The more difficult part is product management, shipping costs, etc. Just take it step by step, it won't be too bad. Hi I'm looking to do my first shopping cart w/ CF. As the merchant for whom the site is being built doesn't accept credit cards, "submit order" is simply going to send a few emails and store some records in the database. Can anyone give me a few pointers on the best way to do this? Would CFTRANSACTION be useful? Thanks! * John * -- Archives: http://www.eGroups.com/list/cf-talk 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: Gold Points CF site
If you get in touch with them tell them to make that image on the left a jpeg, that 93k gif is nasty. Sorry, i couldn't help myself. --Ric Smith - Original Message - From: Scott Beach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 01, 2000 1:20 AM Subject: Gold Points CF site Hey gang- I'm trying to get hold of anyone currently working on the Goldpoints.com site. Thanks. Scott Beach [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Another question on performance -- better than lists?
ok... so when it comes to performance, it's better to use strutctures than arrays and both of those are better than lists. i thought lists were always fastest. is this not true? when did this happen? mike -- Archives: http://www.eGroups.com/list/cf-talk 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: Debug info - can one limit it...
1) Can you restrict it to a range of IPs in any way other than entering in each single IP? Unfortunately, no. 2) Can you, in the code in a particular page, instruct the server NOT to display debug info for that particular page? Yes. You can use the CFSETTING tag: CFSETTING SHOWDEBUGOUTPUT="FALSE" Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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: Jumping Sessions??
First off thanks for the responses and the suggestions thus far. To answer the questions: Is their a proxy server being used? 1. Not that I know of, but a proxy DOES reside on the intranet and I assume it could be possible all web requests are going through it or through our intranet firewall, even the local ones. Would a firewall cause the same problem? I dont believe it does any sort of caching at all... If this is possible, can someone explain how it would happen as I need to pawn off why it isnt Cold Fusions fault and really a network bug? My boss didnt like that suggestion, in his opinion, he felt it was more likely that Cold Fusion just isnt any good and this is a CF bug. Are you running a cluster of servers by any chance? 2. No, we are not on a clustered environment. The one time I've seen this happen was when the server admin didn't do a complete uninstall of an earlier version of cf server before upgrading. Somehow, there were two sets of session variables, and the variables didn't _really_ get set until the second time. (So, people had to double log in, etc.) 3. No, we have never reinstalled the servers, this is a fresh installation. Thanks again! Mike Grundvig P.S. Another thing to note is that we did encounter this once before using the Broadvision programming language. Internal network only, we were not able to duplicate this issue on the outside world. A call to allaire concerning our problem did reveal the possibility that this is a CF bug and that they did not have any direct suggestions without opening an "issue" with them. Lets not get on that though, its a pet peeve ;) -- Archives: http://www.eGroups.com/list/cf-talk 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: Query Cache Limit Question
Finally, I'd like to point out that many kinds of "what if" questions, commonly asked on the list, are best answered with five minutes of testing. Perhaps Allaire could also take this approach when writing their docs? :) From the current v4.5.1 Online Docs regarding Cache Settings in CF Administrator: "Limits the maximum number of cached queries that the server will maintain. Cached queries allow for retrieval of result sets from memory rather than through a database transaction. The maximum number of cached queries allowed at any given time is 100. When this value is reached, the oldest query is dropped from the cache and replaced with the specified query." That's likely where the mis-guided info originated. That does sound like a likely culprit. On the other hand, maybe I've got the only double-secret version of CF 4.5.1 which allows more than 100 queries! I looked in the documentation, but didn't find that earlier. I guess this just supports Ronald Reagan's adage, "Trust, but verify." Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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.
Is there a typical cause for this error message?
Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.
Application Variables Questions
I have two Applications "App1" and "App2" on my ColdFusion Server4.5 in separate directories. I have defined corresponding DSN's for these applications which are "App1DSN" and "App2DSN". The Appliction Names and corresponding DSN's are defined in their corresponding Application.cfm files in their corresponding directories. The DSN's are defined in Application Variable "Application.DSN" and are "Application" Scoped. The locks are "Exclusive" when DSN's are set and "ReadOnly" when read. Problem: App2 sometimes complains of not finding tables in DSN "App1DSN" which is strange as it is looking for App1's DSN. I can work around by naming the DSN's differently but my understanding was that these two memory variables should have been protected from their respective Application Names. Am I wrong? Has somebody seen this problem? Any resolutions? Thanks, Bob Thanks, Bob Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Replacing line breaks and paragraph breaks with HTML equivelents
Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What am I missing. Thanks Lee -- Archives: http://www.eGroups.com/list/cf-talk 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: browser detection
Hello Britta,
I use this code to detect the browser on the server side, it may work
for you
-- code
CFSET ApprovedBrowsers = "IE,NS"
CFSET BrowserOS = ""
CFSET BrowserType = "NS"
CFSET BrowserVersion = -1
CFSET BrowserVersionMajor = -1
CFSET BrowserVersionMinor = -1
CFSET UserAgentPosition = 0
CFLOOP INDEX="BrowserInfo" LIST="#CGI.HTTP_USER_AGENT#" DELIMITERS=";()"
CFSET UserAgentPosition = UserAgentPosition + 1
CFIF UserAgentPosition EQ 1
CFSET BrowserVersion = Trim( BrowserInfo )
CFSET FirstSpace = Find(" ", BrowserVersion, 1)
CFIF FirstSpace EQ 0
CFSET FirstSpace = Len(BrowserVersion)
/CFIF
CFSET BrowserVersion = Trim( Mid(BrowserVersion,9,FirstSpace) )
CFSET FirstSpace = Find(" ", BrowserVersion, 1)
CFIF FirstSpace NEQ 0
CFSET BrowserVersion = Left(BrowserVersion,FirstSpace)
/CFIF
CFELSE
CFIF FindNoCase("MSIE",BrowserInfo,1) NEQ 0
CFSET BrowserType = "IE"
CFSET BrowserVersion = Trim( BrowserInfo )
CFSET FirstSpace = Find(" ", BrowserVersion, 1)
CFIF FirstSpace EQ 0
CFSET FirstSpace = Len(BrowserVersion)
/CFIF
CFSET BrowserVersion = Trim( Mid(BrowserVersion,6,FirstSpace)
)
CFELSEIF FindNoCase("Win",BrowserInfo,1) NEQ 0
CFSET BrowserOS = "Windows"
CFSET BrowserOS = BrowserOS Right( Trim(BrowserInfo),2 )
/CFIF
/CFIF
/CFLOOP
CFSET Browser_VersionMajor = Left(BrowserVersion,1)
CFSET Browser_VersionMinor = BrowserVersion
CFSET Browser_Version = BrowserVersionMajor
CFSET Browser_Type = BrowserType
!---
CFOUTPUT
#CGI.HTTP_USER_AGENT#
BR
#Browser_VersionMajor#
BR
#Browser_VersionMinor#
BR
#Browser_Version#
BR
#BrowserOS#
BR
#Browser_Type#
/CFOUTPUT
---
-- End code
Hope this help
Wednesday, Wednesday, May 31, 2000, you wrote to me:
BW Anyone know of a way to write a statement like this that works?
BW This is the idea: I need to write an "if" statement based on if netscape is
BW being used. I would like to use the HTTP_USER_AGENT like this:
BW cfif HTTP_USER_AGENT IS NOT ""
BW cfif HTTP_USER_AGENT LIKE '%netscape%'
BW put netscape version here/cfif
BW cfif HTTP_USER_AGENT LIKE '%ie%'
BW put ie version here/cfif
BW /cfif
BW Any help is much appreciated!
BW Britta
BW --
BW Archives: http://www.eGroups.com/list/cf-talk
BW 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,
Mike Hughes
Freelance Cold Fusion Applications Developer
mailto:[EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
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: SQL7 + CF studio pb !
I'm not exactly a guru but it sounds like the login info specified in your ODBC connection being used in CF studio does not have the proper permissons set up to see those particar tables. You might try going into sql enterprise manager and double clicking on the table you want to see. There you will see a permisissions button on the upper right hand cornor of the pop up properties box. Click on it and you will be able to specify permissions for that table to the user specified in your ODBC connection. I'm could be wrong. I'm just shootin from the hip here. Lee - Original Message - From: Francis NART [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 01, 2000 9:54 AM Subject: SQL7 + CF studio pb ! I'm brand new to SQL server 7 and I have a little pb. Each time I want to access my tables through CF studio in the database Tab, I only get the system tables and not the one I created manually. I get an error when I try to access those newly created tables. Using the SQL server query analyser I've got no problem accessing thoses tables... Could a "SQL server Guru" help me on this ? Thanks Francis. -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
Webserver and ColdFusion mappings
Can anyone shed a little light on webserver and ColdFusion mappings? Whilst a site is being developed I set up a webserver and ColdFusion mapping on the PC such as /newsite/ which points to the d:\websites\newsite\website\ directory. Then, you can browse to http://127.0.0.1/newsite/ and view the website. If you set an application variable such as application.Mapping to "/newsite/", you can then write any link as A HREF="#application.Mapping"anysubdir/filename.cfm" and it works OK. But, when the site goes live and the Network admin sets up the directories and mappings for the site, the links end up as http://www.newsite.com/newsite/anysubdir/filename.cfm when I really want them to be http://www.newsite.com/anysubdir/filename.cfm I know something's going wrong here, but can anyone explain how absolute mappings should be set up so that you don't have to change anything when the site goes live and so that the URLs don't end up like http://www.fishingtackletrader.com/fishingtackletrader/advertise/index.cfm like they do at the moment (fishingtackletrader is the value for application.Mapping in that instance). Thanks (a million) -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.co.uk/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.eGroups.com/list/cf-talk 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.
cfadminsecurity tag
Hi! I've been playing with cfadminsecurity tag with some success. I'm still trying to define the realms, which maps to the resource types enabled for a security context. The information saved into the realm table of SiteMinder seems to be ok, but when I open the security context page from CF Admin, the resource type checkbox is not ckecked as expected, and it is not available when creating a rule. Anyone willing to share some information about this? Thanks in advance, Marcello Frutig. -- Astrolabio -- Archives: http://www.eGroups.com/list/cf-talk 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.
CFMAIL Spooling Time..
Hello folks, Someone informed me of a new parameter for CFMAIL that would allow me to change the time that messages stayed in the Mail Spool on the server, enabling me to set this value. I've checked in the New Features for 4.5.1 CF Professional, and I haven't seen any mention made of this. Do any of you have any information on this? -Gel -- Archives: http://www.eGroups.com/list/cf-talk 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: open window (JS)
Thank you, thank you, thank you... I didn't realize void() was an option... thanks! It works perfectly! Jason Egan Konnections, INC. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 10:39 PM To: [EMAIL PROTECTED] Subject: Re: open window (JS) In the A HREF tag do this: A HREF="Javascript:void()" onClick="function()"" Dave - Original Message - From: Jason Egan [EMAIL PROTECTED] To: Cf-Talk [EMAIL PROTECTED] Sent: Wednesday, May 31, 2000 2:08 PM Subject: open window (JS) I am trying to open a image preview window - I've used fusebox to the best of my ability. I am also using a '/' for url parameters rather than '? =' .. I have a url as such: admin/index.cfm/fuseaction/properties/propid/CB1 This page contains a link to open a window - the window opens and displays correctly, but the link has to point somewhere, so I put the same url as the href="index.cfm/fuseaction/properties/propid/CB1" - reloading the page is probably unnecessary. If I use #'s in the href like you normally would then the page displayed is like have a url of: admin/index.cfm. Any pointers on how I can open the window and not reload the page? Thanks, je -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
MsSQL7 problem backing up on tape
hi everyone, I am running MsSQL 7 sp2 on a standalone box with a HP Colorado 8 Gig internal IDE tape drive. The scheduler w/MsSQL has been working but when I try to restore or do a manual backup to the tape drive I get this: Microsoft SQL-DMO (ODBC SQLState 42000) The media family on device "\\.\Tape0" is incorrectly formed. SQL Server cannot process this media family. Backup or restore operation terminating abnormally. I can backup the databases to the hard drive with no problem. Has anyone seen this before? [EMAIL PROTECTED] X-Net Web Systems www.x-net.com - This mail sent through IMP: x-net.com -- Archives: http://www.eGroups.com/list/cf-talk 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: Jumping Sessions??
Hello, I had a very similar thing happen to me (I just started learning CF about 3 weeks ago so take this with some salt): I set debugging on for my IP address. After running the application a couple of times I found that my SQL queries were working with the wrong info ( I also had another person access the application at the same time as I was). I had a member id being generated when a new member wanted to register to the site. The query that obtained the new id did not use the unique sessionid of the current user, therefore if two users were at the same page at the same time there was the possibility of them getting the member id's mixed up. I fixed the queries and I have not had a problem since. Maybe not the same situation but just in case, but I hope it helps. cheers, Nelson. Michael Grundvig wrote: I have a very interesting issue I would like to ask you all about. At work, we recently released a "poll" program that allows people to choose what type of job they would like to get. Sort of like pre-applying for either a new/your current job (hey, I dont come up with these ideas, I just implement em for the business folks!) Now here is the problem; We released this to the public yesterday. It seems to work great, but early this morning the errors rolled in. LOTS OF EM. After some diagnosing, we determined all the errors we related to one problem, session variables. To protect infomation (specifically employee numbers) we pass them via session variables. On every page, we run queries against Sybase to pull their name, infomation, etc. Now the problem is that people are "jumping" sessions. So user A will see user B information. It seems consistent, so you dont switch users from page to page, maybe once in the session, but from then on, you remain this other user. When we first saw this problem, we attempted reducing the session timeout to no avail. The sessions are all locked already and it is not experiencing any real load. We are running Solaris with Netscape Enterprise Server and Cold Fusion 4.0 installed on the same box. The database is a massive Sybase system running on its own environment. Sessions are being done without URL variables. This is the ONLY thing we are storing in the session variable. This is a real concern and its very important that we solve this as some people in the company are already fighting against Cold Fusion in favor of Java and this error makes CF look awful as it was a high profile failure. I contacted Allaire only to be told to open a ticket and have posted a message on the forums with a few responses but no solutions. Any help would be greatly appreciated! Thanks!! Mike Grundvig P.S. All people using the application are on NS 4.7 with cookies enabled. This is all intranet based on Mac and PC systems, including NT. -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Cflocation inside of a cftransaction
In one of my pages I have a few insert queries that I run inside of a cftransaction. Depending on the results I did have a cflocation tag to redirect them to a outcome page. They would get redirected fine, but the insert queries would not run properly, as in they wouldn't write to the table. Is this because the cflocation has the ability to break a cftransaction block Yes, when CFLOCATION is processed, nothing else in that page following the CFLOCATION is processed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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.
recordset in string to INSERT query
This is probably a no-brainer... Through CFHTTP, I acquired a list of Java Applet parameters. I parsed this string down to a recordset of over 100 records. How do I write this recordset (Each field is delimited by a TAB, each record by CRLF) to an existing database table with the same number of fields using CF? ___ Robert M. Saxon, Jr. (Rob), Senior Web Developer Mercer University Department of Web Management TSS // 1400 Coleman Avenue // Macon, GA 31207 912-301-5550 voice // 912-301-5314 fax [EMAIL PROTECTED] Philippians 4:13 -- Archives: http://www.eGroups.com/list/cf-talk 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.
Slightly OT
Does anyone have experience with homesite? I need to recommend a SIMPLE wysiwyg editor to a customer of mine. Is Homesite Wysywyg or an HTML editor?, and if it's html, can anyone recommend a simple wys...editor BESIDES front page? Thanks, Jeffrey Cohen ImageWorks -- Archives: http://www.eGroups.com/list/cf-talk 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.
office COM
Ive seen mentioned earlier on the list using MS Office products as COM objects == can anyone point me towards more information on this? Is it server extensions only available in 2k? Thanks, je -- Archives: http://www.eGroups.com/list/cf-talk 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.
Update Query
How can I specify which row in my table I want to update if the user has the ability to change every field. Is there any way besides making an autoNumber field? I have an Access DB. Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
query help - find duplicates
Im trying to create a primary key and cannot because I have a few duplicate entries. There should not be any so I am trying to find them. The key consists of 2 fields(po,line), Im trying to run a query that will only display the duplicates, this is what Im trying. SELECT po,line from table where po = po AND line = line how can I change this so it only display's the duplicate entries? -Adrian -- Archives: http://www.eGroups.com/list/cf-talk 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: CFSILENT not working?
What do you mean that the server yelled at you? Do you mean an error message was displayed? If so can we see it? --K Katrina Chapman Consultant Ameriquest Mortgage "Pablo Nevares" To: [EMAIL PROTECTED] pnevares@hpacc: pts.com Subject: CFSILENT not working? 05/31/00 02:36 PM Please respond to cf-talk I tried using cfsilent to suppress the output of an ArrayAppend() function, and CF server yelled at me. =) Apparently it doesn't recognize the tag, which sort of goes along with the fact that CF Studio doesn't try to autocomplete when I type cfsil Anyone else have this problem? Both apps are v4.5. Pablo Nevares Information Technology Hendricks Partners [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Post Time
Just curious, is it a known fact that when you post something to this list, it doesn't show up for about 5 hours? or is it something else. Seems like every time I have posted anything in the past that is a reply to someone else, it shows up about 5-6 hours later Shane -- Archives: http://www.eGroups.com/list/cf-talk 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: I want my #$# on the first of the month.
Oh Geez! hee hee hee You're right..FirstDayOfMonth IS a function. ;-P Anyways..the code examples were nice all the same I guess ;-P -Gel - Original Message - From: Robert Everland [EMAIL PROTECTED] Or you could try this, maybe I'm crazy just seems easier FirstDayOfMonth( date). Love the old 4.0 documentation, bookmarks anyone remember those, is Allaire ever gonna give em back in the 4.5 documentation. Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.eGroups.com/list/cf-talk 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.
CFHTTP
Does a CFHTTP request work when the file is on the same exact server? TIA. == - == == - ==== - == Allen Graetz USI - Web Application Programmer 1-800-USINTERNET x241 612-253-3241 -- Archives: http://www.eGroups.com/list/cf-talk 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: Another question on performance -- better than lists?
i thought lists were always fastest. is this not true? when did this happen? It is my understanding that lists are stored in memory as string values, and that looping through a list (or direct access of a specific list element) ultimately results in a character-by-character iteration through the string. Arrays on the other hand are stored in memory differently so that elements can be directly accessed (such as arArray[23]) without a linear search or progression. In other words, the performance of list functions depends heavily on the amount of data in the list. More data = slower results. The performance of array functions is not affected by the number of array elements. This is why arrays are recommended over lists when dealing with anything other than a trivial amount of data. At least, this is the way that most languages are ultimately compiled into machine code. I don't know if this applies 100% to CF or not. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
yes. it's usually seen when you try to insert into a TEXT field in the DB that is too short for the value being insert. ex, inserting the string "Hello world" into a CHAR(4) field. Chris Olive, DOEHRS Website Administrator -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
Yeah your field name is too small for the data you want inserted in it. In other words check the size of your fields or maybe you switched a couple variables by accident that happened to me one time, spent an hour trying to figure out why it was giving me this message when all the sizes were right and that was all it was. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
At 10:43 AM 6/1/00 -0400, you wrote: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). The data that you are trying to send to the database is either longer than the allowed length of the field or it's over the 4k literal text string limit. -- Archives: http://www.eGroups.com/list/cf-talk 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: Replacing line breaks and paragraph breaks with HTML equivelents
I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") If you're trying to replace carriage returns with BR tags, you've got the argument order backwards. It should be: Replace(strClean, Chr(13), "BR", "ALL") Also, you may want to remove line feeds as well, if they're in your data. If you don't, nothing bad should happen, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk 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: Replacing line breaks and paragraph breaks with HTML equivelents
switch around the position of the br and Char(13) -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 11:03 AM To: ColdFusion Discussion List Subject: Replacing line breaks and paragraph breaks with HTML equivelents Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What am I missing. Thanks Lee -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
the string you are trying to insert/update is larger than the column allows. -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Replacing line breaks and paragraph breaks with HTML equivelents
Here's an option from the Docs: - ParagraphFormat Returns string with converted single newline characters (CR/LF sequences) into spaces and double newline characters into HTML paragraph markers (P). - I wish they'd do one that replaces single newline characters with BR, but maybe that's just asking to much. =) Pablo Nevares Information Technology Hendricks Partners [EMAIL PROTECTED] -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 8:03 AM To: ColdFusion Discussion List Subject: Replacing line breaks and paragraph breaks with HTML equivelents Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What am I missing. Thanks Lee -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
You are trying to insert data that has too many characters for the database field. Increase the allowable size of the field in the Database, or else limit the number of characters allowed to insert into the field by using the "Maxlength" attribute in your form field (assuming it is a text input type field). Hope this helps. Joel At 08:43 AM 6/1/00, you wrote: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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. Joel Richards Web Developer Brainstorm Industries http://www.brainstormin.net/[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
ODBC Error Code = 22001 (String data right truncation) You may have single quotes around a number or a date. -- Lee Surma Public Radio International [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk 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: Jumping Sessions??
At 07:55 PM 5/31/00 -0500, Michael Grundvig wrote:
...
Now here is the problem; We released this to the public yesterday. It seems
to work great, but early this morning the errors rolled in. LOTS OF EM.
After some diagnosing, we determined all the errors we related to one
problem, session variables. To protect infomation (specifically employee
numbers) we pass them via session variables. On every page, we run queries
against Sybase to pull their name, infomation, etc. Now the problem is that
people are "jumping" sessions. So user A will see user B information. It
seems consistent, so you dont switch users from page to page, maybe once in
the session, but from then on, you remain this other user. When we first saw
this problem, we attempted reducing the session timeout to no avail. The
sessions are all locked already and it is not experiencing any real load. We
are running Solaris with Netscape Enterprise Server and Cold Fusion 4.0
installed on the same box. The database is a massive Sybase system running
on its own environment. Sessions are being done without URL variables. This
is the ONLY thing we are storing in the session variable. This is a real
concern and its very important that we solve this as some people in the
company are already fighting against Cold Fusion in favor of Java and this
error makes CF look awful as it was a high profile failure. I contacted
Allaire only to be told to open a ticket and have posted a message on the
forums with a few responses but no solutions. Any help would be greatly
appreciated!
Here's an idea I picked up from this list. When you initialize your
session, do this:
cfset session.remote_addr = cgi.remote_addr
Then, in application.cfm, add this:
cfif isDefined("session.remote_addr") AND cgi.remote_addr NEQ
session.remote_addr
!--- SESSION JUMP, handle it however you want ---
/cfif
This may help you pinpoint the problem. However, it may also cause other
problems; note the following from Michael Sheldon:
Some proxy servers, most notably AOL's, will rotate through several IP
addresses
in a single session. The worst I've seen so far was an AOL user who's
requests came from 15 different IP addresses in 15 consecutive requests.
If you can determine any more details about when this is happening, please
post.
Gregory M. Saunders, Ph.D.
Senior Design Architect
Cognitive Arts Corporation (http://www.cognitivearts.com)
120 S. Riverside Plaza, Suite 1520
Chicago, IL 60606
--
Archives: http://www.eGroups.com/list/cf-talk
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: Replacing line breaks and paragraph breaks with HTML equivalents
Try: ReplaceNoCase(strClean, Chr(13), "br", "ALL") From CF Docs: ReplaceNoCase(string, substring1, substring2 [, scope ]) string Any string. substring1 String to be replaced. substring2 String that should replace occurrences of substring1. scope Defines how to complete the replace operation: ONE -- Replace only the first occurrence (default). ALL -- Replace all occurrences. Duane Boudreau, Project/Beta Manager, eMPower Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 Fax: 603-594-0258 -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 11:03 AM To: ColdFusion Discussion List Subject: Replacing line breaks and paragraph breaks with HTML equivelents Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What am I missing. Thanks Lee -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
Yes. Your input data is too long for the database column. You should really validate inputs for length (and type, too). E.g. if you had a varchar(64) column called Title, do this: ... cfif Len(Trim(form.title)) GT 64 ... output an error msg to the user ... cfelse ... go ahead and do the query ... /cfif ... Interestingly enough, Allaire's very own Forums will barf with the string data right trunc error message if you put a long subject line in your posting. Repeat to yourself thirty-two times: "I will not pass unchecked data to my database." :) Chris Tweney Media Application Developer roundpeg www.roundpeg.com 1700 California Suite 260 San Francisco, CA. 94109 Ph. 415-437-3900 Fax 415-437-3904 -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 7:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
The data that you're trying to input into the field is too long. Either increase the size of the field or reduce the length of the data. --K Katrina Chapman Consultant Ameriquest Mortgage Steve Weiner Steve@TeleImTo: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] age.com cc: Subject: Is there a typical cause for this error message? 06/01/00 07:43 AM Please respond to cf-talk Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
The size of the form field or data field you are inserting is larger than the size of the field you have created in SQL server. Aaron -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 7:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Replacing line breaks and paragraph breaks with HTML equivelents
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 01, 2000 1:03 PM Subject: RE: Replacing line breaks and paragraph breaks with HTML equivelents If you're trying to replace carriage returns with BR tags, you've got the argument order backwards. It should be: Replace(strClean, Chr(13), "BR", "ALL") Thanks Dave. I feel kind of silly. I guess I just needed a second pair of eyes. Also, you may want to remove line feeds as well, if they're in your data. If you don't, nothing bad should happen, though. This may be a stupid question but what is a line feed? Lee PS. I took The advanced CF class with you last summer in New York. You were an outstanding teacher. -- Archives: http://www.eGroups.com/list/cf-talk 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: Replacing line breaks and paragraph breaks with HTML equivelents
You just have the arguments backwards. This is the fix: ReplaceNoCase(strClean, Chr(13), "BR", "ALL") -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 8:03 AM To: ColdFusion Discussion List Subject: Replacing line breaks and paragraph breaks with HTML equivelents Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What am I missing. Thanks Lee -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Another question on performance -- better than lists?
I just ran some tests, and was surprised by the results. Caveats: 1) These are simple looping tests, and only give a general idea of speed. YMMV. 2) Use the most reasonable variable type for the job. Converting a list to an array to use array functions may negate any performance gains you may see. If you are looking for a value, and you only know its name, use a structure. The tests: I created a series of simple loop statements for each variable type: Queries, Arrays, Structures, and Lists. They were all equivalent to a 2-dimensional array. Each "Set" loop consisted of 5000 iterations. I then created another set of loops of 100 iterations to grab some values. Summary: I expected Structures to be fastest, but that honor went to Arrays. Arrays are followed closely by Queries. Structures were a little slower, and lists took *forever*. Structures are very powerful, and definitely have performance gains if you are dealing with keys/values, but are not inherently faster. Results: Query Set Time: 3515 ms Query Get Time: 10 ms Array Set Time: 3174 ms Array Get Time: 10 ms Struct Set Time: 5368 ms Struct Get Time: 20 ms List Set Time: 47248 ms List Get Time: 711 ms If anybody wants to see the test code, let me know and I'll mail it offlist. If anybody else has done any testing, I would like to see those results as well. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:21 AM To: [EMAIL PROTECTED] Subject: RE: Another question on performance -- better than lists? ok... so when it comes to performance, it's better to use strutctures than arrays and both of those are better than lists. i thought lists were always fastest. is this not true? when did this happen? mike -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Replacing line breaks and paragraph breaks with HTML equivelents
I believe that you have the two strings mixed up. In your code, every "br" is replaced with Chr(13), not the other way around... Hope I'm reading it right... Serge - Original Message - From: Lee Moore [EMAIL PROTECTED] To: ColdFusion Discussion List [EMAIL PROTECTED] Sent: Thursday, June 01, 2000 10:02 AM Subject: Replacing line breaks and paragraph breaks with HTML equivelents Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What am I missing. Thanks Lee -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
From: Steve Weiner [mailto:[EMAIL PROTECTED]] Subject: Is there a typical cause for this error message? [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. Is the data you are inserting longer than your column width? Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market your lists on the Net! [EMAIL PROTECTED] 941-541-9000 Ext. 210 -- Archives: http://www.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). This error means exactly what it says on the tin... "String or binary data would be truncated." - The string would be cropped before it goes into the table. Since SQL Server has got error detection for things like this, while Access doesn't, it's warning you that the string you're trying to enter into the table is too long... Either shorten the string, or lengthen the field (varchar's can be upto 4096 characters long) HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk 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: Is there a typical cause for this error message?
Yes, A typical cause is the data being inserted too long. Check the length of the column in the database and your data validation. HTH Sean -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) -- Archives: http://www.eGroups.com/list/cf-talk 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: shopping cart?
Look at Web monkey, they have a nice tutorial on how its done; http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming Ben Fortas book has another example in it. There are a couple others floating around that I can't remember, and there might even be an app on Allaires developers site already done for you. Hope that helped... Jeff . Hi I'm looking to do my first shopping cart w/ CF. As the merchant for whom the site is being built doesn't accept credit cards, "submit order" is simply going to send a few emails and store some records in the database. Can anyone give me a few pointers on the best way to do this? Would CFTRANSACTION be useful? Thanks! * John * -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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 logins, authenticate against Novell NDS???how?
Don't forget LDAP with NDS. With NDS8 and CF 4.5 it is blazingly fast and 4.5 supports SLDAP for security. Lanny Larry Meadors [EMAIL PROTECTED] Wednesday, May 31, 2000 We've used NDS for NT and basic authentication. That works pretty well because the NDS users get replicated as NT users. Easy to set up too. With CF 4.5's enhancements to cfheader, you can really use any data source to do basic authentication. We're also looking into using Novell's ODBC driver for NDS and there's also an ActiveX control that might work. Note: ODBC and ActiveX are not supported with CF by Novell (translation: "If it works, great, but if it doesn't, tough."). There are also some JAVA classes from Novell that are supposed to work with the NDS. You might be able to use them (potentially from a cfx) to create other authentication schemes. Fun fun fun! Larry [EMAIL PROTECTED] 05/31/00 08:45AM Does any one have any info on how to use NDS to build in a login to a cf app? My maneger wants me to start working with real authenticated user info, instead of just Data that i have enterd into a mdb. i dont really know where to start. any Guidence would be wonderful! -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
