CFINPUT required??

2000-05-29 Thread Deva Ramesh

hi all,

i have a very simple problem here. my CFINPUT tag doesnt work properly.
when i want it to be required it does not pop up the Dialog box.

am i missing something here?

thanx in advance

ramesh

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFINPUT required??

2000-05-29 Thread Dave Notik

Make sure you set the REQUIRED parameter and the MESSAGE parameter and that
the inputbox is within CFFORM tags, which must also contain your submit
button.  Also, be sure JavaScript is enabled in your browser.

-Dave

-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 29, 2000 12:05 AM
To: '[EMAIL PROTECTED]'
Subject: CFINPUT required??


hi all,

i have a very simple problem here. my CFINPUT tag doesnt work properly.
when i want it to be required it does not pop up the Dialog box.

am i missing something here?

thanx in advance

ramesh


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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: CFINPUT required??

2000-05-29 Thread Fred T. Sanders

hmm, care to elaborate a little more?  or better yet try and
paraphrase exactly what you want I think I know but I wanna
be sure.

Fred

- Original Message -
From: "Deva Ramesh" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 29, 2000 2:05 AM
Subject: CFINPUT required??


 hi all,

 i have a very simple problem here. my CFINPUT tag doesnt
work properly.
 when i want it to be required it does not pop up the
Dialog box.

 am i missing something here?

 thanx in advance

 ramesh

 --

 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Another Query to Table

2000-05-29 Thread Patric Stumpe

Well David,

that's the way... :-)

Thanks a lot.

Patric

- Original Message -
From: "David Gassner" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 29, 2000 2:25 AM
Subject: RE: Another Query to Table


| Patric, you'll need to use the index array method of getting to query
data.
| Here's some code which does what you want, assuming a query named "q" and
a
| field called "fieldvalue":
|
| !--- If number of items isn't divisible by three,
| add one row ---
| cfset numRows = q.recordcount / 3
| cfif (numRows mod 3)
| cfset numRows = int(numRows) + 1
| /cfif
|
| table cellpadding="5" cellspacing="0"
| cfloop from=1 to="#numRows#" index="currentRow"
|
| !--- Start the row with alternating colors ---
| cfoutput
|   tr bgcolor=#iif(currentRow mod 2,
| de("silver"),
| de("white"))#
| /cfoutput
|
| cfloop from="1" to="3" index="cellNumber"
|   cfset dataIndex = (numRows * (cellNumber-1)) + currentRow
|   td
|   cfif dataIndex lte q.recordcount
| cfoutput#dataindex#-#q.fieldvalue[dataIndex]#/cfoutput
|   /cfif
|   /td
| /cfloop
| /tr
|
| /cfloop
| /table
|
| David Gassner
| Vintage Business Applications

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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 error

2000-05-29 Thread Dave Wilson

Hi all,

Can anyone tell me what may be causing the following error on NT4, SP5,
CF4.01  SQL7.0 SP2, MDAC 2.5 installed on web server. Everything was
working fine for the past month or so then this just started to appear today
and no changes have been made.Here is thew error message

ODBC Error Code = S1000 (General error)


[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Fatal error 823
occurred at May 29 2000 10:36AM



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:84).


Date/Time: 05/29



Tia

Dave Wilson
Internet Technology Manager,
BizNet Solutions


Allaire Premier Partner
Co-Founder CFUG Ireland
http://www.cfug.ie

224, Lisburn Road
Belfast BT9 6GE

Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com

