Re: Amazon Tags
cfparam name="attributes.book" default="???"
cfparam name="attributes.affid" default=""
cfhttp method="get"
url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigroup/#attributes.affid#"
resolveurl="yes"
cfset filepath="C:\www\content\books"
cfset content = cfhttp.filecontent
cfset startpos = FindNoCase("/exec/obidos/handle-buy-box=", Content)-50
cfset startpos = FindNoCase("form", Content, startpos)
cfset endpos = FindNoCase("/form", Content,startpos)+7
cfset Content = Trim(Mid(Content, startpos, endpos - startpos))
CFSET Content =
replacenocase(Content,"/g/detail/addtocart","http://www.amazon.com/g/detail/addtocart","ALL")
CFSET Content =
replacenocase(Content,"/g/gift-services/buttons/addtoWL","http://www.amazon.com/g/gift-services/buttons/addtoWL","ALL")
CFFILE ACTION="Write"
FILE="#filepath#\#attributes.book#.html"
OUTPUT="#content#"
From: Stuart Duncan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Amazon Tags
Date: Wed, 21 Jun 2000 10:27:13 -0700
Hey all,
I've come across a few interesting tags for searching through Amazon's
books and such
but what I really need is something which allows me to actually select
individual books and display those on the site.
I was thinking, something where I could just enter the product id form
Amazon, and the tag would go and fetch all the information from them on
that book.
Has anyone come up with an easy way to do this, or do you know of any
custom tags that does this?
Any help on this would be greatly appreciated.
Stuart Duncan.
--
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: Arrays, databases, and WDDX
I have the datetime set in the database to automatically set it whenever a
new record is made so I don't have to worry about it anymore.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
You mentioned "datetime" in your text - where is it used in the code?
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a CFWDDX tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
CFSET ProductIDArray=ArrayNew(2)
CFSET ProductIDArray[1][1] = "Case"
CFSET ProductIDArray[1][2] = #Case#
CFSET ProductIDArray[2][1] = "CPU"
CFSET ProductIDArray[2][2] = #CPU#
CFSET ProductIDArray[3][1] = "RAM"
CFSET ProductIDArray[3][2] = #RAM#
CFSET ProductIDArray[4][1] = "HardDrive"
CFSET ProductIDArray[4][2] = #HardDrive#
CFSET ProductIDArray[5][1] = "Floppy"
CFSET ProductIDArray[5][2] = #Floppy#
CFSET ProductIDArray[6][1] = "Monitor"
CFSET ProductIDArray[6][2] = #Monitor#
CFSET ProductIDArray[7][1] = "VideoCard"
CFSET ProductIDArray[7][2] = #VideoCard#
CFSET ProductIDArray[8][1] = "CDROMorDVD"
CFSET ProductIDArray[8][2] = #CDROMorDVD#
CFSET ProductIDArray[9][1] = "CDRecorder"
CFSET ProductIDArray[9][2] = #CDRecorder#
CFSET ProductIDArray[10][1] = "ZipDrive"
CFSET ProductIDArray[10][2] = #ZipDrive#
CFSET ProductIDArray[11][1] = "SoundCard"
CFSET ProductIDArray[11][2] = #SoundCard#
CFSET ProductIDArray[12][1] = "Speakers"
CFSET ProductIDArray[12][2] = #Speakers#
CFSET ProductIDArray[13][1] = "Modem"
CFSET ProductIDArray[13][2] = #Modem#
CFSET ProductIDArray[14][1] = "NetworkCards"
CFSET ProductIDArray[14][2] = #NetworkCards#
CFSET ProductIDArray[15][1] = "Scanner"
CFSET ProductIDArray[15][2] = #Scanner#
CFSET ProductIDArray[16][1] = "DigitalCamera"
CFSET ProductIDArray[16][2] = #DigitalCamera#
CFSET ProductIDArray[17][1] = "Printer"
CFSET ProductIDArray[17][2] = #Printer#
CFSET ProductIDArray[18][1] = "OperatingSystem"
CFSET ProductIDArray[18][2] = #OperatingSystem#
CFSET ProductIDArray[19][1] = "Keyboard"
CFSET ProductIDArray[19][2] = #Keyboard#
CFSET ProductIDArray[20][1] = "Mouse"
CFSET ProductIDArray[20][2] = #Mouse#
CFIF IsDefined('Software')
CFSET ProductIDArray[21][1] = "Software"
CFSET ProductIDArray[21][2] = #Software#
/cfif
CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX"
CFQUERY datasource="bwpc" name="InputQuoteData"
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
/CFQUERY
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
--
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.
RE: Verity book-like index idea...
Scott,
If you use a DOS command prompt window and go to the 'Verity' directory
under your CF main directory, and then run the program mkvdk from the 'bin'
directory:
eg
c:\coldfusion\verity..\bin\mkvdk
you will be able to access a number of Verity embedded functions (a
function list is displayed if you simply call the exe without parameters)
that are not otherwise available. Amongst other things you can dump a
collection's index which seems to be what you want to do.
Note that some of the functions and results can be obscure if you have not
worked with other Verity programs. You could also look at the various
configuration files that verity uses while building indexes etc. (see
..\verity\common\custom\style\ custom file). The comments in these files
can be enlightening but are more often confusing unless you have the
proper Verity documentation. Be warned, if you change any of these files
(and the comments indicate that this is the intention) then make sure that
you have complete backups of the originals. Changes to these files seem
sometimes to need a system restart or a service restart before they are
applied. In addition you can totally break the Verity operations until you
restore the originals and reboot so experimentation can be a frustrating
business.
good luck,
John
-Original Message-
From: Scott Rowe [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 7:49 PM
To: CF-Talk
Subject:Verity book-like index idea...
Is there anyway to sort of reverse engineer Verity so that you could
produce
a book-like index of common words and phrases? Is there a specific place in
verity where it stores the words it has indexed? I looked thru the
collections directory and haven't found anything, can anyone give me an
idea
as to how I might be able to do this?
begin 600 WINMAIL.DAT
M)\^(CL(`0:0" `$```!``$``00!@`(Y 0```#H``$(@ `
M ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`@`"``$$
MD 8`T $```$0`P``, (+``\.``(!_P\!40``
M``"!*Q^DOJ,09UN`-T!#U0"`-F+71A;M :]UV5O9F9UVEO;BYC
M;VT`4TU44 !C9BUT86QK0AO=7-E;V9F=7-I;VXN8V]M`!X``C !
M!0```%--5% `'@`#, $:8V8M=%L:T!H;W5S96]F9G5S:6]N
M+F-O;0,`%0P!`P#^#P8``$P`0```!PG8V8M=%L:T!H
M;W5S96]F9G5S:6]N+F-O;2``@$+, $?4TU44#I#1BU404Q+0$A/
M55-%3T955-)3TXN0T]-```#```Y``L`0#H!'@#V7P$:
M8V8M=%L:T!H;W5S96]F9G5S:6]N+F-O;0(!]U\!40"!
M*Q^DOJ,09UN`-T!#U0"`-F+71A;M :]UV5O9F9UVEO;BYC;VT`
M4TU44 !C9BUT86QK0AO=7-E;V9F=7-I;VXN8V]M``,`_5\!`P#_
M7P`"`?8/`00"J6@!!( !`",```!213H@5F5R:71Y()O
M;VLM;EK92!I;F1E"!I95A+BXN`(8+`06 `P`.T `!8`"0`#`# `
M! `S`0$@@ ,`#@```- '!@`6``@`,0`G``0`5P$!"8 !`"$```!"1$(R,40U
M0C(R-#1$-#$Q.$$U.# T1# W,C P,# P, #3!@$#D 8`[ @``"$+``(`
M`0L`(P```P`F```+`"D```,`+@```P`V``!
M`#D`\% /92#OP$`' ``0```",```!213H@5F5R:71Y()O;VLM;EK92!I
M;F1E"!I95A+BXN```"`7$``0```!8!O]P@90Q;';*^1"(1U(I8!-!R
M!X,`04```!33510`!X`'PP!% ```IO:YS01E
M;'1A]I;G0N;FP``P`$%-ZQ8\#``0LP4``!X`"! !90```%-#3U14
M+$E64]555-%041/4T-/34U!3D104D]-4%1724Y$3U=!3D1'3U1/5$A%5D52
M25191$E214-43U)954Y$15)93U520T9-04E.1$E214-43U)9+$%.1%1(14Y2
M54Y42$4``@$)$ $```#(!0``Q 4``+\(``!,6D9U3_RC#\`"@$#`?"
MI 1D`@!C:,$*P'-E=# @"%4"@P`4 /4`@!PG$R("L'$P* ?0J!=@B0=VOI
M"X!D- Q@8P!0"P,+8,!N9S$P,S,+I@8`.P6@`D L"J(*A J 268D('D(8"!U
M#[ @85@@1$\%\ 6@;0.!9+X@$6 # 4Q`_ 2P\'X*$7$F=O('08@6@64 0G
M5@9Q='DG(3*:0EP8QB@GD6(!+ QP20%(%P$-( # "X#=9@L",8T0.@
MAI ,,3%U$)P%MQ!K=F1L:R #4AC$8@N 8DZ:14$965"F,?D C29%IF
M%C!I`B A`'89,S[\+BXA`!ZQ(0`=LQ4*%03K%?(#\P#((640)@%E [*$`
MT,'D 0@%G!N=9LT!IQ;Q7020@929![F0!`!P(6!N AD00@YB@6"?
M(P$``5 ! #U9%S"U%Y)Y$D!7C`)!U%X!LB!C!T #(!C29?YX%E #\!C0
M" %0 JQ'8#3#\ $D',I,%A!4 *P-T64X4P": -%R`_$64YV"W +8"4A
M+A@! 3L/\I02X#,$+@"^0%,K(!M1O28P!9A".$E,"?S)P0@?Q*Q*[ 7
ML#! #W JH G@;?\$(!BA).$RP"U1)%,` 5 [QBA%_ B8!493A3 )4$M0OYS
M`W 64":1-(GR!2"7!PW5L= 0@,.(DX6_^8@3P"' 64"I%#X AX"VS^G%
MLLGD2OR+\4FQ1TUG,O,%DPL@A@(4 68SS-H I$]O'? M41C2+K"/!1 (
M8#B!`B!F:6(/\M4"CB/R E,#-A+4(AY!8BYP0@,L$E,6)U`Q 9H!.P5S)4
M!Y$/P,O,"@S(2#_(E(AY"$"%O AHCE *4 #'LA`"E 24P(0`6P$2C(.HF
M/\,I+S!4.$6T@GP_SAQT$8T19!/]0XI0GP*2#\9V@LT ,`0@%!H"UD!#W
M+9$FD$DA(#[C(7%"`1I [S_Q,(0Z`QSU#N(%_ Y0+='`C]S+S!"*]$*PX)
M@-\`"I%#W$3L!91;AH@-M3_1\H8!PT1LH9H"L@-@8P,?\R04 2.7$",$1
M(9$M$AR!_P# .L JH#E2+3,YQQ;1"U#'+,$DT #0:W5P!" VU=\%L#\P"X ]
M82\P0T^S,V/_1YHS(C9S* `'@ABA3N GD?D6'-Y*4!:03@A`9 `(/]7\5N"
M!) 28"6P7!DX (0S55S91H@+8)A M0")#J9"\P20.@82=P5 HXM\PIAB@
M`9 DL!H@8@EP51#_,,FQ4S2/W,$(!I * `#(/\5\EPB7B57^#?5!N MT3V!
M_RNP3.$'4WU.)8H1RP*4#_/V))8TLA)$UQAP!' I$,43`L4^TIO: N0
M(T_Q$S5I,S8!0!=1+- 9X*$0I#$V("UN`D]8%?L%T"7!84_@;@,5!FT4;.#
M"Q-M%FDM,30T`4!Q*2 Q.# !0 S0:-BW"!`V$?D R28A2%!_$"=Q906U--
M5% ZIG,#8'1 09),6,\D'T6T5T5!7+0!F ",',W5]L)@AQ9"GP' !*D 6
M4!PR,1P``=!R," W.B T.2!0377G5]SS:\"U4!T C)G91=3QB:AG1SF
MQ65A:RW7*2!5(3)D:0$`82)0-1?_"]M0FRD"[85=%.C7L)0(/\T!H@*$V
M@%QR%=
RE: Need help with a SQL query
Alternatively, what if I delete a category. Again, I'd have to retrieve every item, iterate through each list, delete any entries for that category, then save that item. Actually, if you don't re-use the numbers, you could leave the redundant numbers in the denormalised list, as it could never be called, it'll be ignored Messy, but saves on some admin. You could run the tidy routines every day at a quiet period to clean up, which saves a bit of hassle. Denormalisation is useful for smaller amounts of data, but once your data starts breaking hundreds of records then it's just too unwieldy. 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: CFX execution time
-Original Message-
From: Michel Vuijlsteke
Sent: Thursday, June 22, 2000 11:01 AM
To: '[EMAIL PROTECTED]'
Subject: Re: CFX execution time
Erm, well, that's what I do:
x, y are input parameters. z, status are output parameters, and iter is the
number of iterations requested.
libParameters entered/b: cfoutputx=#x#, y=#y#/cfoutput
libReturned data/b:
cfset tt=now()
cfloop from="1" to="#iter#" index="t"
cfx_liz x="#x#" y="#y#" z="" status=""
/cfloop
cfset uu=datediff("s",tt,now())
cfoutputz=#z#, status=font color="cfif status EQ
"OK"339933cfelseff/cfif"b#status#/b/font/cfoutput
libTime taken/b: cfoutput#uu# s (=#evaluate(uu/iter)#
s/iter)/cfoutput
If I have this execute 100 times (fo a simple cfx that multiplies two
numbers) I get an average exec time of 2.3 seconds per iteration.
Michel
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 7:40 PM
To: [EMAIL PROTECTED]
Subject: Re: CFX execution time
I used to do a make shift execution time for some pseudo
webtrends logging.
I would set a time in the application.cfm and set a time in
onendrequest and
compare the two. It would have a small margin of error, but not much.
Thanks,
Neil
- Original Message -
From: "Michel Vuijlsteke" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 21, 2000 11:21 AM
Subject: CFX execution time
Hello.
I have Delphi-built cfx that takes 2 integers and returns them to me
multiplied with a status code.
Is it normal for a simple cfx like that to take more than 2
seconds to
process?
Thing is, a more complex cfx which does a complex
calculation involving a
third-party dll and binary files holding data takes approx.
the same time.
Is there really an almost 2 s overhead for cfx tags? All
this in NT4, CF
4.01, 512 Mb RAM, with no significant load on the machine
and using the
standard delphi framework as described in the Forta book.
Michel Vuijlsteke
Netpoint NV
--
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: CFX execution time
-Original Message- From: Michel Vuijlsteke Sent: Thursday, June 22, 2000 11:02 AM To: '[EMAIL PROTECTED]' Subject: Re: CFX execution time Yes it is. -Original Message- From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 6:28 PM To: [EMAIL PROTECTED] Subject: Re: CFX execution time Is the CFX set to remain loaded in memory? ~Justin - Original Message - From: Michel Vuijlsteke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 4:21 PM Subject: CFX execution time Hello. I have Delphi-built cfx that takes 2 integers and returns them to me multiplied with a status code. Is it normal for a simple cfx like that to take more than 2 seconds to process? Thing is, a more complex cfx which does a complex calculation involving a third-party dll and binary files holding data takes approx. the same time. Is there really an almost 2 s overhead for cfx tags? All this in NT4, CF 4.01, 512 Mb RAM, with no significant load on the machine and using the standard delphi framework as described in the Forta book. Michel Vuijlsteke Netpoint NV -- 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.
CF developer urgently required in the NW UK (Liverpool)
Hi all, Sorry to post this in here, but we really need someone quite urgently for this. I've been tasked to find a developer to take over development and support of a website written in CF. Working remotely is fine, though a developer in the NW (Liverpool/Southport area) would be preferred by the site owner to enable face2face meetings if required. It is a Domain registration site with a little e-commerce, so some knowledge of these areas would be beneficial. The site itself is more than half finished and you will have contact with the developers who originally did the site so no scrambling around blindly in other peoples code to figure out how it works! Not much work will be required to get it working, though once it is, the site owner would like some more features added. If you would like more detailed information on the work involved or any other questions please email me at [EMAIL PROTECTED] or feel free to ring me on 01744 648603 Thanks Brian -- 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: Arrays, databases, and WDDX
Instead of using #CFID# in the insert statement. use #URL.CFID# and
#URL.CFTOKEN# and make sure you are passing the parameters on the url from
the previous form
Kalyan Vemula
Web Developer
STONEAGE.COM
Voice: (800)786-6324 x149
Email: [EMAIL PROTECTED]
http://www.stoneage.com
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a CFWDDX tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
CFSET ProductIDArray=ArrayNew(2)
CFSET ProductIDArray[1][1] = "Case"
CFSET ProductIDArray[1][2] = #Case#
CFSET ProductIDArray[2][1] = "CPU"
CFSET ProductIDArray[2][2] = #CPU#
CFSET ProductIDArray[3][1] = "RAM"
CFSET ProductIDArray[3][2] = #RAM#
CFSET ProductIDArray[4][1] = "HardDrive"
CFSET ProductIDArray[4][2] = #HardDrive#
CFSET ProductIDArray[5][1] = "Floppy"
CFSET ProductIDArray[5][2] = #Floppy#
CFSET ProductIDArray[6][1] = "Monitor"
CFSET ProductIDArray[6][2] = #Monitor#
CFSET ProductIDArray[7][1] = "VideoCard"
CFSET ProductIDArray[7][2] = #VideoCard#
CFSET ProductIDArray[8][1] = "CDROMorDVD"
CFSET ProductIDArray[8][2] = #CDROMorDVD#
CFSET ProductIDArray[9][1] = "CDRecorder"
CFSET ProductIDArray[9][2] = #CDRecorder#
CFSET ProductIDArray[10][1] = "ZipDrive"
CFSET ProductIDArray[10][2] = #ZipDrive#
CFSET ProductIDArray[11][1] = "SoundCard"
CFSET ProductIDArray[11][2] = #SoundCard#
CFSET ProductIDArray[12][1] = "Speakers"
CFSET ProductIDArray[12][2] = #Speakers#
CFSET ProductIDArray[13][1] = "Modem"
CFSET ProductIDArray[13][2] = #Modem#
CFSET ProductIDArray[14][1] = "NetworkCards"
CFSET ProductIDArray[14][2] = #NetworkCards#
CFSET ProductIDArray[15][1] = "Scanner"
CFSET ProductIDArray[15][2] = #Scanner#
CFSET ProductIDArray[16][1] = "DigitalCamera"
CFSET ProductIDArray[16][2] = #DigitalCamera#
CFSET ProductIDArray[17][1] = "Printer"
CFSET ProductIDArray[17][2] = #Printer#
CFSET ProductIDArray[18][1] = "OperatingSystem"
CFSET ProductIDArray[18][2] = #OperatingSystem#
CFSET ProductIDArray[19][1] = "Keyboard"
CFSET ProductIDArray[19][2] = #Keyboard#
CFSET ProductIDArray[20][1] = "Mouse"
CFSET ProductIDArray[20][2] = #Mouse#
CFIF IsDefined('Software')
CFSET ProductIDArray[21][1] = "Software"
CFSET ProductIDArray[21][2] = #Software#
/cfif
CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX"
CFQUERY datasource="bwpc" name="InputQuoteData"
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
/CFQUERY
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
--
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: Arrays, databases, and WDDX
I got the following error. No mention of the database D:\FTP\chrisf\Database\bwpc.mdb in the error statement as Mark Ireland pointed out. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '#CFID#'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (49:1) to (49:49). Kris - Original Message - From: "Mark Ireland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 12:58 PM Subject: Re: Arrays, databases, and WDDX Its not an Access version problem is ist? D:\FTP\chrisf\Database\bwpc.mdb At 12:46 AM 22/06/00 -0400, you wrote: Hello Everyone, I am building a system configurator for a site, but I keep having this error I can't figure out. To see the error, go to www.bluewaterpc.com then click "SOHO Bundle" in the left column. Then just hit the calculate button on the bottom. Now, what this does, is it puts a ton of ProductID numbers (used in a database) into variables like "Case", "RAM", "CPU", etc. You get the idea... now, an array is then made with these variables. This array goes in a CFWDDX tag and then we try to put this information into a database using CFQUERY. The database is setup as follows. It is a Microsoft Access database, and in a table called "SystemQuote" there are 4 fields. "CFID" is one field set up as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as memo. Finally, DateTime is setup as, you guessed it, a Date/Time field. CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX" CFQUERY datasource="bwpc" name="InputQuoteData" INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#, #CFTOKEN#, '#WDDX#' ) /CFQUERY If you all can figure out what the problem is, I would greatly appreciate it. I sure can't. Thank you for all of your help. You -- 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: single quotes
USe the PreserveSingleQuotes(string) function. COld Fusion won't convert with 2 single quotes... -Original Message- From: David [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 7:48 AM To: [EMAIL PROTECTED] Subject: single quotes Hi all, I am a newbie to Coldfusion and have a simple question with regards to single quotes. I was trying to create dynamic string expressions to form a query but each single quote I used, when parsed by ColdFusion 4, was converted to 2 single quotes. I tried escaping using 2 single quotes but only ended up with 4 single quotes. What am I missing? Thank you and regards David -- 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: Arrays, databases, and WDDX
The error message from ODBC seems to imply that Access is expecting a
datetime value in CFID. Have you tried adding a date manually?
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 2:47 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
I have the datetime set in the database to automatically set it whenever a
new record is made so I don't have to worry about it anymore.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
You mentioned "datetime" in your text - where is it used in the code?
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a CFWDDX tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
CFSET ProductIDArray=ArrayNew(2)
CFSET ProductIDArray[1][1] = "Case"
CFSET ProductIDArray[1][2] = #Case#
CFSET ProductIDArray[2][1] = "CPU"
CFSET ProductIDArray[2][2] = #CPU#
CFSET ProductIDArray[3][1] = "RAM"
CFSET ProductIDArray[3][2] = #RAM#
CFSET ProductIDArray[4][1] = "HardDrive"
CFSET ProductIDArray[4][2] = #HardDrive#
CFSET ProductIDArray[5][1] = "Floppy"
CFSET ProductIDArray[5][2] = #Floppy#
CFSET ProductIDArray[6][1] = "Monitor"
CFSET ProductIDArray[6][2] = #Monitor#
CFSET ProductIDArray[7][1] = "VideoCard"
CFSET ProductIDArray[7][2] = #VideoCard#
CFSET ProductIDArray[8][1] = "CDROMorDVD"
CFSET ProductIDArray[8][2] = #CDROMorDVD#
CFSET ProductIDArray[9][1] = "CDRecorder"
CFSET ProductIDArray[9][2] = #CDRecorder#
CFSET ProductIDArray[10][1] = "ZipDrive"
CFSET ProductIDArray[10][2] = #ZipDrive#
CFSET ProductIDArray[11][1] = "SoundCard"
CFSET ProductIDArray[11][2] = #SoundCard#
CFSET ProductIDArray[12][1] = "Speakers"
CFSET ProductIDArray[12][2] = #Speakers#
CFSET ProductIDArray[13][1] = "Modem"
CFSET ProductIDArray[13][2] = #Modem#
CFSET ProductIDArray[14][1] = "NetworkCards"
CFSET ProductIDArray[14][2] = #NetworkCards#
CFSET ProductIDArray[15][1] = "Scanner"
CFSET ProductIDArray[15][2] = #Scanner#
CFSET ProductIDArray[16][1] = "DigitalCamera"
CFSET ProductIDArray[16][2] = #DigitalCamera#
CFSET ProductIDArray[17][1] = "Printer"
CFSET ProductIDArray[17][2] = #Printer#
CFSET ProductIDArray[18][1] = "OperatingSystem"
CFSET ProductIDArray[18][2] = #OperatingSystem#
CFSET ProductIDArray[19][1] = "Keyboard"
CFSET ProductIDArray[19][2] = #Keyboard#
CFSET ProductIDArray[20][1] = "Mouse"
CFSET ProductIDArray[20][2] = #Mouse#
CFIF IsDefined('Software')
CFSET ProductIDArray[21][1] = "Software"
CFSET ProductIDArray[21][2] = #Software#
/cfif
CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX"
CFQUERY datasource="bwpc" name="InputQuoteData"
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
/CFQUERY
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
--
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.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
Advanced Security
Has anyone had any problems implementing advanced security on their site?
We've had success using it on our site for about 3 months but since last
week, the authentication isn't working correctly. It will authenticate
sometimes even if the policy doesn't include the person or group that the
person belongs to.
Any ideas on what could have happened?
I've checked the application page where everything gets set and it looks the
same as it always has been. The code on each page that looks like:
cfif not IsAuthorized("userObject", "Exmgt", "view")
cfinclude template="../../noaccess.cfm"
cfelse
has not changed either.
Is there a maximum number of rules or policies that you can have?
-Tim
--
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: Cold Fusion 4.5.1 Install (If you have IIS)
Larry: This is a repost I sent on this issue on June 6. It will be pertinent, in my opinion, if you have IIS. "Since I haven't seen anyone respond to your query I'll venture my opinion, BUT BEWARE - I'm a newbie, (so take what I say with a word of caution). When I was going through an installation of IIS for the first time - a couple of weeks ago - I found out that IIS may overwrite existing files without prompting. Therefore, a reinstall or repair of the operating system (Windows NT 4.0 for me) was necessary for me and a reinstall of CF was also necessary. "While I was going through all the fiascoes with installing/reinstalling etc. CF and IIS I had to go through quite a lot of trouble to get things up and working correctly. So I pass this URL (below) onto you because it took me a long time to figure this installation stuff out. I spent almost an entire week trying to get IIS to work with ColdFusion Studio and Server (4.5.1). The problem was Microsoft's STRICT procedures to correctly implement IIS. After spending hours (on Microsoft's web site and other places) I finally found the answer I was looking for. You may want to visit this link as well. http://www.microsoft.com/NTServer/nts/deployment/planguide/Install.asp Good luck," Mark Sorteberg Webmaster\Web Developer\Web Designer... INSPEC, INC. http://www.inspec.com Minneapolis and Milwaukee Member of the International Webmasters Association http://www.iwanet.org/ -Original Message- From: Larry Juncker [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 3:10 PM To: [EMAIL PROTECTED] Subject: Cold Fusion 4.5.1 Install Can anyone give me any suggestions or warnings on installing CF4.5.1 We have purchased and downloaded it for install tomorrow morning and I just was wondering if there would be anything we should watch for when we do install it. Does it seem to be backward compatible with most software that was created with 4.0.1? Any suggestions or warnings would be appreciated. Thanks H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- 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: Arrays, databases, and WDDX
Hi Chris,
The error I saw indicated a problem with the Date field trying to accept the
CFID field info.
( i.e. [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in
query expression '#CFID#')
Perhaps you have to adjust the order in which your INSERT or UPDATE is
receiving this info.
It seems as though the fields are out of order.
later -
Denny Sheridan
Denny Sheridan
Director of Web Services
TEK Consulting Inc.
303 450 1575
[EMAIL PROTECTED]
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 10:47 PM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a CFWDDX tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
CFSET ProductIDArray=ArrayNew(2)
CFSET ProductIDArray[1][1] = "Case"
CFSET ProductIDArray[1][2] = #Case#
CFSET ProductIDArray[2][1] = "CPU"
CFSET ProductIDArray[2][2] = #CPU#
CFSET ProductIDArray[3][1] = "RAM"
CFSET ProductIDArray[3][2] = #RAM#
CFSET ProductIDArray[4][1] = "HardDrive"
CFSET ProductIDArray[4][2] = #HardDrive#
CFSET ProductIDArray[5][1] = "Floppy"
CFSET ProductIDArray[5][2] = #Floppy#
CFSET ProductIDArray[6][1] = "Monitor"
CFSET ProductIDArray[6][2] = #Monitor#
CFSET ProductIDArray[7][1] = "VideoCard"
CFSET ProductIDArray[7][2] = #VideoCard#
CFSET ProductIDArray[8][1] = "CDROMorDVD"
CFSET ProductIDArray[8][2] = #CDROMorDVD#
CFSET ProductIDArray[9][1] = "CDRecorder"
CFSET ProductIDArray[9][2] = #CDRecorder#
CFSET ProductIDArray[10][1] = "ZipDrive"
CFSET ProductIDArray[10][2] = #ZipDrive#
CFSET ProductIDArray[11][1] = "SoundCard"
CFSET ProductIDArray[11][2] = #SoundCard#
CFSET ProductIDArray[12][1] = "Speakers"
CFSET ProductIDArray[12][2] = #Speakers#
CFSET ProductIDArray[13][1] = "Modem"
CFSET ProductIDArray[13][2] = #Modem#
CFSET ProductIDArray[14][1] = "NetworkCards"
CFSET ProductIDArray[14][2] = #NetworkCards#
CFSET ProductIDArray[15][1] = "Scanner"
CFSET ProductIDArray[15][2] = #Scanner#
CFSET ProductIDArray[16][1] = "DigitalCamera"
CFSET ProductIDArray[16][2] = #DigitalCamera#
CFSET ProductIDArray[17][1] = "Printer"
CFSET ProductIDArray[17][2] = #Printer#
CFSET ProductIDArray[18][1] = "OperatingSystem"
CFSET ProductIDArray[18][2] = #OperatingSystem#
CFSET ProductIDArray[19][1] = "Keyboard"
CFSET ProductIDArray[19][2] = #Keyboard#
CFSET ProductIDArray[20][1] = "Mouse"
CFSET ProductIDArray[20][2] = #Mouse#
CFIF IsDefined('Software')
CFSET ProductIDArray[21][1] = "Software"
CFSET ProductIDArray[21][2] = #Software#
/cfif
CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX"
CFQUERY datasource="bwpc" name="InputQuoteData"
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
/CFQUERY
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
--
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: List of tables in Access 97
You have to go to Tools - Options - click on Hidden Objects and System Objects then go back to Tools - Security - User and Group permissions - highlight the MSSysObjects table and then check the Read Data check box, then click ok and you are done. Now use the query below and this will give you all of the user tables in an access db. SELECT name FROM MSysObjects WHERE TYPE=1 and left(MSysObjects.name,4) 'MSys' -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 8:21 PM To: [EMAIL PROTECTED] Subject: List of tables in Access 97 How can you get a list of tables in Access? Bob -- 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.
encyclopdia-application and CF ?
Hi, I probably get a contract on building an encyclopdia-application with ColdFusion soon. Is there any examples (Tags ?) that you know of already existing with this functionality ? Thanks. Uwe SD Solutions Uwe Degenhardt Fon: 08122/903791 Fax: 08122/903792 Web: http://www.sdsolutions.de E-Mail: [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: Netscape CSS
Netscape 4.x and CSS... sigh 1 - You *must* include the comment tag just inside the STYLE tag in the external .css file 2 - Be careful if you reference images in your external .css file. If you say an image is in "../images/background.gif " (because that's where it is *in relation to the .css file*), IE will interpret the path to the image correctly. However, Netscape will interpret the path to the image *as if the external css file had been included in the .html (or .cfm) page itself* - code the URLs as absolute (the only workaround I've found, bar using one .css file per directory "level" 3 - Inheritance is very poor in Netscape. If you are relying on it, you may find Netscape doesn't display page elements correctly - answer is to not expect inheritance to work. Don't know if you're experiencing problems based on the above. Anyway, HTH. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.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: break within a text area
Excellent - thanks Dave. Do you know why it was to be set as a variable first? If I just type it within the textarea tag - it just gets displayed. Oh well - it works now. - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 9:03 AM Subject: RE: break within a text area Hi, does anybody know how to set a page break within a textarea tag? I think I have the syntax incorrect using Chr(13). There's no such thing as a page break in a TEXTAREA. If you want a line break, you can use a carriage return and line feed: CFSET CrLf = Chr(13) Chr(10) 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. -- 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: break within a text area
Excellent - thanks Dave. Do you know why it was to be set as a variable first? If I just type it within the textarea tag - it just gets displayed. Oh well - it works now. It doesn't have to be set as a variable first; I do that for convenience. If you're doing something like this: cfset Sentence1 = "My text goes here." cfset Sentence2 = "I'd like this sentence to be on the second line." cfoutput textarea name="foo"#Sentence1# #Sentence2#/textarea /cfoutput you could do this: cfset Sentence1 = "My text goes here." cfset Sentence2 = "I'd like this sentence to be on the second line." cfoutput textarea name="foo"#Sentence1##Chr(13)##Chr(10)##Sentence2#/textarea /cfoutput 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.
DeleteClientVariable() not doing it's stuff
CFSET variables.Result = DeleteClientVariable("client.OldUserID")
Is this code correct? Trouble is, it's not deleting the client variable
(they're stored in a database).
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.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.
CFSTOREDPROC and Access97
Are there any known problems using CFSTOREDPROC and queries in an Access97 database? I'm having a hell of a time getting a simple UPDATE query to work (although SELECT queries work no problem). If you run the query from within Access, it asks for the variable values and then updates the relevant record fine. But passing them as CFPROCPARAMs doesn't seem to work at all (pretty sure all the data-types are OK). I'd paste the code but there's *heaps*... just wondered if anyone had any general comments on this topic. Thanks again. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.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: CFQUERY + CFLOCATION Problem?
I've never had a problem with cfquery but I have noticed that if I cflocation directly after I drop a cfcookie, it doesnt set the cookie. Jon Ken Wilson wrote: I'm getting a few random reports of data loss on an Intranet site and need to get some input on things I might investigate. I'm unable to replicate the problem myself and users that report problems can't replicate it for me when I'm on-site with them. Here's the setup: NT4 Server SP5 CF Server Pro v4.5.1 Access 2000 (yes I know, problem #1) Potential browsers include Netscape v4.6 and IE v5.01 The app is very lightly used averaging 30-40 unique users per day and rarely more than 4 active sessions at any given time...max I've ever seen is 7. The page in question contains a few text fields, various radio button fields and a dozen or so TEXTAREA fields for free-form comments. When users submit the page it updates the database and does a CFLOCATION to return them to their homepage. The few problem reports I've gotten have all been specifically about the Comment fields not containing any data when they retrieve the form to continue editing it. A couple of things I'm wondering are: What, if any, size limit exists within the MS ODBC drivers for Access. I thought I recalled there being a limit on the amount of data that can be passed through the ODBC driver but my own tests have shown no total loss of data when submitting large amounts of text (65,000+). In that case I just see truncated data in the TEXTAREA fields but not a complete loss of data. Having scrtached my head all afternoon I'm now wondering if there's a problem with doing a CFQUERY to Update the database and immediately doing a CFLOCATION? Any chance that the Update is simply not being processed? In particular, if an Update were queued due to database connection limits set in CF Admin would CF Server continue processing the page and execute the CFLOCATION, dropping the Update all together? Any other ideas on things I might investigate? All suggestions are appreciated. Thanks, 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. -- Jon Boehnker [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: Duplicate Record code
What was the code someone had posted here to eliminate duplicates in a database. If you want a "dirty" way to remove duplicate records, then use Distinct select distinct * from myTable where myField='#myValue#' It's slower than using a Group By, but it returns only the unique records (on all fields) 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.
newbie question
I'm working on a project to input user data in a database, however there are several sections for each user. For example if each user will have a section containing basic contact info, then info regarding personal computer info (i.e processor speed, RAM, etc.). Then there would also be a section for inputting other hardware specs. The difficulty I'm having is that I need to create an ID using the users city and state input, then pass that information to each form they use to input the data. I hope this isn't to vague, and any help would be appreciated. -- 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: DeleteClientVariable() not doing it's stuff
try
CFSET variables.Result = DeleteClientVariable("OldUserID")
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 10:42 AM
To: CF-Talk (E-mail)
Subject: DeleteClientVariable() not doing it's stuff
CFSET variables.Result = DeleteClientVariable("client.OldUserID")
Is this code correct? Trouble is, it's not deleting the client variable
(they're stored in a database).
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.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.
How to pass session variables from an ASP Page to a ColdFusion Page
Hi, I'm in a situation where our intranet has been built using ASPs and now part of the system will be built in CF. I want to have an ASP login screen and when the user logs into the CF Application, pass the username and password session variables from ASP to CF. Is this possible? TIA, Debbie -- 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: DeleteClientVariable() not doing it's stuff
try
CFSET variables.Result = DeleteClientVariable("OldUserID")
*profanity deleted*.
Thanks - that was easy. That'll teach me to scope every variable. Gr
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.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 Accuweather Tag
Anyone who would like it, I redid Accuweather 3 to take out the new adds they have been putting in thier code that just gives a script error. Email me off list if you would like a copy. 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.
Stored Procedure
Could anyone give me a stored procedure example using a dynamic variable that is filled in with cfstoredproc. The stored procedure code and the cfstoredproc command would be very helpful. 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.
RE: SQL Server/CF Question
What happens when SQL server reaches its limit. For instance, my SQL 7 machine has 1 GB or RAM. I set SQL server to use about 900 megs, leaving some for WinNT Server 4. What happens once SQL 7 reaches the 900 mark. Will it hang up, or just continue to run at that level. Thanks for any help. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, June 19, 2000 8:51 AM To: [EMAIL PROTECTED] Subject: RE: SQL Server/CF Question Ok here's the deal. I run a TON of Cold Fusion apps on our site, and running SQL Server 7.0. I am still learning SQL Server but here is whats happening. Over time the RAM usage for SQL Server goes up and up, and continues to until I stop and restart the service then it drops back down. Obviously there is some type of memory leak and I dont know where to begin to trouble shoot. Meaning are there some settings on the Datasources I should change to prevent this or is it something in SQL Server I need to look at. If anyone has experience with this please respond. Actually, this isn't a memory leak - SQL Server takes all of the memory it needs to cache the queries and handle it's pending jobs You can restrict the amount of RAM that SQL Server will use, but ideally, it should be on it's own machine with (a minimum of) 512Mb RAM. If you want to stop limit the memory of SQL Server, right click on the Server name (in Enterprise Manager) and choose Properties - then into the Memory tab - you will then see the sliders for the amount of RAM you can set SQL Server to use If you're running your CF/SQL machine with less than 256Mb RAM, then UPGRADE! SQL Server loves memory, and uses all it can... 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. -- 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 tables
I dont create tables with sql often enough are there any good tutorials around? I think my biggest problems is getting the datatypes correct when specifying the create or modify table commands ??? 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.
Re: Stored Procedure
STORED PROCEDURE CREATE PROCEDURE adminlogin @user NVarChar (64), @password NVarChar (32) AS SELECT Comp.COMP_ID_INT, Client.CLIENT_ID_INT FROM Client, Comp, Comp_Client WHERE Comp_Client.COMP_ID_INT = Comp.COMP_ID_INT AND Comp_Client.CLIENT_ID_INT = Client.CLIENT_ID_INT AND (Client.USERNAME_VC = @user) AND (Client.PASSWORD_VC = @password) stored procedure tag in your CF CODE (attributes.user and attributes.password) could also be form.user and form.password or whatever scope you choose) !--- CFSTOREDPROC tag --- CFSTOREDPROC PROCEDURE="ormlogin" datasource="#attributes.dsn#" DBSERVER="#attributes.dbserver#" DBNAME="#attributes.dbname#" USERNAME="#attributes.dbusername#" PASSWORD="#attributes.dbpassword#" RETURNCODE="YES" DEBUG !--- CFPROCRESULT tags --- CFPROCRESULT NAME = ormlogin !--- CFPROCPARAM tags --- CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VARCHAR VALUE="#trim(attributes.user)#" DBVARNAME=@retuser !--- CFPROCPARAM tags --- CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VARCHAR VALUE="#trim(attributes.password)#" DBVARNAME=@retpassword !--- Close the CFSTOREDPROC tag --- /CFSTOREDPROC -- 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: CFSTOREDPROC and Access97
I could be incorrect here, but Access "queries" are not the same thing as stored procs. As best I understand it, they are just save pieces of SQL, which are run whenever they are called.. not quite the same thing as stored procedures. You will need to reproduce the query in CF. Alternately, I've heard that Access 2000 supports stored procs (though I've never tried it.. haven't used Access for development in quite a while) -- Billy Cravens [EMAIL PROTECTED] Aidan Whitehall wrote: Are there any known problems using CFSTOREDPROC and queries in an Access97 database? I'm having a hell of a time getting a simple UPDATE query to work (although SELECT queries work no problem). If you run the query from within Access, it asks for the variable values and then updates the relevant record fine. But passing them as CFPROCPARAMs doesn't seem to work at all (pretty sure all the data-types are OK). I'd paste the code but there's *heaps*... just wondered if anyone had any general comments on this topic. Thanks again. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.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: DeleteClientVariable() not doing it's stuff
DeleteClientVariable("OldUserID") ...
Just erase the "CLIENT." in your parameter.
Noe, it is trying to delete CLIENT.client.OldUserID, and it doesn't exists..
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 10:42 AM
To: CF-Talk (E-mail)
Subject: DeleteClientVariable() not doing it's stuff
CFSET variables.Result = DeleteClientVariable("client.OldUserID")
Is this code correct? Trouble is, it's not deleting the client variable
(they're stored in a database).
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.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: List of tables in Access 97
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: SELECT Name FROM MSysObjects WHERE Type = 1 That'll get you all tables. If you want to exclude all of the system tables, one of the following added to the WHERE clause should do it. AND Name Not Like 'MSys%' - -- OR -- AND Flags = 0 I'm not entirely sure about the Flags thing. In the DB I'm looking at, all system tables have non-zero flags all non-system tables have zero flags. YMMV... BTW, if you want to see these in access, go into the options and check Show Hidden Show System. They're both under the View tab in AC2k. I don't know if it's in the same place in other versions. Hope that helps. Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 9:21 PM To: [EMAIL PROTECTED] Subject: List of tables in Access 97 How can you get a list of tables in Access? Bob -- 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. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVIvNQraVoMWBwRBEQKPnACgnQ82qCyfabCjxGTWXavYzsyPGB8AoO5n XGrobI8oGbwnJJrrpTVshhnc =uR0y -END PGP SIGNATURE- -- 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: Stored Procedure
One thing you can't do in a stored procedure is set the ORDER BY to a
variable, so you have to dynamically build the statement in your stored
procedure. This might come up so I thought I would include it as well
STORED PROCEDURE
CREATE PROCEDURE webclientacctholddaily @caccountid int, @OrderBy
varchar(50)
AS
DECLARE @mySQL nvarchar(500)
SET @mySQL = N'SELECT holdings.*,securities.* FROM holdings, securities
WHERE holdings.secid = securities.secid AND holdings.accountID=@xparam ORDER
BY '+ @OrderBy
EXEC sp_executeSQL @mySQL , N'@xparam int', @caccountid
STORED PROCEDURE TAG IN YOUR CF CODE
cfif not isdefined("sortby")
cfset h_order = "secName"
cfelse
cfset h_order = sortby
/cfif
CFSTOREDPROC PROCEDURE="webclientacctholdmonthly"
datasource="#attributes.datasource#" DBSERVER="#attributes.dbserver#"
DBNAME="#attributes.dbname#" USERNAME="#attributes.dbusername#"
PASSWORD="#attributes.dbpassword#" RETURNCODE="YES" DEBUG
!--- CFPROCRESULT tags ---
CFPROCRESULT NAME = holdings
!--- CFPROCPARAM tags ---
CFPROCPARAM TYPE="IN" cfsqltype=CF_SQL_INTEGER
VALUE="#trim(session.accountid)#" DBVARNAME=@caccountid
CFPROCPARAM TYPE="IN" cfsqltype=CF_SQL_VARCHAR
VALUE="#trim(session.thisdate)#" DBVARNAME=@thisdate
CFPROCPARAM TYPE="IN" cfsqltype=CF_SQL_VARCHAR VALUE="#trim(h_order)#"
DBVARNAME=@OrderBy
!--- Close the CFSTOREDPROC tag ---
/CFSTOREDPROC
--
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.
Tracking users through a site
This is a multi-part message in MIME format. --=_NextPart_000_001A_01BFDC3D.2AD08E50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit What would be the best way to track user movements throughout a site (i.e. what pages they have requested, what keywords they have searched on, their IP, etc.)? The users are already required to login with a userID and password. I need to be able to store the tracking info in a table. Thanks for any input! --=_NextPart_000_001A_01BFDC3D.2AD08E50 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.3018.900" name=3DGENERATOR/HEAD BODY DIV PFONT size=3D2What would be the best way to track user movements = throughout a=20 siteSPAN class=3D746062815-22062000 /SPAN(i.e. what pages they have = requested,=20 what keywords they have searched on, their IP, etc.)?nbsp;SPAN=20 class=3D746062815-22062000The usersnbsp;/SPANSPAN=20 class=3D746062815-22062000are already required tonbsp;/SPANSPAN=20 class=3D746062815-22062000loginnbsp;/SPANSPAN = class=3D746062815-22062000with a=20 userID and password. /SPANI need to be able to store thSPAN=20 class=3D746062815-22062000e tracking /SPAN info in a = table./FONT/P PFONT size=3D2Thanks for any input!/FONT/P/DIV/BODY/HTML --=_NextPart_000_001A_01BFDC3D.2AD08E50-- -- 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: newbie question
you mean like this? cfset userid= attributes.City"_"attributes.State I find it easier to use associated tables for this. once you put a user into your database if you have an autonumber or identity field or use the MAXID tag you will then have a unique id for every user which will be a number. A database searches numbers faster than a string. Then you just use an associated table to join it to another. So if you have a table of computer specs, that table would contain an autonumber or identity field called say compspecs_id. The user table would have a column that was an autonumber or identity field called say user_id. The table that associates them would be called something like user_compspecs. This table would have three columns. user_compspecs_id, user_id, and compspecs_id. In this way you could have one user have multiple specs for muliple dates all you would have to do is add a date column to the user_compspecs table. Is that what you were asking? -- 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: CFLOCK timing out - why?
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_01BFDC5E.4A861140 Content-Type: text/plain; charset="iso-8859-1" I was able to solve the problem - it was a bit of a "duh?!". I had a nested cflock and the parent cflock was unnecessary. Removed the parent, solved the problem. Now I hope that dent in my forehead heals... ant -Original Message- From: Adam Cantrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 2:51 PM To: [EMAIL PROTECTED] Subject: Re: CFLOCK timing out - why? I've been having cf administrator do all of my read-only locking automatically in a blind attempt to somehow decrease the overhead of actual code that needs to be read and processed. Who knows - maybe this increases it, but I just find it more convenient. Have you done any benchmarks to see whether the "auto-locking" feature speeds or slows the app - I couldn't imagine it being too big of a difference either way. - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 2:44 PM Subject: RE: CFLOCK timing out - why? I believe that the syntax for the cflock tag in 4.5 is different - you can omit the type attribute. You just need the scope and the timout. The TYPE attribute isn't required, but the default value is exclusive, and if you can use a readonly lock instead, that would be preferable. In this case, it doesn't matter, but you will still use the TYPE attribute in CF 4.5.x. 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. -- 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_01BFDC5E.4A861140 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: CFLOCK timing out - why?/TITLE /HEAD BODY PFONT SIZE=3D2I was able to solve the problem - it was a bit of a = quot;duh?!quot;.nbsp; I had a nested lt;cflockgt; and the parent = lt;cflockgt; was unnecessary. Removed the parent, solved the problem. = Now I hope that dent in my forehead heals.../FONT/P PFONT SIZE=3D2ant/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Adam Cantrell [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Wednesday, June 21, 2000 2:51 PM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: Re: CFLOCK timing out - why?/FONT /P BR BR PFONT SIZE=3D2I've been having cf administrator do all of my = read-only locking/FONT BRFONT SIZE=3D2automatically in a blind attempt to somehow decrease = the overhead of actual/FONT BRFONT SIZE=3D2code that needs to be read and processed.nbsp; Who = knows - maybe this increases/FONT BRFONT SIZE=3D2it, but I just find it more convenient.nbsp; Have = you done any benchmarks to see/FONT BRFONT SIZE=3D2whether the quot;auto-lockingquot; feature speeds = or slows the app - I couldn't/FONT BRFONT SIZE=3D2imagine it being too big of a difference either = way./FONT /P PFONT SIZE=3D2- Original Message -/FONT BRFONT SIZE=3D2From: quot;Dave Wattsquot; = lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2To: lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2Cc: lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2Sent: Wednesday, June 21, 2000 2:44 PM/FONT BRFONT SIZE=3D2Subject: RE: CFLOCK timing out - why?/FONT /P BR PFONT SIZE=3D2gt; gt; I believe that the syntax for the cflock = tag in 4.5 is/FONT BRFONT SIZE=3D2gt; gt; different - you can omit the type = attribute. You just need/FONT BRFONT SIZE=3D2gt; gt; the scope and the timout./FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; The TYPE attribute isn't required, but the = default value is exclusive, and/FONT BRFONT SIZE=3D2gt; if you can use a readonly lock instead, that = would be preferable. In this/FONT BRFONT SIZE=3D2gt; case, it doesn't matter, but you will still use = the TYPE attribute in CF/FONT BRFONT SIZE=3D2gt; 4.5.x./FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; Dave Watts, CTO, Fig Leaf Software/FONT BRFONT SIZE=3D2gt; A HREF=3D"http://www.figleaf.com/" = TARGET=3D"_blank"http://www.figleaf.com//A/FONT
RE: List of tables in Access 97
Test -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 11:23 AM To: '[EMAIL PROTECTED]' Subject: RE: List of tables in Access 97 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: SELECT Name FROM MSysObjects WHERE Type = 1 That'll get you all tables. If you want to exclude all of the system tables, one of the following added to the WHERE clause should do it. AND Name Not Like 'MSys%' - -- OR -- AND Flags = 0 I'm not entirely sure about the Flags thing. In the DB I'm looking at, all system tables have non-zero flags all non-system tables have zero flags. YMMV... BTW, if you want to see these in access, go into the options and check Show Hidden Show System. They're both under the View tab in AC2k. I don't know if it's in the same place in other versions. Hope that helps. Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 9:21 PM To: [EMAIL PROTECTED] Subject: List of tables in Access 97 How can you get a list of tables in Access? Bob -- 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. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVIvNQraVoMWBwRBEQKPnACgnQ82qCyfabCjxGTWXavYzsyPGB8AoO5n XGrobI8oGbwnJJrrpTVshhnc =uR0y -END PGP SIGNATURE- -- 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.
MIME mistake
Please excuse me for posting that MIME message - I forgot to turn it off. My apologies. -- 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: Tracking users through a site
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What would be the best way to track user movements throughout a site (i.e. what pages they have requested, what keywords they have searched on, their IP, etc.)? The users are already required to login with a userID and password. I need to be able to store the tracking info in a table. That entirely depends on your definition of "best." The least server-invasive method would be to ensure that all your search terms, etc. are sent in query strings. Then you can just analyze your webserver usage logs get most if not all of what you need. When the user logs in, you'd probably want to associate their CFID:CFTOKEN pair with their login account in the database, then you can go back compare the CFID:CFTOKEN cookies stored in your logfiles w/ the DB to figure out which session goes with which user. If you want something more real time easier to query, then in your application.cfm, you could log each request to a table. You'd be looking at a speed hit for all that database access, but it probably wouldn't be THAT bad if the site isn't too heavily loaded. Your DB table should probably contain the userID, file requested, date/time, any query/form parameters, and any other details you might find useful to track. Then you just query to table you should be able to generate most any type of report you need. Hope that's helpful. Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVIzHAraVoMWBwRBEQLacQCaAzVB4FBaciMIOuDPkwQ5HcV6xJ8An3tN gbERXPUHJmT62NIjmjnDf4kq =WQhO -END PGP SIGNATURE- -- 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.
SQL Server Date comparison
Hello All - hope someone can help me with a simple question. When I try to do a query based on user date range input, using = and = criterion, it doesn't always recognize the "=" part. I'm thinking this has something to do with the fact that SQL Server stores date/time instead of date only. Does anyone know the correct syntax to use in CF to have it always recognize the "=" in a = comparison? Here's my code: SELECT * FROMtblDocumentMstr WHERE tblDocumentMstr.effectivedate = #CreateODBCDate(form.begindate)# AND tblDocumentMstr.effectivedate = #CreateODBCDate(form.enddate)# 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: Tracking users through a site
Hi Gina,
I think the easiest way to do this is to put a query in your application.cfm
file that inserts their information into your database:
CFQUERY NAME="record_visitor_page_impressions" DATASOURCE="web_log"
INSERT INTO visit_log
(website_visit_page,website_visit_date,website_visit_contact_id,website_visi
t_ip_address)
values
('#cgi.script_name#',#createodbcdatetime(now())#,#cgi.CONTACT_ID#,'#cgi.remo
te_addr#')
/CFQUERY
Since you put the query in your application.cfm, it will be automatically
included at the top of every page in your application. It will record the
name of the page they viewed, the date and time, the IP address and their
contact ID.
Be aware that these logs can get very large, very fast!
HTH,
Eron
-Original Message-
From: Gina Shillitani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:30 AM
To: [EMAIL PROTECTED]
Subject: Tracking users through a site
This is a multi-part message in MIME format.
--=_NextPart_000_001A_01BFDC3D.2AD08E50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
What would be the best way to track user movements throughout a site (i.e.
what pages they have requested, what keywords they have searched on, their
IP, etc.)? The users are already required to login with a userID and
password. I need to be able to store the tracking info in a table.
Thanks for any input!
--=_NextPart_000_001A_01BFDC3D.2AD08E50
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.3018.900" name=3DGENERATOR/HEAD
BODY
DIV
PFONT size=3D2What would be the best way to track user movements =
throughout a=20
siteSPAN class=3D746062815-22062000 /SPAN(i.e. what pages they have =
requested,=20
what keywords they have searched on, their IP, etc.)?nbsp;SPAN=20
class=3D746062815-22062000The usersnbsp;/SPANSPAN=20
class=3D746062815-22062000are already required tonbsp;/SPANSPAN=20
class=3D746062815-22062000loginnbsp;/SPANSPAN =
class=3D746062815-22062000with a=20
userID and password. /SPANI need to be able to store thSPAN=20
class=3D746062815-22062000e tracking /SPAN info in a =
table./FONT/P
PFONT size=3D2Thanks for any input!/FONT/P/DIV/BODY/HTML
--=_NextPart_000_001A_01BFDC3D.2AD08E50--
--
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: SQL Server Date comparison
change createodbcdate to createodbcdatetime and see what happens. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Smith, Melanie [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 11:44 AM To: '[EMAIL PROTECTED]' Subject: SQL Server Date comparison Hello All - hope someone can help me with a simple question. When I try to do a query based on user date range input, using = and = criterion, it doesn't always recognize the "=" part. I'm thinking this has something to do with the fact that SQL Server stores date/time instead of date only. Does anyone know the correct syntax to use in CF to have it always recognize the "=" in a = comparison? Here's my code: SELECT * FROMtblDocumentMstr WHERE tblDocumentMstr.effectivedate = #CreateODBCDate(form.begindate)# AND tblDocumentMstr.effectivedate = #CreateODBCDate(form.enddate)# 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. -- 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.
Authenticating a user using NT Authentication
Hi Again, Is there anyway to automatically authenticate a user (giving them access to a CF application without having to login) using NT Authentication? TIA, Debbie -- 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: Authenticating a user using NT Authentication
Debbie, I've had luck setting up a User Directory under the Advanced Security Options and making it point to a specified the Windows NT domain. Do the following: (1) Create a User Directory, specifying which NT Domain you want to use. (2) Create Security Context (3) Add User Directory to the Security Context (4) Create Policy (5) Add Users to policy Then using Cold Fusion, utilize the CFAUTHENTICATE tag: CFAUTHENTICATE SETCOOKIE="yes/no" SECURITYCONTEXT="NameofSecurityContext" USERNAME="UserName" PASSWORD="Password" Then call the IsAuthenticted() function to check if it succeeded or not. This is a high level implementation. If you need, reference the Allaire Docs, but to me, they are high level implementation as well. So, good luck :) Hope this helps. David Brooks PC Pros, Inc. -Original Message- From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 11:04 AM To: '[EMAIL PROTECTED]' Subject: Authenticating a user using NT Authentication Hi Again, Is there anyway to automatically authenticate a user (giving them access to a CF application without having to login) using NT Authentication? TIA, Debbie -- 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.
Error message
Anybody have any insight on this fantastic error message ? Error Diagnostic Information unknown exception condition CFMLInterpreterImp::process /Ruben Chadien -- 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: Error message
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Generally it means all heck has broken lose in CFAS, and it's time to restart the service. You shouldn't get that error unless there's some degree of corruption in the CFAS process' memory space. Possible causes include failure to properly lock shared resources, misbehaved CFX tags, leaky ODBC drivers, and anything else that isn't "playing by the rules" on your server. We got tons of them when we went to 4.5.1 from 4.0.1 (even after fixing all the shared memory locks to the new locking format). We had to give up go back to 4.0.1... If they're just randomly cropped up after an upgrade, that could be the cause. Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -Original Message- From: Ruben Chadien [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 12:25 PM To: '[EMAIL PROTECTED]' Subject: Error message Anybody have any insight on this fantastic error message ? Error Diagnostic Information unknown exception condition CFMLInterpreterImp::process /Ruben Chadien -- 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. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVI+PAraVoMWBwRBEQJTGQCghJ58XT3giqVLOEekhXISiwFT1uAAn0qV tK/I57/oZkCKAKYvQbg9K/6p =ROkR -END PGP SIGNATURE- -- 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: Tracking users through a site
Won't most standard web site logging tools do what you need? IIS has one built in. .Todd - Original Message - From: "Eron Cohen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 11:42 AM Subject: RE: Tracking users through a site | -Original Message- | From: Gina Shillitani [mailto:[EMAIL PROTECTED]] | Sent: Thursday, June 22, 2000 11:30 AM | To: [EMAIL PROTECTED] | Subject: Tracking users through a site | | | This is a multi-part message in MIME format. | | --=_NextPart_000_001A_01BFDC3D.2AD08E50 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | | What would be the best way to track user movements throughout a site (i.e. | what pages they have requested, what keywords they have searched on, their | IP, etc.)? The users are already required to login with a userID and | password. I need to be able to store the tracking info in a table. | | Thanks for any input! -- 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
Can I call a cfscript function through a link like a javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
--
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: CFSTOREDPROC and Access97
actually, that's not technically correct. while access "queries" are closer to views in this case, CF can treat them like SPs. Chris Olive, DOEHRS Website Administrator -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 11:13 AM To: [EMAIL PROTECTED] Subject: Re: CFSTOREDPROC and Access97 I could be incorrect here, but Access "queries" are not the same thing as stored procs. As best I understand it, they are just save pieces of SQL, which are run whenever they are called.. not quite the same thing as stored procedures. You will need to reproduce the query in CF. Alternately, I've heard that Access 2000 supports stored procs (though I've never tried it.. haven't used Access for development in quite a while) -- Billy Cravens [EMAIL PROTECTED] Aidan Whitehall wrote: Are there any known problems using CFSTOREDPROC and queries in an Access97 database? I'm having a hell of a time getting a simple UPDATE query to work (although SELECT queries work no problem). If you run the query from within Access, it asks for the variable values and then updates the relevant record fine. But passing them as CFPROCPARAMs doesn't seem to work at all (pretty sure all the data-types are OK). I'd paste the code but there's *heaps*... just wondered if anyone had any general comments on this topic. Thanks again. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.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.
RE: SQL Server/CF Question
What happens when SQL server reaches its limit. For instance, my SQL 7 machine has 1 GB or RAM. I set SQL server to use about 900 megs, leaving some for WinNT Server 4. What happens once SQL 7 reaches the 900 mark. Will it hang up, or just continue to run at that level. Thanks for any help. What SQL Server does is a "Last Used/First Out" option on queries and data, so while the queries are still in use, it'll try to hold them in memory, but as soon as it hits it limit, it'll push out the older stuff We've got an SQL Server machine with 640Mb RAM and it runs perfectly happily, and has done since it was turned on (hasn't been restarted once) As I've said, SQL Server LOVES memory, and the more you can give it, the happier it is, but a 512Mb lower limit should be noted, below that and it does run slower... 1Gb RAM should give flying performance (I'm jealous of the amount you've got g) As long as it's the only major service running, then it'll run sweetly. 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: Tracking users through a site
um .. n/m .. misread the question Todd - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 12:45 PM Subject: Re: Tracking users through a site | Won't most standard web site logging tools do what you need? IIS has one | built in. | | .Todd | | - Original Message - | From: "Eron Cohen" [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Cc: [EMAIL PROTECTED] | Sent: Thursday, June 22, 2000 11:42 AM | Subject: RE: Tracking users through a site -- 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
No
- Original Message -
From: Tim Bahlke [EMAIL PROTECTED]
To: Cf-Talk [EMAIL PROTECTED]
Sent: Thursday, June 22, 2000 5:43 PM
Subject: cfscript
Can I call a cfscript function through a link like a javascript
function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
--
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: creating tables
Jason Egan wrote: I dont create tables with sql often enough are there any good tutorials around? I think my biggest problems is getting the datatypes correct when specifying the create or modify table commands Sure, here are the links I have: http://w3.one.net/~jhoffman/sqltut.htm http://www.dcs.napier.ac.uk/~andrew/sql/ Ian -- Ian Potts CenterGate Research Group, LLC. http://www.centergate.com "Technology so advanced, even we don't understand it!"(SM) -- 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: Tracking users through a site
yes, to a degree the logging tools would be useful, but this particular set of information would be used as an audit trail... so it would have to be permanently stored in a database, and searchable as well. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 12:46 PM To: [EMAIL PROTECTED] Subject: Re: Tracking users through a site Won't most standard web site logging tools do what you need? IIS has one built in. .Todd - Original Message - From: "Eron Cohen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 11:42 AM Subject: RE: Tracking users through a site | -Original Message- | From: Gina Shillitani [mailto:[EMAIL PROTECTED]] | Sent: Thursday, June 22, 2000 11:30 AM | To: [EMAIL PROTECTED] | Subject: Tracking users through a site | | | This is a multi-part message in MIME format. | | --=_NextPart_000_001A_01BFDC3D.2AD08E50 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | | What would be the best way to track user movements throughout a site (i.e. | what pages they have requested, what keywords they have searched on, their | IP, etc.)? The users are already required to login with a userID and | password. I need to be able to store the tracking info in a table. | | Thanks for any input! -- 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: SQL Server/CF Question
On the memory note I think SQL server will only use a upper limit of 3Gb of RAM... ~JustinMacCarthy As I've said, SQL Server LOVES memory, and the more you can give it, the happier it is, but a 512Mb lower limit should be noted, below that and it does run slower... 1Gb RAM should give flying performance (I'm jealous of the amount you've got g) -- 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: List of tables in Access 97
Interesting - when I try this I get a read error?? [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'. je -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 11:23 AM To: '[EMAIL PROTECTED]' Subject: RE: List of tables in Access 97 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: SELECT Name FROM MSysObjects WHERE Type = 1 That'll get you all tables. If you want to exclude all of the system tables, one of the following added to the WHERE clause should do it. AND Name Not Like 'MSys%' - -- OR -- AND Flags = 0 I'm not entirely sure about the Flags thing. In the DB I'm looking at, all system tables have non-zero flags all non-system tables have zero flags. YMMV... BTW, if you want to see these in access, go into the options and check Show Hidden Show System. They're both under the View tab in AC2k. I don't know if it's in the same place in other versions. Hope that helps. Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 9:21 PM To: [EMAIL PROTECTED] Subject: List of tables in Access 97 How can you get a list of tables in Access? Bob -- 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. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVIvNQraVoMWBwRBEQKPnACgnQ82qCyfabCjxGTWXavYzsyPGB8AoO5n XGrobI8oGbwnJJrrpTVshhnc =uR0y -END PGP SIGNATURE- -- 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: Arrays, databases, and WDDX
This is a multi-part message in MIME format.
--=_NextPart_000_0011_01BFDC49.94F5E710
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Since it is a database error the way I would recommend trying to solve this
problem is by first trying to get the insert statement working by trying to
make the insert work by using literals rather then variables. If that works
then replace one literal column with a variable at a time until you find the
offending column variable.
Hope This Helps
Bill Guttman
203-820-5042
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.sys-con.com/coldfusion/readerschoice2000/
http://www.katungroup.com
HTML Links http://www.katungroup.com/html.htm
DHTML Links http://www.katungroup.com/dhtml.htm
Coldfusion Links http://www.katungroup.com/coldfusionlinks2.htm
E-Commerce Links http://www.katungroup.com/ecommercelinks.htm
Java http://www.katungroup.com/java.htm
JavaScript http://www.katungroup.com/javascript.htm
Web Design Links http://www.katungroup.com/webdesign.htm
Graphic Design Links http://www.katungroup.com/GraphicDesign.htm
Venture Capital Links http://www.katungroup.com/venturecapital.htm
Incubator Links http://Iwww.katungroup.com/incubators.htm
eBusiness Links http://www.katungroup.com/eBusiness.htm
Click on my website for the best content and links on:
E-Commerce, Coldfusion, Java, HTML, Web Development
Jobs, Travel, Venture Capital, Dating and much, much more
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a CFWDDX tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
CFSET ProductIDArray=ArrayNew(2)
CFSET ProductIDArray[1][1] = "Case"
CFSET ProductIDArray[1][2] = #Case#
CFSET ProductIDArray[2][1] = "CPU"
CFSET ProductIDArray[2][2] = #CPU#
CFSET ProductIDArray[3][1] = "RAM"
CFSET ProductIDArray[3][2] = #RAM#
CFSET ProductIDArray[4][1] = "HardDrive"
CFSET ProductIDArray[4][2] = #HardDrive#
CFSET ProductIDArray[5][1] = "Floppy"
CFSET ProductIDArray[5][2] = #Floppy#
CFSET ProductIDArray[6][1] = "Monitor"
CFSET ProductIDArray[6][2] = #Monitor#
CFSET ProductIDArray[7][1] = "VideoCard"
CFSET ProductIDArray[7][2] = #VideoCard#
CFSET ProductIDArray[8][1] = "CDROMorDVD"
CFSET ProductIDArray[8][2] = #CDROMorDVD#
CFSET ProductIDArray[9][1] = "CDRecorder"
CFSET ProductIDArray[9][2] = #CDRecorder#
CFSET ProductIDArray[10][1] = "ZipDrive"
CFSET ProductIDArray[10][2] = #ZipDrive#
CFSET ProductIDArray[11][1] = "SoundCard"
CFSET ProductIDArray[11][2] = #SoundCard#
CFSET ProductIDArray[12][1] = "Speakers"
CFSET ProductIDArray[12][2] = #Speakers#
CFSET ProductIDArray[13][1] = "Modem"
CFSET ProductIDArray[13][2] = #Modem#
CFSET ProductIDArray[14][1] = "NetworkCards"
CFSET ProductIDArray[14][2] = #NetworkCards#
CFSET ProductIDArray[15][1] = "Scanner"
CFSET ProductIDArray[15][2] = #Scanner#
CFSET ProductIDArray[16][1] = "DigitalCamera"
CFSET ProductIDArray[16][2] = #DigitalCamera#
CFSET ProductIDArray[17][1] = "Printer"
CFSET ProductIDArray[17][2] = #Printer#
CFSET ProductIDArray[18][1] = "OperatingSystem"
CFSET ProductIDArray[18][2] = #OperatingSystem#
CFSET ProductIDArray[19][1] = "Keyboard"
CFSET ProductIDArray[19][2] = #Keyboard#
CFSET ProductIDArray[20][1] = "Mouse"
CFSET ProductIDArray[20][2] = #Mouse#
CFIF IsDefined('Software')
CFSET ProductIDArray[21][1] = "Software"
CFSET ProductIDArray[21][2] = #Software#
/cfif
CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX"
CFQUERY datasource="bwpc" name="InputQuoteData"
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
/CFQUERY
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
--
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
RE: cfscript
Can I call a cfscript function through a link like a
javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
No. CFSCRIPT is purely server-side, and is subject to the same limitations
as any other CFML code.
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.
My experience with Sybase
My experience with Sybase has been that the company is incompetent about technical matters regarding their own products, nonresponsive to support issues and even to potential buyers, and their database is a dinosaur that performs poorly compared to SQL Server or Oracle. Based on my experience with that flaky company, I wouldn't use Sybase if they gave it to me. Karl Simanonok Just to be contrary, I'd put my vote in for Sybase. Great database, reasonably decent company to work with (especially compared to Microsoft and Oracle), and a good price point. -- 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: Amazon Tags
Awesome... thank you very much.
This is exactly what I was looking for.
Stuart Duncan.
At 01:20 AM 6/22/00 -0500, you wrote:
cfparam name="attributes.book" default="???"
cfparam name="attributes.affid" default=""
cfhttp method="get"
url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigroup/#attributes.affid#"
resolveurl="yes"
cfset filepath="C:\www\content\books"
cfset content = cfhttp.filecontent
cfset startpos = FindNoCase("/exec/obidos/handle-buy-box=", Content)-50
cfset startpos = FindNoCase("form", Content, startpos)
cfset endpos = FindNoCase("/form", Content,startpos)+7
cfset Content = Trim(Mid(Content, startpos, endpos - startpos))
CFSET Content =
replacenocase(Content,"/g/detail/addtocart","http://www.amazon.com/g/detail/addtocart","ALL")
CFSET Content =
replacenocase(Content,"/g/gift-services/buttons/addtoWL","http://www.amazon.com/g/gift-services/buttons/addtoWL","ALL")
CFFILE ACTION="Write"
FILE="#filepath#\#attributes.book#.html"
OUTPUT="#content#"
From: Stuart Duncan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Amazon Tags
Date: Wed, 21 Jun 2000 10:27:13 -0700
Hey all,
I've come across a few interesting tags for searching through Amazon's
books and such
but what I really need is something which allows me to actually select
individual books and display those on the site.
I was thinking, something where I could just enter the product id form
Amazon, and the tag would go and fetch all the information from them on
that book.
Has anyone come up with an easy way to do this, or do you know of any
custom tags that does this?
Any help on this would be greatly appreciated.
Stuart Duncan.
--
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.
--
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
No. For that matter, you can't even write a cfscript function.
[EMAIL PROTECTED] 06/22/00 10:43AM
Can I call a cfscript function through a link like a javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
--
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: Error message
To add something to what Zac said, I've seen this happen on 4.0.x when using the Decrypt function on an empty string, a string not properly encrypted, or using the wrong encryption key. Nasty PCode errors and the like usually follow. -Greg Witte -Original Message- From: Ruben Chadien [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 12:25 PM To: '[EMAIL PROTECTED]' Subject: Error message Anybody have any insight on this fantastic error message ? Error Diagnostic Information unknown exception condition CFMLInterpreterImp::process /Ruben Chadien -- 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.
cfsearch
i'm having trouble with the cfsearch command this is the error message::thanks Error occurred in tag CFSEARCH Collection name not found The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (10:1) to (13:34) in the template file D:\209.35.212.201\SEARCH2.CFM The specific sequence of files included or processed is: D:\209.35.212.201\SEARCH2.CFM . Date/Time: 06/22/00 13:23:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) Remote Address: 204.212.198.37 HTTP Referer: http://www.tophat.com/search1.cfm Template: D:\209.35.212.201\search2.cfm -- 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
Can I call a cfscript function through a link like a javascript function. No. CFSCRIPT is simply another way of writing CFML. Like CFML, it is executed on the server BEFORE the page is sent to the browser. JS is executed in the client browser and can not make calls or references to CF functions or variables. 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.
Mass data updating
I'm stumped on a problem and I'm hoping someone can help. I apologize for
the length of this message but I figured I should give all the info I can.
I have two tables: tblChangeRequest and tblStatus with a one to many
relationship. I'm trying to list all tasks in the change request table with
a pull down list for status for each record so you can update whichever
statuses you want using the pull down list for each record. I'm having two
problems: 1) I can get the statuses to list but I can't get it to
automatically default to the status that is currently in the
tblChangeRequest records and 2) I can't figure out how I am supposed to do
the mass update of all records. I'm hoping to have it similar to the way
egroups.com does mass updates of mailing lists. I'm a CF newbie and can't
find any examples of how to do it.
Should I be using a CFUPDATE tag or do I need to do a more complex SQL
statement? Do I need any counter of any kind in that statement? Any help
would be greatly appreciated.
Here's my code thus far:
cfquery name="qryRequests" datasource="Change_Request" dbtype="ODBC"
SELECT RequestID, txtAssignedTo, txtStaff, dtEntered, dtDeadline,
txtPriority, txtStatus, dtCompleted
FROM dbo.tblChangeRequest
/cfquery
cfquery name="qryStatus" datasource="Change_Request" dbtype="ODBC"
SELECT txtStatus
FROM dbo.tblStatus
ORDER BY txtStatus
/cfquery
table class="text" cellspacing=5
tr
td valign="bottom"/td
td valign="bottom"bRequest ID/b/td
td valign="bottom"bAssigned To/b/td
td valign="bottom"bStaff Member/b/td
td valign="bottom"bDate Entered/b/td
td valign="bottom"bDeadline/td
td valign="bottom"bPriority/b/td
td valign="bottom"bCurrentbrStatus/b/td
td valign="bottom"bDatebrCompleted/b/td/tr
cfform action="change_status_finish.cfm" method="post"
cfoutput query="qryRequests" startrow=1
tr
td valign="top"/td
td valign="top" bgcolor="LightGoldenrodYellow"#RequestID#/td
td valign="top" bgcolor="LightGoldenrodYellow"#txtAssignedTo#/td
td valign="top" bgcolor="LightGoldenrodYellow"#txtStaff#/td
td valign="top" bgcolor="LightGoldenrodYellow"#DateFormat(dtEntered,
"MM/DD/YY")#/b/Abr/td
td valign="top" bgcolor="LightGoldenrodYellow"#DateFormat(dtDeadline,
"MM/DD/YY")#/b/Abr/td
td valign="top" bgcolor="LightGoldenrodYellow"#txtPriority#/td
td valign="top" bgcolor="LightGoldenrodYellow"select name="txtStatus"
cfloop query="qryStatus"
option value="#qryStatus.txtStatus#" #IIF((qryStatus.txtStatus EQ
qryRequests.txtStatus), DE('selected'), DE(''))##txtStatus#/option
/cfloop
/select/td
td valign="top" bgcolor="LightGoldenrodYellow"#DateFormat(dtCompleted,
"MM/DD/YY")#/b/Abr/td
/tr
/CFOUTPUT/table
input type="submit" value="submit"/cfform
Thanks again for any help anyone can provide!
-Marla Jenkins
--
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: SQL Server Date comparison
Hello All - hope someone can help me with a simple question. When I try to do a query based on user date range input, using = and = criterion, it doesn't always recognize the "=" part. I'm thinking this has something to do with the fact that SQL Server stores date/time instead of date only. Does anyone know the correct syntax to use in CF to have it always recognize the "=" in a = comparison? Here's my code: SELECT * FROMtblDocumentMstr WHERE tblDocumentMstr.effectivedate = #CreateODBCDate(form.begindate)# AND tblDocumentMstr.effectivedate = #CreateODBCDate(form.enddate)# Why use Between? SELECT * FROMtblDocumentMstr WHERE tblDocumentMstr.effectivedate Between #CreateODBCDate(form.begindate)# And #CreateODBCDate(form.enddate)# One thing about this though, a CreateODBCDate will be midnight of that date, so maybe the second date wants to be DateAdd(d,1,#CreateODBCDate(form.enddate)#) That's assuming that form.begindate and form.enddate are REAL date formats - if they're just text, then you'll have to convert them anyways... 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: cfscript
Can I call a cfscript function through a link like a javascript
function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
CF is SERVER based, JavaScript is CLIENT based - the CF template is
calculated before it is sent to the browser, so none of the code is seen at
the client end (would you REALLY want clients seeing you CF code?)
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: creating tables
I dont create tables with sql often enough are there any good tutorials around? I think my biggest problems is getting the datatypes correct when specifying the create or modify table commands Which database server? If it's SQL Server, then there's only a few you need to use; Int, SmallInt, TinyInt, Bit, Varchar(), Char(), Text, Money, SmallMoney, DateTime, SmallDateTime, Real, Float[] Avoid at all costs the "n" variants, as CF doesn't understand UniCode, also, they take twice as much space in the table. I tend to limit the field types I use to Int, VarChar(), Text, Money, Real and DateTime. 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.
Syntax of Number format for Grid Columns
This is a multi-part message in MIME format.
--=_NextPart_000_0007_01BFDC52.8821F8E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I've tried both of the examples below. Neither work. Help would be =
appreciated. TIA.
CFGridColumn Name=3D"Act_Value1" Header=3D"Act1" =
NumberFormat("Act_Value1", "99,999,999")
CFGridColumn Name=3D"Act_Value1" Header=3D"Act1" =
NumberFormat("99,999,999")
Regards,
Paige
--=_NextPart_000_0007_01BFDC52.8821F8E0
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.2314.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I've tried both of the examples below.=20
Neithernbsp;work.nbsp;Help would be appreciated.nbsp; =
TIA./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFGridColumn Name=3D"Act_Value1" =
Header=3D"Act1"=20
NumberFormat("Act_Value1", "99,999,999")gt;/FONT/DIV
DIVFONT face=3DArial size=3D2FONT face=3DArial =
size=3D2nbsp;lt;CFGridColumn=20
Name=3D"Act_Value1" Header=3D"Act1" =
NumberFormat("99,999,999")/FONT/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Regards,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Paige/FONT/DIV/BODY/HTML
--=_NextPart_000_0007_01BFDC52.8821F8E0--
--
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: List of tables in Access 97
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: SELECT Name FROM MSysObjects WHERE Type = 1 That'll get you all tables. If you want to exclude all of the system tables, one of the following added to the WHERE clause should do it. AND Name Not Like 'MSys%' -- OR -- AND Flags = 0 I'm not entirely sure about the Flags thing. In the DB I'm looking at, all system tables have non-zero flags all non-system tables have zero flags. YMMV... Interesting - when I try this I get a read error?? Hmmm... I didn't actually try to run that code from CF. Should check my facts next time This worked for me: Open the database in Access change Access' options so you can see hidden system tables. Click on the MSysObjects table, then go Tools-Security-User and Group Permissions. Give the Admin user rights to 'Read Design' and 'Read Data' in the MSysObjects table. After doing that, I was able to run the query from ColdFusion (4.0.1 thru ODBC, FYI). If *that* doesn't work, then I guess I'm outta ideas for now... Access isn't my beast of choice any more... Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVJTyQraVoMWBwRBEQIluQCeMSFeBsIe7qS0iO/7NMkJPL8Bn/gAn38b vzfyfgEPyGSDWph8WCgVkb+d =ZcMB -END PGP SIGNATURE- -- 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: List of tables in Access 97
Did this not work To Unsubscribe visit : http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk steve - Original Message - From: "Internet Marketing Corporation" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 6:18 AM Subject: RE: List of tables in Access 97 I have been attempting to unsubscribe from this list for over a month. NOW I AM GETTING LIST EMAIL WITH ATTACHMENTS!!! IF ANYBODY IS OUT THERE, THIS HAS GOT TO STOP!!! Please! 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. -- 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: Tracking users through a site
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yes, to a degree the logging tools would be useful, but this particular set of information would be used as an audit trail... so it would have to be permanently stored in a database, and searchable as well. You *could* periodically analyze the logfiles stuff the results into a DB. That's probably a better solution if you're expecting a huge number of visitors. For an 'average' load (whatever THAT means...), you should be able to get away with a database approach in the application.cfm. Just for reference, our site runs about 1.5 millions hits per month, runs on CF 4.0.1 on a dual P2 450MHz, 512MB, mirrored drives MSSQL 7. It's VERY database heavy (even our page headers footers are data-driven). We don't have any problem with overloading the server. I don't want to scare you off from the databased method, but just consider that if you're looking at a 'microsoft.com' level of traffic, it might not be the safest solution... Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVJU4wraVoMWBwRBEQJfkQCgwIbnCT7JUi4GP9HjhJvolYJkEsoAnR+p sMT7UJqoSGLTx+x2IUTGtIci =UCaL -END PGP SIGNATURE- -- 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
cfscript doesn't have functions, so you can't call one even from a page.
But javascript can't interact with CF because CF is executed on the server
and javascript is executed on the browser.
What you can do is use CF to dynamically write the javascript functions you
need.
HTH!
Sharon
At 12:43 PM 6/22/2000 -0400, Tim Bahlke wrote:
Can I call a cfscript function through a link like a javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
---
---
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: My experience with Sybase
At 10:04 AM 6/22/2000 -0700, Karl Simanonok wrote: My experience with Sybase has been that the company is incompetent about technical matters regarding their own products, nonresponsive to support issues and even to potential buyers, and their database is a dinosaur that performs poorly compared to SQL Server or Oracle. Based on my experience with that flaky company, I wouldn't use Sybase if they gave it to me. Karl Simanonok I've only had to deal with their technical people once, and they were very helpful and knowledgeable at that time. This means that I haven't *had* to talk to tech support over the 2+ years I've been working with Sybase. This contrasts greatly with Oracle, whom I had to call for tech support 15+ times over the course of the month it took me to install the product correctly. I found Oracle's UNIX support folks to be very knowledgeable and all other departments there to be very irritating. Of course if the product had been sanely designed and installed itself correctly, I might have a better opinion of their tech support. I haven't ever used SQL Server, but that's because I value cross-platform compatibility. Don't like being cornered by a single company. I do hear that SQL Server 2000 really rocks on the TPC benchmarks, though. I'd also have to agree with the evaluation of the Sybase sales reps. I can't stand our regional rep. He has raised my blood pressure to insane levels on occasion. Fortunately, I found a fantastic reseller in Florida (I'm in Oregon) who now runs interference for me with pretty much every vendor of mine and usually gets me a better price than direct sales. Performance wise, I can't really accurately judge. All I can say is that I get lot's of 0 msec queries, I can set up new db's and tables quickly, and I don't have to worry about strange 2K character limits and things like that. That's all that matters to me. So for any folks out there considering database purchases, I'd say that you shouldn't rule out Sybase based on all the marketing garbage being thrown out there by Microsoft and Oracle. Enjoy, Judah -- 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.
cfdirectory -- help.
hi. Im new to this list...ive been looking for a list like this for ages...obviously I haven't looked too hard otherwise I would've found this a while ago! Anywho...my issue is this: cfdirectory action="list" directory="c:\somedirectory\" name="??" sort="name" what should go in the name value ? especially if I want to list the entire contents of the directory. Miles. -- 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.
check-box editing
Hi all! Problem: A user selects from a group of check boxes and submits. When going to edit the info, can't figure out the best way to pull the info back out of the database into the checkboxes (so users can see and edit which boxes they have checked). Background: I am creating a contact management application. In the create a new contact area, the user has a has a list of check boxes (they wanted check boxes for some reason) for adding the new contact to one or several groups. Ex: the new contact can be in the sales and admin groups or whatever (like 20 groups to choose from). Anyway, there are two basic tables in my database, 1 for contact information and 1 with group names and descriptions. On the enter a new contact form, the group names and descriptions are being pulled out of the group table for the checkboxes: cfoutput query="Groups" tr th align="right"/th td b#GroupName#/binput type="checkbox" name="Groups" value="#GroupName#" #Description# /td /tr /cfoutput This works ok. It enters the names of any groups checked into the contacts table in one field called "Groups" with comma separators . I'm using this code to pull the info back out for the editing contact form: cfquery datasource="datasource" name="Contact" SELECT g.GroupID, g.GroupName, g.Description, c.ContactID, c.FirstName, c.LastName, c.MiddleInit, c.Address, c.City, c.StateOrProvince, c.ZipCode, c.Country, c.CompanyName, c.Title, c.WorkPhone, c.WorkExtension, c.HomePhone, c.CellPhone, c.Fax, c.Email, c.ReferredBy, c.Notes, c.Groups FROM Groups g, Contacts c WHERE c.ContactID=#ContactID# /cfquery ... CFIF #Groups# CONTAINS #GroupName# tr th align="right"/th td b#GroupName#/binput type="checkbox" name="Groups" value="#GroupName#" CHECKED #Description# /td /tr /CFIF CFIF #Groups# DOES NOT CONTAIN #GroupName# tr th align="right"/th td b#GroupName#/binput type="checkbox" name="Groups" value="#GroupName#" #Description# /td /tr /CFIF This actually works ok too except for the fact that a table full of all the same info, except for the group checkbox, appears for every group. Ex: 3 groups - 1st table has all info and then Group1 checkbox (either checked or not), 2nd table...Group2 checkbox, third table...Group3 checkbox. I'm thinking that it has to do with how the groups are being stored in the database? Is there a better way? Thanks for any help! Christin -- 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
Tim, you might want to combine CF and JavaScript for what you want to do.
For example :
cfquery name=q
SELECT Name
FROM dB
/cfquery
cfoutput query=q
a href="javascript:ShowName('#Name#');"#name#/abr
/cfoutput
Hope that helps
~JustinMacCarthy
--
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: Arrays, databases, and WDDX
Yeah, I tried that too but it didn't work.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 8:31 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
The error message from ODBC seems to imply that Access is expecting a
datetime value in CFID. Have you tried adding a date manually?
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 2:47 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
I have the datetime set in the database to automatically set it whenever a
new record is made so I don't have to worry about it anymore.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
You mentioned "datetime" in your text - where is it used in the code?
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a CFWDDX tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
CFSET ProductIDArray=ArrayNew(2)
CFSET ProductIDArray[1][1] = "Case"
CFSET ProductIDArray[1][2] = #Case#
CFSET ProductIDArray[2][1] = "CPU"
CFSET ProductIDArray[2][2] = #CPU#
CFSET ProductIDArray[3][1] = "RAM"
CFSET ProductIDArray[3][2] = #RAM#
CFSET ProductIDArray[4][1] = "HardDrive"
CFSET ProductIDArray[4][2] = #HardDrive#
CFSET ProductIDArray[5][1] = "Floppy"
CFSET ProductIDArray[5][2] = #Floppy#
CFSET ProductIDArray[6][1] = "Monitor"
CFSET ProductIDArray[6][2] = #Monitor#
CFSET ProductIDArray[7][1] = "VideoCard"
CFSET ProductIDArray[7][2] = #VideoCard#
CFSET ProductIDArray[8][1] = "CDROMorDVD"
CFSET ProductIDArray[8][2] = #CDROMorDVD#
CFSET ProductIDArray[9][1] = "CDRecorder"
CFSET ProductIDArray[9][2] = #CDRecorder#
CFSET ProductIDArray[10][1] = "ZipDrive"
CFSET ProductIDArray[10][2] = #ZipDrive#
CFSET ProductIDArray[11][1] = "SoundCard"
CFSET ProductIDArray[11][2] = #SoundCard#
CFSET ProductIDArray[12][1] = "Speakers"
CFSET ProductIDArray[12][2] = #Speakers#
CFSET ProductIDArray[13][1] = "Modem"
CFSET ProductIDArray[13][2] = #Modem#
CFSET ProductIDArray[14][1] = "NetworkCards"
CFSET ProductIDArray[14][2] = #NetworkCards#
CFSET ProductIDArray[15][1] = "Scanner"
CFSET ProductIDArray[15][2] = #Scanner#
CFSET ProductIDArray[16][1] = "DigitalCamera"
CFSET ProductIDArray[16][2] = #DigitalCamera#
CFSET ProductIDArray[17][1] = "Printer"
CFSET ProductIDArray[17][2] = #Printer#
CFSET ProductIDArray[18][1] = "OperatingSystem"
CFSET ProductIDArray[18][2] = #OperatingSystem#
CFSET ProductIDArray[19][1] = "Keyboard"
CFSET ProductIDArray[19][2] = #Keyboard#
CFSET ProductIDArray[20][1] = "Mouse"
CFSET ProductIDArray[20][2] = #Mouse#
CFIF IsDefined('Software')
CFSET ProductIDArray[21][1] = "Software"
CFSET ProductIDArray[21][2] = #Software#
/cfif
CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX"
CFQUERY datasource="bwpc" name="InputQuoteData"
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
/CFQUERY
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
--
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
RE: cfscript
This is just the advice I was looking for. Thanks Justin!
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
-Original Message-
From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 3:12 PM
To: [EMAIL PROTECTED]
Subject: Re: cfscript
Tim, you might want to combine CF and JavaScript for what you want to do.
For example :
cfquery name=q
SELECT Name
FROM dB
/cfquery
cfoutput query=q
a href="javascript:ShowName('#Name#');"#name#/abr
/cfoutput
Hope that helps
~JustinMacCarthy
--
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: Syntax of Number format for Grid Columns
Paige;
Try this code:
CFGridColumn Name="Act_Value1" Header="#NumberFormat(Act1,'99,999,999')#"
I set ACT_Value1 to 345.98 and this named my column 346
Hope this is what you were looking for.
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications Group
Internet Division
-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:03 PM
To: [EMAIL PROTECTED]
Subject: Syntax of Number format for Grid Columns
This is a multi-part message in MIME format.
--=_NextPart_000_0007_01BFDC52.8821F8E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I've tried both of the examples below. Neither work. Help would be =
appreciated. TIA.
CFGridColumn Name=3D"Act_Value1" Header=3D"Act1" =
NumberFormat("Act_Value1", "99,999,999")
CFGridColumn Name=3D"Act_Value1" Header=3D"Act1" =
NumberFormat("99,999,999")
Regards,
Paige
--=_NextPart_000_0007_01BFDC52.8821F8E0
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.2314.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I've tried both of the examples below.=20
Neithernbsp;work.nbsp;Help would be appreciated.nbsp; =
TIA./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFGridColumn Name=3D"Act_Value1" =
Header=3D"Act1"=20
NumberFormat("Act_Value1", "99,999,999")gt;/FONT/DIV
DIVFONT face=3DArial size=3D2FONT face=3DArial =
size=3D2nbsp;lt;CFGridColumn=20
Name=3D"Act_Value1" Header=3D"Act1" =
NumberFormat("99,999,999")/FONT/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Regards,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Paige/FONT/DIV/BODY/HTML
--=_NextPart_000_0007_01BFDC52.8821F8E0--
--
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: Tracking users through a site
We're looking at about 86,000 hits per day on the reporting server, which is where I need to collect this information. I'm trying to figure out if there is a way I can track a single user through each visit to the site and record the entire session to one record in the table. Example, the user with token XYZ requested a.cfm, b.cfm?var=keyword, c.cfm?var=keywordvar2=5, on 6/25/2000 at 8:56 AM and spent 15 minutes total on the site. This would be preferable to recording single page hits and I do need to record any variables that are passed to individual pages. -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 2:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Tracking users through a site -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yes, to a degree the logging tools would be useful, but this particular set of information would be used as an audit trail... so it would have to be permanently stored in a database, and searchable as well. You *could* periodically analyze the logfiles stuff the results into a DB. That's probably a better solution if you're expecting a huge number of visitors. For an 'average' load (whatever THAT means...), you should be able to get away with a database approach in the application.cfm. Just for reference, our site runs about 1.5 millions hits per month, runs on CF 4.0.1 on a dual P2 450MHz, 512MB, mirrored drives MSSQL 7. It's VERY database heavy (even our page headers footers are data-driven). We don't have any problem with overloading the server. I don't want to scare you off from the databased method, but just consider that if you're looking at a 'microsoft.com' level of traffic, it might not be the safest solution... Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVJU4wraVoMWBwRBEQJfkQCgwIbnCT7JUi4GP9HjhJvolYJkEsoAnR+p sMT7UJqoSGLTx+x2IUTGtIci =UCaL -END PGP SIGNATURE- -- 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: escaping special characters between cfoutput/cfoutput
Thanks - this is very helpful. BTW - any characters I need to watch out for besides # and "? aloha Dan - Original Message - From: "Jeff" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 3:57 PM Subject: Re: escaping special characters between cfoutput/cfoutput dan stas, :~~ : From: Stas Maximov [EMAIL PROTECTED] : : inside cfoutput you may use TD : bgcolor="#Chr(35)#CC" instead. : : From: Dan Cameron [EMAIL PROTECTED] : : but is there a way to just escape the "#" character? :~~ all you have to do to escape a character in cf is to double it up. tip type="cold fusion" trying to put something with quotes or hashes into a cf variable and getting errors? then escape them. it's as easy as repeating the offending entity. cfset myFont = "font face=""Arial"" color=""##ffcc00""" /tip good luck, .jeff name://jeff.howden game://web.development http://www.evolt.org/ 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. -- 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: creating tables
Thank you, these are good links, !! W3 !! Thank you! je -Original Message- From: Ian Potts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: creating tables Jason Egan wrote: I don't create tables with sql often enough - are there any good tutorials around? I think my biggest problems is getting the datatypes correct when specifying the create or modify table commands... Sure, here are the links I have: http://w3.one.net/~jhoffman/sqltut.htm http://www.dcs.napier.ac.uk/~andrew/sql/ Ian -- Ian Potts CenterGate Research Group, LLC. http://www.centergate.com "Technology so advanced, even we don't understand it!"(SM) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- 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: cfdirectory -- help.
Anywho...my issue is this: cfdirectory action="list" directory="c:\somedirectory\" name="??" sort="name" what should go in the name value ? especially if I want to list the entire contents of the directory. The name can be whatever you want it to be. You use the name to reference the list of files within the directory as if it was a query. So, if you named it "foo", you could do this: cfoutput query="foo" #foo.type# - #foo.name# - #foo.size# - #foo.datelastmodified#br /cfoutput 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: OT: Nutscrape Problem
I saw on the tvw.org site you put cfid and cftoken at the end of the variable. For some reason when I turn off cookies and go through my site, it gets way way way screwed up and gives me different cfid and cftoken on everypage. How do I correct this problem? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Ryan Hill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 2:14 PM To: '[EMAIL PROTECTED]' Cc: 'Nick McClure ' Subject: RE: OT: Nutscrape Problem Ok, Thought I would add a few comments since I'm fairly familiar with the RealNetworks side of things. Real generally reccomends that you use .ram files to deliver the content to everyone, but the reason for this is the fact that browsers and/or webservers don't recognize MIME types correctly. If you're serving the file from the webserver (not streaming), you need to make sure the x/pn-realaudio MIME type is correctly defined on IIS (or whatever, you still may need to use a .ram file for Netcrap - I've not had much luck with it either). If you're serving the file from a RealServer (streaming), you can use the ramgen utility on RealServer to automatically create and serve text files to visiting clients. If you spend a little time with it, you can even get CF to autogenerate and manage the ramgen links for you. cf_memories Back in '98, I built the TVW website at www.tvw.org. My first adventure in CF, it manages over 15,000 RealAudio and RealVideo files for your government-big-brother listening pleasure. It serves Real files by auto-generating .ram file links for RealServer from CF. The method was based on the same principle as ramhurl.cgi, which RealNetworks developed to address the same issue. (Can't you just imagine having 15,000 1kb .ram files that are just pointers and need to be MANUALLY changed everytime the file is moved or renamed???) /cf_memories Regards, Ryan -Original Message- From: Nick McClure To: [EMAIL PROTECTED] Sent: 6/21/00 7:02 PM Subject: Re: OT: Nutscrape Problem What you should do is create a ram file, a ram file is a text file that has the location of the media file(s) all you do is in your link use A HREF="genesis.ram"Real Audio/A genesis.ram has the following: rtsp://server/genesis.ra I cannot remember how MS recommends media player to be done but the above is the way Real says to do it for all browsers. At 11:51 AM 6/22/2000 +1000, you wrote: --30D4A7DAC60E0AF91450CD2C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Duane, Maybe the Mime types for these files are not set on the web server? I'm pretty sure netscape uses a different scheme for registered file types than IE, and therefore IE may be able to recognise non-explicitlity stated types. Dunno... Jared Clinton. Duane Boudreau wrote: Hi All, I am having problems with Netscape linking to Real Audio and Windows Media Player multimedia files. The links are: A HREF="rtsp://server/genesis.ra"Real Audio/A A HREF="mms://server/genesis.asf"Windows Media/A If I link to either of these in Netscape I get 404 error, but with IE everything is fine. Any ideas why? Thanks, Duane Boudreau CFExperts.Com Why, oh, why can't Netscape just go away! -- 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. --30D4A7DAC60E0AF91450CD2C Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" Duane, Maybe the Mime types for these files are not set on the web server? I'm pretty sure netscape uses a different scheme for registered file types than IE, and therefore IE may be able to recognise non-explicitlity stated types. Dunno... Jared Clinton. Duane Boudreau wrote: Hi All, I am having problems with Netscape linking to Real Audio and Windows Media Player multimedia files. The links are: A HREF="rtsp://server/genesis.ra"Real Audio/A A HREF="mms://server/genesis.asf"Windows Media/A If I link to either of these in Netscape I get 404 error, but with IE everything is fine. Any ideas why? Thanks, Duane Boudreau CFExperts.Com Why, oh, why can't Netscape just go away! -- Archives: http://www.eGroups.com/list/cf-talkhttp://www.eGroups.com/list/cf-ta lk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_ta lkh ttp://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --30D4A7DAC60E0AF91450CD2C-- --- --- Archives:
Re: OT: Nutscrape Problem
Duane, I did something similar - writing ram files as people entered clips to a database of audio and video files. Code goes something like this: !-- --- If it's a new ramfile, write the file. -- cfif #form.new# is "yes" cffile action="write" file="w:netscape\wisconsinvote\docs\avroom\#form.ramfile#" output="#form.rtspaddress#" !-- --- If it's replacing an old file, delete the old and rewrite. -- cfelse cffile action="delete" file="w:netscape\wisconsinvote\docs\avroom\#form.ramfile#" h4Let's put something in here to give it a few milliseconds.../h4 cffile action="write" file="w:netscape\wisconsinvote\docs\avroom\#form.ramfile#" output="#form.rtspaddress#" /cfif -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: Bad cfml.exe ???
Is there a reason why you are running CF as a CGI? If not, then I would suggest mapping .cfm to iscf.dll (wwwserver/isapi) in WebSite. Regards, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 www.CoolFusion.com Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** Check out inFusion Mail Server - the world's most configurable email server - Original Message - From: Jacob [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 2:26 PM Subject: Bad cfml.exe ??? I upgraded from Cold Fusion studio 4.0 to 4.0.1. After the upgrade I copied the cfml.exe to C:\website\cgi-shl\ . When I run a template I get an error: Error Occurred While Processing Request Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). http://38.144.90.136/cgi-bin/cfml.exe?Template=/shopping/additem.htmstock=5 5264V1 When I replace it the cfml.exe from version 4.0, it works fine. 4.0 cfml.exe 104KB 10/6/98 4.0.1 cfml.exe 121KB 4/8/99 I made no changes to the webserver (Website Professional). Any suggestions? Jacob -- 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: cfdirectory -- help.
"name" is just the name of the cfdirectory result set.. so if you named it "MyCFDir", you would loop over the results with a regular cfoutput or cfloop: cfloop query="MyCFDir" /cfloop note that a cfdirectory will return "." and ".." every time... I always forget that one and test for recordcount eq 0 instead of 2. HTH Jon miles wrote: hi. Im new to this list...ive been looking for a list like this for ages...obviously I haven't looked too hard otherwise I would've found this a while ago! Anywho...my issue is this: cfdirectory action="list" directory="c:\somedirectory\" name="??" sort="name" what should go in the name value ? especially if I want to list the entire contents of the directory. Miles. -- 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. -- Jon Boehnker [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.
Recall: RDS service on Solaris
Conrad, Christopher would like to recall the message, "RDS service on Solaris". -- 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: Stored Procedure
One thing you can't do in a stored procedure is set the ORDER BY to a variable, so you have to dynamically build the statement in your stored procedure. Au contraire! The following was pointed out to me by Oracle ubergenius Thomas Kyte, when I posted the same message to comp.databases.oracle.misc: You CAN do a dynamic ORDER BY ...by using a DECODE. Or whatever SQL Server's equivalent is, if not DECODE. CURSOR testCursor( fooVar NUMBER, orderBy NUMBER DEFAULT 1) IS SELECT foo, bar, baz FROM fooTable WHERE foo = fooVar ORDER BY DECODE(orderBy,1,foo,2,bar,3,baz); Passing 1 (or nothing, as it's a default) would order by FOO, 2 orders by BAR, 3 orders by BAZ, etc. I've never worked with SQL Server, but I'm sure there must be something roughly analogous to this. HTH. HAND. Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore "I'm sorry, I can't hear you. God just sat on my Whoopee Cushion." - Kibo -- 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: Bad cfml.exe ???
I upgraded from Cold Fusion studio 4.0 to 4.0.1. snip I made no changes to the webserver (Website Professional). Any suggestions? I can't help with the problem you mentioned, but I WOULD point out that - at least when I was working with Perl -putting executables into a public-accessable CGI directory was regarded a really, really good way to let people execute arbitrary code on your system. In other words, a big fat security hole. I don't know if this is a no-no with CF, given that I have no experience with CF on a non-NT environment; but I'd keep it in mind, unless you're absolutely sure that's the right thing to do. Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore "I'm sorry, I can't hear you. God just sat on my Whoopee Cushion." - Kibo -- 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.
CFERROR
I'm doing classes at my company training people in some stuff they may not know and generally getting them ready for the certification. I'm writing up a lesson plan on Error Catching and the docs on CFERROR are not to helpful. Does anyone know any articles on CFERROR that have been done on the net anywhere? I'd rather use someone else's research as a start than have to work from scratch. Otherwise, expect an article on it in a future FA alert. ;) 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.
outputting from two places
I have a cfx tag that returns records and I also have a query that will be returning records. The records that are to be returned have the same type of information. How can I output these records together like they were pulled from the same query? They need to mesh completely - like sorting by the date field or name field. Sorry if this is overly easy - I'm really tired and can't find out how to do this. -- 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: cfsearch
Make sure that you have set up your collection and indexed it using cfcollection (or cf administrator). If you have, double check the spelling of the collection name in your cfsearch tag. -- Billy Cravens [EMAIL PROTECTED] Chip Sigourney wrote: i'm having trouble with the cfsearch command this is the error message::thanks Error occurred in tag CFSEARCH Collection name not found The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (10:1) to (13:34) in the template file D:\209.35.212.201\SEARCH2.CFM The specific sequence of files included or processed is: D:\209.35.212.201\SEARCH2.CFM . Date/Time: 06/22/00 13:23:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) Remote Address: 204.212.198.37 HTTP Referer: http://www.tophat.com/search1.cfm Template: D:\209.35.212.201\search2.cfm -- 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: cfdirectory -- help.
"name" is a variable name you want to be able to use to reference the results, which function as a query. ie, to list file names: cfdirectory action="list" directory="c:\somedirectory\" name="dirlist" sort="name" cfoutput query="dirlist" #name# /cfoutput -- Billy Cravens [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: cfdirectory -- help.
The name attribute is simply the name of the query that you use to output the contents of the data. Here's a working example (directly from the CF documentation): CFDIRECTORY DIRECTORY="#GetDirectoryFromPath(GetTemplatePath())#" NAME="myDirectory" SORT="name ASC, size DESC" !--- Output the contents of the CFDIRECTORY as a CFTABLE --- CFTABLE QUERY="myDirectory" HTMLTABLE COLHEADERS CFCOL HEADER="NAME:" TEXT="a href=#name##Name#/a" CFCOL HEADER="SIZE:" TEXT="#Size#"/CFTABLE -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: miles [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 11:21 AM To: [EMAIL PROTECTED] Subject: cfdirectory -- help. hi. Im new to this list...ive been looking for a list like this for ages...obviously I haven't looked too hard otherwise I would've found this a while ago! Anywho...my issue is this: cfdirectory action="list" directory="c:\somedirectory\" name="??" sort="name" what should go in the name value ? especially if I want to list the entire contents of the directory. Miles. -- 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: My experience with Sybase
We use ASIQ 12. Our system averages 2,000 counts a day from 500 million records. We find that it runs roughly 70% faster than SQL Server. Now, if you're running under 10 million records, that may not hold. And our Cold Fusion system loves it. We have not experienced your apparent problems with their support and technical staff. Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 1:05 PM To: [EMAIL PROTECTED] Subject: My experience with Sybase My experience with Sybase has been that the company is incompetent about technical matters regarding their own products, nonresponsive to support issues and even to potential buyers, and their database is a dinosaur that performs poorly compared to SQL Server or Oracle. Based on my experience with that flaky company, I wouldn't use Sybase if they gave it to me. -- 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.
