Re: Amazon Tags

2000-06-22 Thread Eric Dawson

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

2000-06-22 Thread Chris Farrugia

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...

2000-06-22 Thread John Storey

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

2000-06-22 Thread Philip Arnold - ASP

 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

2000-06-22 Thread Michel Vuijlsteke



-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

2000-06-22 Thread Michel Vuijlsteke



-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)

2000-06-22 Thread Brian Mitter

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

2000-06-22 Thread Kalyan Vemula

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

2000-06-22 Thread guru.com

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

2000-06-22 Thread Frédéric LeMieux

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

2000-06-22 Thread Jeff Beer

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

2000-06-22 Thread Tim Cavins

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)

2000-06-22 Thread Mark Sorteberg

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

2000-06-22 Thread Denny Sheridan

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

2000-06-22 Thread Clint Tredway

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 ?

2000-06-22 Thread cftalk

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

2000-06-22 Thread Aidan Whitehall

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

2000-06-22 Thread Adam Cantrell


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

2000-06-22 Thread Dave Watts

 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

2000-06-22 Thread Aidan Whitehall

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

2000-06-22 Thread Aidan Whitehall

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?

2000-06-22 Thread Jon Boehnker

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

2000-06-22 Thread Philip Arnold - ASP

 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

2000-06-22 Thread Todd Everling

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

2000-06-22 Thread mherbene

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

2000-06-22 Thread Debbie McDaniel

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

2000-06-22 Thread Aidan Whitehall

 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

2000-06-22 Thread Robert Everland

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

2000-06-22 Thread Robert Everland

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

2000-06-22 Thread Morgan, Thomas J.

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

2000-06-22 Thread Jason Egan

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…

???

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

2000-06-22 Thread Sean Renet

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

2000-06-22 Thread Billy Cravens

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

2000-06-22 Thread Frédéric LeMieux

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

2000-06-22 Thread Zachary Bedell

-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

2000-06-22 Thread Sean Renet

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

2000-06-22 Thread Gina Shillitani

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

2000-06-22 Thread Sean Renet

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?

2000-06-22 Thread Anthony Israel-Davis

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

2000-06-22 Thread Marc Lippman

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

2000-06-22 Thread Gina Shillitani

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

2000-06-22 Thread Zachary Bedell

-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

2000-06-22 Thread Smith, Melanie

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

2000-06-22 Thread Eron Cohen

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

2000-06-22 Thread Robert Everland

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

2000-06-22 Thread Debbie McDaniel



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

2000-06-22 Thread David B. Brooks

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

2000-06-22 Thread Ruben Chadien

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

2000-06-22 Thread Zachary Bedell

-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

2000-06-22 Thread Todd Ashworth

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

2000-06-22 Thread Tim Bahlke

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

2000-06-22 Thread Olive, Christopher M Mr USACHPPM

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

2000-06-22 Thread Philip Arnold - ASP

 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

2000-06-22 Thread Todd Ashworth

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

2000-06-22 Thread Justin v0.9 MacCarthy

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

2000-06-22 Thread Ian Potts

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?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Tracking users through a site

2000-06-22 Thread Gina Shillitani

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

2000-06-22 Thread Justin v0.9 MacCarthy

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

2000-06-22 Thread Jason Egan

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

2000-06-22 Thread Bill

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

2000-06-22 Thread Dave Watts

 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

2000-06-22 Thread Karl Simanonok

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

2000-06-22 Thread Stuart Duncan

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

2000-06-22 Thread Larry Meadors

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

2000-06-22 Thread Greg Witte

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

2000-06-22 Thread Chip Sigourney

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

2000-06-22 Thread Seth Petry-Johnson

 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

2000-06-22 Thread Marla Jenkins

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

2000-06-22 Thread Philip Arnold - ASP

 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

2000-06-22 Thread Philip Arnold - ASP

 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

2000-06-22 Thread Philip Arnold - ASP

 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…

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

2000-06-22 Thread Paige Chandler

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

2000-06-22 Thread Zachary Bedell

-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

2000-06-22 Thread Steve Aylor


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

2000-06-22 Thread Zachary Bedell

-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

2000-06-22 Thread Sharon DiOrio

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

2000-06-22 Thread Judah McAuley

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.

2000-06-22 Thread miles

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

2000-06-22 Thread Christine Kelley

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

2000-06-22 Thread Justin v0.9 MacCarthy

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

2000-06-22 Thread Chris Farrugia

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

2000-06-22 Thread Tim Bahlke

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

2000-06-22 Thread Larry Juncker

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

2000-06-22 Thread Gina Shillitani

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

2000-06-22 Thread Dan Cameron

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

2000-06-22 Thread Jason Egan

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.

2000-06-22 Thread Dave Watts

 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

2000-06-22 Thread Robert Everland

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

2000-06-22 Thread Deanna L. Schneider

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 ???

2000-06-22 Thread Howie Hamlin

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.

2000-06-22 Thread Jon Boehnker

"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

2000-06-22 Thread Conrad, Christopher

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

2000-06-22 Thread Brandon Whitaker

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 ???

2000-06-22 Thread Brandon Whitaker

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

2000-06-22 Thread Michael Dinowitz

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

2000-06-22 Thread Adam Cantrell

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

2000-06-22 Thread Billy Cravens

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.

2000-06-22 Thread Billy Cravens

"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.

2000-06-22 Thread Mark Warrick

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

2000-06-22 Thread Lon Lentz


   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.



  1   2   >