email: [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.



Web Cameras and CF

2000-05-29 Thread Gordon Burns

Client has decided he wants to have a Web cam (Exterior) looking
over an admittedly super beach next to his hotel. It can get
spectacularly wild.

So far so good,  however he wants to update the pic every 20 mins
and have every third one stored so users can see what it was like
on the hour any day of the year 7.am to 7pm.

Never worked with a Web cam but suspect there are some on the list
who have considered,  if not implemented this sort of stuff and
would welcome some suggestions on any aspect.  

Hardware, Do's , Don'ts, Gotchas etc. Web resources and even
example sites would all be helpful.

The existing site is CF driven so some sort of reference and path
to the image stored in a table seems to be the most sensible route.


Thanks


Gordon

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Web Cameras and CF

2000-05-29 Thread Yannick Simon

C'est un message de format MIME en plusieurs parties.

--=_NextPart_000_0432_01BFC97A.034F8780
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Web Cameras and CFUsually, a special software is provided with the =
webcam,
it stores the pictures in a .jpg file, at specific frequences.

It's up to you to store each hour the last file generated in a directory
and to rename it as you want

Yannick

  - Original Message -=20
  From: Gordon Burns=20
  To: [EMAIL PROTECTED]=20
  Sent: Monday, May 29, 2000 2:22 PM
  Subject: Web Cameras and CF


  Client has decided he wants to have a Web cam (Exterior) looking=20
  over an admittedly super beach next to his hotel. It can get=20
  spectacularly wild.=20

  So far so good,  however he wants to update the pic every 20 mins=20
  and have every third one stored so users can see what it was like=20
  on the hour any day of the year 7.am to 7pm.=20

  Never worked with a Web cam but suspect there are some on the list=20
  who have considered,  if not implemented this sort of stuff and=20
  would welcome some suggestions on any aspect. =20

  Hardware, Do's , Don'ts, Gotchas etc. Web resources and even=20
  example sites would all be helpful.=20

  The existing site is CF driven so some sort of reference and path=20
  to the image stored in a table seems to be the most sensible route.=20



  Thanks=20



  Gordon=20

  =
-=
-=20
  Archives: http://www.eGroups.com/list/cf-talk=20
  To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.


--=_NextPart_000_0432_01BFC97A.034F8780
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEADTITLEWeb Cameras and CF/TITLE
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Usually, a special software is provided =
with the=20
webcam,/FONT/DIV
DIVFONT face=3DArial size=3D2it stores the pictures in a .jpg file, =
at specific=20
frequences./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2It's up to you to store each hour the =
last file=20
generated in a directory/FONT/DIV
DIVFONT face=3DArial size=3D2and to rename it as you =
want/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Yannick/FONT/DIV
DIVnbsp;/DIV
BLOCKQUOTE=20
style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"
  DIV style=3D"FONT: 10pt arial"- Original Message - /DIV
  DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"BFrom:/B=20
  A href=3D"mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]Gordon=20
  Burns/A /DIV
  DIV style=3D"FONT: 10pt arial"BTo:/B A=20
  href=3D"mailto:[EMAIL PROTECTED]"=20
  [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV
  DIV style=3D"FONT: 10pt arial"BSent:/B Monday, May 29, 2000 2:22 =
PM/DIV
  DIV style=3D"FONT: 10pt arial"BSubject:/B Web Cameras and =
CF/DIV
  DIVBR/DIV
  PFONT size=3D2Client has decided he wants to have a Web cam =
(Exterior)=20
  looking/FONT BRFONT size=3D2over an admittedly super beach next =
to his=20
  hotel. It can get/FONT BRFONT size=3D2spectacularly wild./FONT =
/P
  PFONT size=3D2So far so good,nbsp; however he wants to update the =
pic every=20
  20 mins/FONT BRFONT size=3D2and have every third one stored so =
users can=20
  see what it was like/FONT BRFONT size=3D2on the hour any day of =
the year=20
  7.am to 7pm./FONT /P
  PFONT size=3D2Never worked with a Web cam but suspect there are =
some on the=20
  list/FONT BRFONT size=3D2who have considered,nbsp; if not =
implemented=20
  this sort of stuff and/FONT BRFONT size=3D2would welcome some =
suggestions=20
  on any aspect.nbsp; /FONT/P
  PFONT size=3D2Hardware, Do's , Don'ts, Gotchas etc. Web resources =
and=20
  even/FONT BRFONT size=3D2example sites would all be =
helpful./FONT /P
  PFONT size=3D2The existing site is CF driven so some sort of =
reference and=20
  path/FONT BRFONT size=3D2to the image stored in a table seems to =
be the=20
  most sensible route./FONT /PBR
  PFONT size=3D2Thanks/FONT /PBR
  PFONT size=3D2Gordon/FONT /P
  PFONT=20
  =
size=3D2=
--/FONT=20
  BRFONT size=3D2Archives: A =
href=3D"http://www.eGroups.com/list/cf-talk"=20
  target=3D_blankhttp://www.eGroups.com/list/cf-talk/A/FONT =
BRFONT=20
  size=3D2To Unsubscribe visit A=20
  =
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D=
lists/cf_talk"=20
  =
target=3D_blankhttp://www.houseoffusion.com/index.cfm?sidebar=3Dlistsam=
p;body=3Dlists/cf_talk/A=20
  or send a message to 

Buffering in ColdFusion.

2000-05-29 Thread Anton Westholm

Is there a way in ColdFusion to present the browser with output as a page 
executes instead of waiting until the page has finished executing?

In ASP this works by setting Response.Buffer = True

Thanks

/Anton

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Populating Select Box - Help?

2000-05-29 Thread Marco Gil

This is a multi-part message in MIME format.

--=_NextPart_000_006A_01BFC957.9B308810
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have the following situation... Two tables, one that stores the main =
category and another table that stores the subcategory and is linked to =
this main category.=20

For example, the main Category called Automotive may have several =
subcategories such as Leasing, Rentals etc...

I would like to populate a select drop-down box with both the Main =
Category and SubCategory and have it grouped by main category.

How do I go about doing this?  I know how to populate a select drop down =
box with one value.. but how do I group the values with the main =
category?  Any help would be greatly appreciated.

Marco


--=_NextPart_000_006A_01BFC957.9B308810
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#d4d0c8
DIVFONT face=3DArial size=3D2I have the following situation... Two =
tables, one=20
that stores the main category and another table that stores the =
subcategory and=20
is linked to this main category. /FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2For example, the main Category called =
Automotive=20
may have several subcategories such as Leasing, Rentals =
etc.../FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I would like to populate a select =
drop-down box=20
with both the Main Category and SubCategory and have it grouped by main=20
category./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2How do I go about doing this?nbsp; I =
know how to=20
populatenbsp;a select drop down box with one value.. but how do I group =
the=20
values with the main category?nbsp; Any help would be greatly=20
appreciated./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Marco/FONT/DIV
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_000_006A_01BFC957.9B308810--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



getting the name of the request page

2000-05-29 Thread vinicius

This is a multi-part message in MIME format.

--=_NextPart_000_0004_01BFC968.788DBD80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi there!
I'd like to know if there's a way to get the name of the page requested =
by the user? I'm creating a stats system, which will get the name of the =
template and for each request will increment a field in a database.
Thanks
Vinicius

--=_NextPart_000_0004_01BFC968.788DBD80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"
HTML
HEAD

META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type
META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR
/HEAD
BODY bgColor=3D#ff
DIVFONT color=3D#00 size=3D2Hi there!/FONT/DIV
DIVFONT color=3D#00 size=3D2I'd like to know if there's a way to =
get the=20
name of the page requested by the user? I'm creating a stats system, =
which will=20
get the name of the template and for each request will increment a field =
in a=20
database./FONT/DIV
DIVFONT color=3D#00 size=3D2Thanks/FONT/DIV
DIVFONT color=3D#00 size=3D2Vinicius/FONT/DIV/BODY/HTML

--=_NextPart_000_0004_01BFC968.788DBD80--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Multiple attributes in an LDAP Filter

2000-05-29 Thread Lanny R. Udey

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--Boundary_(ID_J308I14lNzfbT64WoFqDOA)
Content-type: text/plain; charset=US-ASCII
Content-disposition: inline
Content-transfer-encoding: 7BIT

Hi,

I have an LDAP query and want to filter on two attributes; sn and
givenName. I can get each to work seperately but when I combine then as
per the documentation, I get no results at all even though both worked
alone and retreived the same record.

The syntax I am using is:

filter="sn=#var1#,givenName=#var2#"

I have tried different combinations of attributes but whenever I have
two I get no results returned.

Does anyone know if this is a bug?

Thanks



Lanny Udey
Associate Dean
Learning and Information Technology
Hofstra University
(516)463-5163
[EMAIL PROTECTED]

--Boundary_(ID_J308I14lNzfbT64WoFqDOA)
Content-type: text/x-vcard; NAME="Lanny R. Udey.vcf"
Content-disposition: attachment; filename="Lanny R. Udey.vcf"
Content-transfer-encoding: 7BIT

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Udey, Lanny R.
TEL;WORK:3-5163
ORG:;Computer Cntr-academic
TEL;PREF;FAX:3-5380
EMAIL;WORK;PREF;NGW:ACCLRU
N:Udey;Lanny R.
TITLE:Assoc Dean Learning 
X-GWUSERID:ACCLRU
END:VCARD


--Boundary_(ID_J308I14lNzfbT64WoFqDOA)--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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 search problem

2000-05-29 Thread Sima Lee

Hi Eron,

Since my computer doesn't  like matches tag, I combined verity search with
SQL query and solved the problem. Now it works perfect.

Thank you very much for your help.

Sima
- Original Message -
From: Eron Cohen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, May 28, 2000 12:38 PM
Subject: Re: verity search problem


 Hi Sima,

 Great news that you have CFSEARCH almost working.

 Since you can make the search work by manually putting in some basic
search
 words, you know that your trouble must be in the way you are concatonating
 your search string.  You gave an example search string that is not
working:
 "(cf_custom2 'Picture','Video')And (mother)"  I am not sure why you have
 "CF_CUSTOM2" in your search.  The rest of it looks like it would work.
Just
 to test, try manually fixing the search criteria to be ('Picture','Video')
 And (mother).

 Eron

 - Original Message -
 From: Sima Lee [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Sunday, May 28, 2000 1:02 PM
 Subject: Re: verity search problem


  Hi Eron ,
  Thank you for your hint. When I manually enter a word as the criteria in
 the
  search tag it works. So I deleted the whole search form and start a very
  simple form to make sure the Form.Criteria is submitted properly. And it
  works perfect.
 
  Now, the problem is my search should allow the user to select different
 type
  to narrow the results. So when I add some more selections to the form
 
  The old problem comes back again. Now I send you all the code for your
  advice.
 
  Here is the code in the search file:
 
  cfif Isdefined("Form.all")
!--- "All" is a checkbox field. If "All" is selected then ingnore any
  type just matches the form.Criteria ---
   cfset  TheCriteria="#Form.Criteria#"
 
   !--- If "All is not selected ---
  cfelse
   cfif Isdefined("Form.ItemType")
 
   !--- " ItemType" is a checkbox  field which allows multiple
selections.
   If "ItemType" is defined then set TheCriteria eq the ItemType in the
 field
  matches the Form.Criteria ---
 
  cfset TheCriteria="(cf_custom2 matches
  #Form.ItemType#)And (#Form.Criteria#)"
  cfelse
   !--- if ItemType is not defined then just mathes the
Form.Criteria ---
   cfset TheCriteria="#Form.Criteria#"
   /cfif
  /cfif
 
   cfoutput#TheCriteria#/cfoutput
  CFSEARCH COLLECTION="test"
name="GetResults"
CRITERIA="#TheCriteria#"
 
  If I select All or  don't make any selection it just take the
 Form.Criteria
  and gives me the correct result. But If I make any selection in the
 ItemType
  it always gives me "0" results. If I select Picture and Vedio in the
  Form.ItemType field and enter mother in the Form.Criteria field , then
try
  to print out it like:cfoutput#TheCriteria#/cfoutput the result is
  :(cf_custom2 'Picture','Video')And (mother) . Is it should look like
this?
  If it is coreect why it doesn't work in the cfsearch tag?
 
 
  The code in the indexfile is like this:
 
  cfquery name="GetItems" datasource="test"
  SELECT ItemID, ItemName, Short_Desc,Long_Desc,
 Author,Year,TopCategoryName,
  SubCategoryName,SubSubCategoryName,FileName
  FROM items
 
  /cfquery
 
  cfindex action="update"
  collection="gleemail"
  key="ItemID"
  type="custom"
  title="ItemName"
  query="GetItems"
  body="Short_Desc,Long_Desc,
  Author,Year,TopCategoryName,SubCategoryName,SubSubCategoryName,FileName"
  custom1="FileName"
  custom2="ItemType"
 
 
 
  Here is the code in the searchform file :
 
  table align="center"
  cfform action="dsp_search.cfm" method="post"p
  tr
  td colspan="2"
  Please enter a keyword you want to searchbr
  /td
  /tr
  trtd colspan="2"  nbsp /td/tr
  tr
  td colspan="2"
  All   cfinput type="checkbox" name= "All" Value="All"
  Picture cfinput type="checkbox" name = "ItemType" value="'Picture'"
  checked
  Animation cfinput type="checkbox" name = "ItemType"
  value="'Animation'"
  Video cfinput type="checkbox" name = "ItemType" value="'Video'"
  Audio cfinput type="checkbox" name = "ItemType" Value="'Audio'"
 
  /td
  /tr
   trtd colspan="2"  nbsp /td/tr
 
  tr
  td colspan="2"
  Please enter a keyword you want to searchbr
  /td
  /tr
 
  tr
  td colspan="2"
  cfinput type="text" name="Criteria" size="30" maxlength="100"
  required="yes" message="You must enter a keyword"
  input type="submit" value="Go!"
  /td
  /tr
  /cfform
 
  /table
 
  Thank you again for your help.
 
 
  - Original Message -
  From: Eron Cohen [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Friday, May 26, 2000 3:59 PM
  Subject: RE: verity search problem
 
 
   Sima,
  
   What happens when you manually type in a search word that you know
must
   exist in your collection?
  
   Can you post the rest of the code you're using?
  
   Eron
  
   PS-  There have been alot of helpful posts regarding verity recently.
I
   don't have any of others handy, but here's some information I posted a
 few
   weeks ago that may help you:
  
  
   1)  The verity 

Re: Web Cameras and CF

2000-05-29 Thread Steve Reich

My experience has been that the software included with the cam will do all
that you mentioned.

- Original Message -
From: "Gordon Burns" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 29, 2000 8:22 AM
Subject: Web Cameras and CF


 Client has decided he wants to have a Web cam (Exterior) looking
 over an admittedly super beach next to his hotel. It can get
 spectacularly wild.

 So far so good,  however he wants to update the pic every 20 mins
 and have every third one stored so users can see what it was like
 on the hour any day of the year 7.am to 7pm.

 Never worked with a Web cam but suspect there are some on the list
 who have considered,  if not implemented this sort of stuff and
 would welcome some suggestions on any aspect.

 Hardware, Do's , Don'ts, Gotchas etc. Web resources and even
 example sites would all be helpful.

 The existing site is CF driven so some sort of reference and path
 to the image stored in a table seems to be the most sensible route.


 Thanks


 Gordon

 --

 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe 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: Web Cameras and CF

2000-05-29 Thread Rob Sherman

Try: http://www.webcam32.com/  you can have a live feed using a java applet
that you mandate forced live feed or update intervals, as well as having
timed shots taken and FTP'd to the server for storage.  No CF needed.




Sincerely,

Rob Sherman
Developer / Allaire Certified Instructor
CFDude, Inc.  http://www.cfdude.com
--
Email:[EMAIL PROTECTED]
ICQ:_3266081
AIM:__RobSSherm
Yahoo!:RobSherman_CFDev
Office:__(310) 543-1622
Office Fax:__(310) 543-0512
VMail/Fax:__(310) 754-6016 ext. 5630


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



cffile

2000-05-29 Thread nair ajit

Hi,

I'm using CFFILE command's UPLOAD action to upload photographs.In order to
restrict the users from uploading files other than gif's or jpeg's, i used
the ACCEPT attribute ie.

cffile action="upload" destnation="c:\temp"
accept="images/gif, images/jpeg"

But now what is happening is that even if I give an html file or an exe file
to upload,it accepts  that file is stored in the destination directory.

Please give me a solution to this problem.

---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.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: Buffering in ColdFusion.

2000-05-29 Thread Dave Notik

As far as I know, this is impossible with ASP.  I've wanted to do this
numerous times, but always resorted to using ASP for that functionality.
ColdFusion processes everything and creates an HTML page before sending it
to the browser.

-Dave

-Original Message-
From: Anton Westholm [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 29, 2000 7:08 AM
To: [EMAIL PROTECTED]
Subject: Buffering in ColdFusion.


Is there a way in ColdFusion to present the browser with output as a page
executes instead of waiting until the page has finished executing?

In ASP this works by setting Response.Buffer = True

Thanks

/Anton


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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: Web Cameras and CF

2000-05-29 Thread Judah McAuley

I had to set up a system like this for a client.  Basically, the process 
needs to work by attaching the web cam to a video board (like the Winnov) 
and having software that snags a jpg from the video feed every 20 
minutes.  Generally speaking, as long as the video board supports Video for 
Windows (known as vfw), then the web cam software you install should be 
able to work with the board.  There are some setups that allow you to 
remotely control the camera (pan and zoom) and you may need tighter 
integration between web cam software and video feed in that case.  I tried 
using Webcam32 and found that I really didn't like it much, in spite of the 
fact that it appears to be the most popular software out there.  Right now, 
we're using ChillCam (http://www.thegeek.com/chillcam/default.asp) and I'm 
pretty happy with it thus far.

We have the software running on startup on two P133's with 32MB of RAM 
running NT SP5.  It's running NT because the client has the machines 
sitting in broom closets and such and doesn't want people to have easy 
access to the machines.  We have it set to grab a photo every 2 minutes and 
ftp the image to the web server.  On the web server, I've got a scheduled 
task set up to copy the file into the main web directory every two 
minutes.  I do this so that there won't be any file locking problems with 
the web server accessing the file while the ftp session is trying to upload 
it.  The scheduled task checks to make sure that the file exists, that it's 
not a 0 K file, that it's newer than the file being overwritten, etc. and 
then copies the image.  I've got it set to run 6 am to 4:15 pm (ski resort 
hours).

By and large, it's worked fine.  We ran into a problem when we added a 
second camera.  To make a long story short, we were running into problems 
when 2 ftp sessions were writing files to the same directory at the same 
time.  We ended up assigning each camera a different ftp username and a 
different home directory so that we don't have any file/directory locking 
issues.  Besides that, it's been pretty straight forward.

If you want to see it in action, go to: http://www.mtbachelor.com/weather.cfm

Hope this helps,
Judah

At 01:22 PM 5/29/2000 +0100, you wrote:
Client has decided he wants to have a Web cam (Exterior) looking
over an admittedly super beach next to his hotel. It can get
spectacularly wild.

So far so good,  however he wants to update the pic every 20 mins
and have every third one stored so users can see what it was like
on the hour any day of the year 7.am to 7pm.

Never worked with a Web cam but suspect there are some on the list
who have considered,  if not implemented this sort of stuff and
would welcome some suggestions on any aspect.

Hardware, Do's , Don'ts, Gotchas etc. Web resources and even
example sites would all be helpful.

The existing site is CF driven so some sort of reference and path
to the image stored in a table seems to be the most sensible route.


Thanks


Gordon

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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.



Tricky sorting riddle.

2000-05-29 Thread Cyrill Vatomsky

Hi All,

I am building a real-estate DB and I have stumbled over an interesting
riddle:

In this case I use the following fields in Access DB (tenants)

Property_ID -integer (related to an ID in Properties table)
Name-Text,
sq_ft   -integer
rate-currency
lease_start -date,
term-integer (months)

At some point I want to output a partial list of tenants:

cfquery name="gettenants" datasource="xyz"
  SELECT *
  FROM tenants
  WHERE Property_ID=#Form.ID#
 !--- where form.id is a ID of a property I list tenants for ---
/cfquery

Based on existing data, I want to sort those tenants so that those with
closest expiration dates are listed first.

I thought of using a structure (name, CalculatedExpirationDate), but then I
will still need to output other fields from the query, like rate and sq_ft.

Is there any other way? Can such sorting be done within cfquery tag?

Cyrill

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Tricky sorting riddle.

2000-05-29 Thread Cyrill Vatomsky


Followup to my own message :-)


 Hi All,

 I am building a real-estate DB and I have stumbled over an
 interesting riddle:

 In this case I use the following fields in Access DB (tenants)

 Property_ID   -integer (related to an ID in Properties table)
 Name  -Text,
 sq_ft -integer
 rate  -currency
 lease_start   -date,
 term  -integer (months)

 At some point I want to output a partial list of tenants:

 cfquery name="gettenants" datasource="xyz"
   SELECT *
   FROM tenants
   WHERE Property_ID=#Form.ID#
  !--- where form.id is a ID of a property I list tenants for ---
 /cfquery

 Based on existing data, I want to sort those tenants so that
 those with closest expiration dates are listed first.

 I thought of using a structure (name, CalculatedExpirationDate),
 but then I will still need to output other fields from the query,
 like rate and sq_ft.

 Is there any other way? Can such sorting be done within cfquery tag?

 Cyrill


I tried to execute this: (instead of #CreateODBCDate(now())# I also used
getdate() which should have worked with SQL server, but I am working with
Access and it says that getdate() is undefined)

cfquery name="getTenants" datasource="xyz"
 SELECT ID, Since, Rate, Lease_length, sq_ft_leased, Name,
Datediff(dd,#CreateODBCDate(now())#, DateAdd(MONTH,lease_length,Since)) AS
sortable_date
 FROM tenants
 where Property_ID=#TheRecord.ID#
 Order by sortable_date
/cfquery,

But I get this:
---
ODBC Error Code = 07001 (Wrong number of parameters)


[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
correctly.
---

All names check out OK.

Bummer!

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Tricky sorting riddle.

2000-05-29 Thread Jim McAtee

Not too sure what date functions are valid in Access, but you couldn't use an CF
functions within the expression if you expect it to be executed by the database.
How about just:

cfquery name="getTenants" datasource="xyz"
SELECT ID, Since, Rate, Lease_length, sq_ft_leased, Name,
   DateAdd(MONTH,lease_length,Since) AS sortable_date
FROM tenants
WHERE Property_ID=#TheRecord.ID#
ORDER BY sortable_date
/cfquery



-Original Message-
From: Cyrill Vatomsky [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, May 29, 2000 5:08 PM
Subject: RE: Tricky sorting riddle.



Followup to my own message :-)


 Hi All,

 I am building a real-estate DB and I have stumbled over an
 interesting riddle:

 In this case I use the following fields in Access DB (tenants)

 Property_ID -integer (related to an ID in Properties table)
 Name -Text,
 sq_ft -integer
 rate -currency
 lease_start -date,
 term -integer (months)

 At some point I want to output a partial list of tenants:

 cfquery name="gettenants" datasource="xyz"
   SELECT *
   FROM tenants
   WHERE Property_ID=#Form.ID#
  !--- where form.id is a ID of a property I list tenants for ---
 /cfquery

 Based on existing data, I want to sort those tenants so that
 those with closest expiration dates are listed first.

 I thought of using a structure (name, CalculatedExpirationDate),
 but then I will still need to output other fields from the query,
 like rate and sq_ft.

 Is there any other way? Can such sorting be done within cfquery tag?

 Cyrill


I tried to execute this: (instead of #CreateODBCDate(now())# I also used
getdate() which should have worked with SQL server, but I am working with
Access and it says that getdate() is undefined)

cfquery name="getTenants" datasource="xyz"
 SELECT ID, Since, Rate, Lease_length, sq_ft_leased, Name,
Datediff(dd,#CreateODBCDate(now())#, DateAdd(MONTH,lease_length,Since)) AS
sortable_date
 FROM tenants
 where Property_ID=#TheRecord.ID#
 Order by sortable_date
/cfquery,

But I get this:
---
ODBC Error Code = 07001 (Wrong number of parameters)


[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
correctly.
---

All names check out OK.

Bummer!


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Removing spaces

2000-05-29 Thread C

I need a form field that accepts the data, but removes all appearances of 
spaces from the field in case a user enters any.

CW

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Removing spaces

2000-05-29 Thread Steve Reich

 I need a form field that accepts the data, but removes all appearances of
 spaces from the field in case a user enters any.

You can use the trim function to remove spaces at the beginning or end of a
string...
Trim(Var)

If you want to remove spaces that exist in the middle of a string as well, I
would use the replace function...
Replace("This is a test", " ", "", "ALL")

HTH,
Steve

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Removing spaces

2000-05-29 Thread Mark Ireland


Just replace(form.field,spaces,with nothing) when you save it. . . 

At 07:18 PM 29/05/00 -0500, you wrote:
I need a form field that accepts the data, but removes all appearances of 
spaces from the field in case a user enters any.

CW

---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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: Removing spaces

2000-05-29 Thread Nick Slay

Try Replace(Form.Field, " ", "")

Nick


At 19:18 29/05/00 -0500, you wrote:
I need a form field that accepts the data, but removes all appearances of
spaces from the field in case a user enters any.

CW

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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.



client.path_info = cgi.path_info

2000-05-29 Thread Mark Ireland


As a way of tracking users (or just returning them to where they started)
I have started to use cfset client.path_info = cgi.path_info
Every page sets it except those that actually use it. 

It seems to work. . Is it unclever? Is there a better way?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Buffering in ColdFusion.

2000-05-29 Thread Dave Watts

 Is there a way in ColdFusion to present the browser with
 output as a page executes instead of waiting until the page
 has finished executing?

 In ASP this works by setting Response.Buffer = True

Unfortunately, there is no analogous capability in CF; it's one of the few
areas where CF doesn't have functionality found in ASP.

There are ways to simulate this by using frames or JavaScript or page
refreshes, but they tend to be a bit messy.

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: Developer Conference: Hotel Accommodations

2000-05-29 Thread James Brown

Several people who went to the e-commerce meeting in Rockville a couple
of months ago used priceline and got some pretty good deals on both
flight and room ($80 a nite for the Rockville Marriot).  For me
priceline is just a little too much like gambling.  I stayed in
Gaithersburg at a Sleep Inn which was abour $50 a nite, and each room
had a pc with high speed internet access.  It was within walking
distance of the Metro.

James Brown
Godfather of Cod,  Err I mean Sole.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Tricky sorting riddle.

2000-05-29 Thread Stephen Hait

Have you tried:
...
ORDER BY DateAdd(MONTH,lease_length,Since)
???

Good luck,
Stephen


 
 Followup to my own message :-)
 
 
  Hi All,
 
  I am building a real-estate DB and I have stumbled over an
  interesting riddle:
 
  In this case I use the following fields in Access DB (tenants)
 
  Property_ID -integer (related to an ID in Properties table)
  Name-Text,
  sq_ft   -integer
  rate-currency
  lease_start -date,
  term-integer (months)
 
  At some point I want to output a partial list of tenants:
 
  cfquery name="gettenants" datasource="xyz"
SELECT *
FROM tenants
WHERE Property_ID=#Form.ID#
   !--- where form.id is a ID of a property I list tenants for ---
  /cfquery
 
  Based on existing data, I want to sort those tenants so that
  those with closest expiration dates are listed first.
 
  I thought of using a structure (name, CalculatedExpirationDate),
  but then I will still need to output other fields from the query,
  like rate and sq_ft.
 
  Is there any other way? Can such sorting be done within cfquery
  tag?
 
  Cyrill
 
 
 I tried to execute this: (instead of #CreateODBCDate(now())# I also
 used getdate() which should have worked with SQL server, but I am
 working with Access and it says that getdate() is undefined)
 
 cfquery name="getTenants" datasource="xyz"
  SELECT ID, Since, Rate, Lease_length, sq_ft_leased, Name,
 Datediff(dd,#CreateODBCDate(now())#,
 DateAdd(MONTH,lease_length,Since)) AS sortable_date
  FROM tenants
  where Property_ID=#TheRecord.ID#
  Order by sortable_date
 /cfquery,
 
 But I get this:
 ---
 ODBC Error Code = 07001 (Wrong number of parameters)
 
 
 [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
 Expected 3.
 
 Hint: The cause of this error is usually that your query contains a
 reference to a field which does not exist. You should verify that
 the fields included in your query exist and that you have specified
 their names correctly. ---
 
 All names check out OK.
 
 Bummer!
 
 
 -- Archives: http://www.eGroups.com/list/cf-talk To
 Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_t
 alk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


Stephen Hait [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: SQL server error

2000-05-29 Thread Dave Watts

 Can anyone tell me what may be causing the following error on
 NT4, SP5, CF4.01  SQL7.0 SP2, MDAC 2.5 installed on web server.
 Everything was working fine for the past month or so then this
 just started to appear today and no changes have been made.
 Here is thew error message

 ODBC Error Code = S1000 (General error)


 [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Fatal
 error 823 occurred at May 29 2000 10:36AM

Yikes! You might want to get that looked at. Here's the description of the
error message from SQL 7 Books Online, followed by a description of the
severity level:

"Error 823
Severity Level 24
Message Text
I/O error %ls detected during %S_MSG of %S_BUF.

Explanation
Microsoft® SQL Server™ encountered an I/O error on a read or write request
made to a device. This error usually indicates disk problems. The parameters
in the error message refer to internal structures and don’t often help
determine which device is involved. However, additional kernel messages in
the error log, recorded before error 823, should indicate which device is
involved.

Action
Check the accessibility and condition of the device in question. After you
have identified and corrected the problem, execute DBCC CHECKDB to ensure
that no other damage was caused by the bad device. For information about
using DBCC CHECKDB, see DBCC CHECKDB.

Important If executing DBCC CHECKDB with one of the repair clauses does not
correct the index problem or if you are unsure what effect DBCC CHECKDB with
a repair clause has on your data, contact your primary support provider.

In addition, run hardware diagnostics and correct any problems."

"Severity Level 24: Hardware Error
These messages indicate some type of media failure. The system administrator
might have to reload the database. It might also be necessary to call your
hardware vendor."

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



RE: cftree background color?

2000-05-29 Thread Dave Watts

 I know that there is not an attribute for background color in
 the cftree tag, but I'd really like a way to modify it
 nonetheless. Does anyone know of a way around this limitation?

One of the problems with the Java applets provided with CF is that you have
to take them or leave them; you can't really extend them. So, your options
are pretty limited. You could write your own Java tree applet, or you could
find one which has the flexibility you need, although you won't be able to
use it with the convenience provided by the CFTREE tag.

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: Using authenticated SMTP with CFMAIL

2000-05-29 Thread Howie Hamlin

iMS will support this in the near future (including POST SE).  Details are
at www.coolfusion.com

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: Leong Yew [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 29, 2000 8:10 PM
Subject: Using authenticated SMTP with CFMAIL



 Does anyone know if it is possible to use CFMAIL tag to send email through
 SMTP servers that need authentication? The tag doesn't seem to support
 additional attributes for that process but does anyone know if there's a
 trick to doing this?

 Thanks.

 Leong

 --

 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe 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 error

2000-05-29 Thread Nick Slay

You may also want to try the DBCC CHECKIDENT (tablename) just to make sure 
there aren't any problems with Identity columns if you are using them.



At 22:49 29/05/00 -0400, you wrote:
  Can anyone tell me what may be causing the following error on
  NT4, SP5, CF4.01  SQL7.0 SP2, MDAC 2.5 installed on web server.
  Everything was working fine for the past month or so then this
  just started to appear today and no changes have been made.
  Here is thew error message
 
  ODBC Error Code = S1000 (General error)
 
 
  [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Fatal
  error 823 occurred at May 29 2000 10:36AM

Yikes! You might want to get that looked at. Here's the description of the
error message from SQL 7 Books Online, followed by a description of the
severity level:

"Error 823
Severity Level 24
Message Text
I/O error %ls detected during %S_MSG of %S_BUF.

Explanation
Microsoft® SQL Server™ encountered an I/O error on a read or write request
made to a device. This error usually indicates disk problems. The parameters
in the error message refer to internal structures and don’t often help
determine which device is involved. However, additional kernel messages in
the error log, recorded before error 823, should indicate which device is
involved.

Action
Check the accessibility and condition of the device in question. After you
have identified and corrected the problem, execute DBCC CHECKDB to ensure
that no other damage was caused by the bad device. For information about
using DBCC CHECKDB, see DBCC CHECKDB.

Important If executing DBCC CHECKDB with one of the repair clauses does not
correct the index problem or if you are unsure what effect DBCC CHECKDB with
a repair clause has on your data, contact your primary support provider.

In addition, run hardware diagnostics and correct any problems."

"Severity Level 24: Hardware Error
These messages indicate some type of media failure. The system administrator
might have to reload the database. It might also be necessary to call your
hardware vendor."

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: [RE: Directory Structure Permissions]

2000-05-29 Thread Dave Watts

 Thanks Dave. Is there any default setting in CF Administrator
 we should be aware of which may compromise security?

No, not really. There are several security issues in setting CF up, though,
which are pretty well documented in the Allaire knowledge base; IIS security
issues can be found at the Microsoft site, among other places.

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: Buffering in ColdFusion.

2000-05-29 Thread stas

If we are talking about outputting a ton of records on the screen, then you
can speed up a process somewhat if you are formatting them in a table:

Instead of:

table
cfoutput query = "myquery"
tr
td#data#/td
/tr
/cfoutput
/table

you can do this:

cfoutput query = "myquery"
table
tr
td#data#/td
/tr
/table
/cfoutput


At 09:57 PM 5/29/00 -0400, you wrote:
 Is there a way in ColdFusion to present the browser with
 output as a page executes instead of waiting until the page
 has finished executing?

 In ASP this works by setting Response.Buffer = True

Unfortunately, there is no analogous capability in CF; it's one of the few
areas where CF doesn't have functionality found in ASP.

There are ways to simulate this by using frames or JavaScript or page
refreshes, but they tend to be a bit messy.

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: Removing spaces

2000-05-29 Thread C

At 10:31 AM 5/30/00 +1000, you wrote:
Try Replace(Form.Field, " ", "")

Nick


Hmm.  Yeah, I get this in concept of using a CFOUTPUT.. ie, 
#replace(Form.Field," ","") however, I'm trying to get this all to execute 
in the form input command when it inserts records.. *shrug* I know I am 
missing something obvious here.. it's just too late at night ;)

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Removing spaces

2000-05-29 Thread Nick Slay

gotcha...

the answer then, is not so good!  :^)Unless anyone knows better, I 
think that you'll have to use a CFQUERY to Insert the records rather than 
CFINSERT.
That way you can do the Replace() on the field.

hmmm... the only other thing you could try, and I'm not sure if this will 
work, is to try doing a CFSET fieldname = Replace(fieldname, " ", "", 
"ALL") before calling the CFINSERT.  this would keep the formname the same, 
but I haven't tried this, so I don't know if it will work.   I guess it 
depends on whether CFINSERT looks for variables formname or form.formname.

Nick


At 22:53 29/05/00 -0500, you wrote:
At 10:31 AM 5/30/00 +1000, you wrote:
 Try Replace(Form.Field, " ", "")
 
 Nick


Hmm.  Yeah, I get this in concept of using a CFOUTPUT.. ie,
#replace(Form.Field," ","") however, I'm trying to get this all to execute
in the form input command when it inserts records.. *shrug* I know I am
missing something obvious here.. it's just too late at night ;)

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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: Removing spaces

2000-05-29 Thread C

At 02:00 PM 5/30/00 +1000, you wrote:
gotcha...

the answer then, is not so good!  :^)Unless anyone knows better, I
think that you'll have to use a CFQUERY to Insert the records rather than
CFINSERT.
That way you can do the Replace() on the field.

hmmm... the only other thing you could try, and I'm not sure if this will
work, is to try doing a CFSET fieldname = Replace(fieldname, " ", "",
"ALL") before calling the CFINSERT.  this would keep the formname the same,
but I haven't tried this, so I don't know if it will work.   I guess it
depends on whether CFINSERT looks for variables formname or form.formname.

Nope, I tried the CFSETlpl= however, that didn't fix it :(  *shrug* welp, 
just have to restructure the input page to do all inputs via CFQUERY...


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Need Suggestion : About Uploading files

2000-05-29 Thread Phim

Hi ,

I am about new starting in Cold fusion and I have project development by
Cold Fusion.
My project need 1 page that can download files(picture file) from my
computer to locate at server.

Can you please give me suggesstion ,what object do I need to install at
server ?
Where the place that I can found help about using that object or develop
this page .


Best regards.

Chiraporn Bualert ( Phim )
Software Developer

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: DB Clientstorage and Hitcount and Performance

2000-05-29 Thread Dave Watts

 What are the real performance issues with having global
 client variables enabled?

If you're using a datasource to contain Client variables, then there's a
query every time they're read or written. That's significant compared to
using Session variables, especially if you're putting large strings in them,
such as WDDX packets, to get the same functionality as you could get by
storing queries or arrays in Session variables.

 I just did some testing and it seems HITCOUNT increases
 with each client variable change on a different page within
 an app. What's the point of Hitcount if it's updated everytime
 a client variable is changed? It doesn't tell you how often
 someone visits your site, but rather how often your client
 variables change. I mean has anyone found a use for this
 field? No wonder your registry explodes if you keep this
 stuff in the registry

When you set up a datasource as a Client variable repository, there's a
setting which allows you to disable global client variable updates. When you
select this setting, HITCOUNT will behave as you've described above. If you
clear the setting, HITCOUNT should increment for every page requested by the
user associated with the Client variables, instead of it just updating when
a variable is changed.

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: Need Suggestion : About Uploading files

2000-05-29 Thread Leong Yew

Hi,

I take it you're looking to transfer a file from your computer to the
server? If this is the case there's no need to install any additional
components. CF already has a built-in tag called CFFILE.

All you have to do is write a forms page with the input-file html tag and
send that to a CF action page that uses CFFILE. The following is from the CF
4.5 documentation:

CFFILE ACTION="Upload"
FILEFIELD="formfield"
DESTINATION="full_path_name"
NAMECONFLICT="behavior"
ACCEPT="mime_type/file_type"
MODE="permission"
ATTRIBUTES="file_attributes"

Use the MODE attribute when you're using UNIX, disregard if you're on NT.

Hope this helps

Leong

-Original Message-
From: Phim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 1:44 PM
To: [EMAIL PROTECTED]
Subject: Need Suggestion : About Uploading files


Hi ,

I am about new starting in Cold fusion and I have project development by
Cold Fusion.
My project need 1 page that can download files(picture file) from my
computer to locate at server.

Can you please give me suggesstion ,what object do I need to install at
server ?
Where the place that I can found help about using that object or develop
this page .


Best regards.

Chiraporn Bualert ( Phim )
Software Developer


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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.



non breaking spaces in DateFormat()

2000-05-29 Thread Mark Ireland

Has anyone managed a version of DateFormat() that puts non-breaking spaces
in the date output? I mean nbsp;  Could I just do a replace()?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Need Suggestion : About Uploading files

2000-05-29 Thread Phim

Thanks you very much :)
I am in NT , so How i should do next.

Phim.

-Original Message-
From: Leong Yew [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 12:05 PM
To: [EMAIL PROTECTED]
Subject: RE: Need Suggestion : About Uploading files


Hi,

I take it you're looking to transfer a file from your computer to the
server? If this is the case there's no need to install any additional
components. CF already has a built-in tag called CFFILE.

All you have to do is write a forms page with the input-file html tag and
send that to a CF action page that uses CFFILE. The following is from the CF
4.5 documentation:

CFFILE ACTION="Upload"
FILEFIELD="formfield"
DESTINATION="full_path_name"
NAMECONFLICT="behavior"
ACCEPT="mime_type/file_type"
MODE="permission"
ATTRIBUTES="file_attributes"

Use the MODE attribute when you're using UNIX, disregard if you're on NT.

Hope this helps

Leong

-Original Message-
From: Phim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 1:44 PM
To: [EMAIL PROTECTED]
Subject: Need Suggestion : About Uploading files


Hi ,

I am about new starting in Cold fusion and I have project development by
Cold Fusion.
My project need 1 page that can download files(picture file) from my
computer to locate at server.

Can you please give me suggesstion ,what object do I need to install at
server ?
Where the place that I can found help about using that object or develop
this page .


Best regards.

Chiraporn Bualert ( Phim )
Software Developer


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe 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.