Re: cookies timeout!

2001-05-08 Thread Michael Lugassy
That's exactly what I use: cfcookie name=psuserNICK value=#fixedusernick# expires=NEVER and the cookie is terminated/deleted whenever I close the browser. on the application.cfm there is: cfapplication name=photoshare clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes

RE: [cold_fusion] Unusual Results, help

2001-05-08 Thread Aidan Whitehall
:huh?: Why would you expect an outer loop control variable to increment in the inner loop? It doesn't seem to make any sense to me. This was the situation I was referring to... With these records Parents 1 2 Children 3,4 5,6 I would like / expect / anticipate this code CFLOOP

Re: Credit Card DB Encryption Methodology

2001-05-08 Thread Larry W. Virden
I'm rather surprised that I so seldom see someone suggestion using one's own public key to encrypt the data, and your private key to decrypt the data - are people just not using PGP and the like? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED]

RE: Duplicate CFTOKEN and CFID . . .

2001-05-08 Thread alistair . davidson
The other problem we've had with this is that users often email links to each other. If CFID CFTOKEN are in the URL, you then get multiple users with the same CFID CFTOKEN. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 07:08 To: CF-Talk Subject:

RE: Pause

2001-05-08 Thread alistair . davidson
You could have the server page that creates the text files - 1) use CFCONTENT to automatically deliver the text files, 2) make it POST the files back with CFHTTP 3) CFOUTPUT the contents of the text file into a HTML comment, then parse the file content out of CFHTTP.Filecontent All of the

using WDDX for next 'n' style browsing

2001-05-08 Thread Kola Oyedeji
I am passing a query object which consists of 1000 records in a hidden form field between pages as a WDDX packet, are there any reasons why this is a bad idea, such as limits to the amount of data which can be held in a form field or passed in a form? The reason for this is to save a trip to

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread DeVoil, Nick
I guess you mean the database server. You're still making a trip to the *web* server for every page - and sending a lot of data. Without knowing exactly what you're trying to achieve, I'd guess cacheing the query would be better, yes. Nick -Original Message- From: Kola Oyedeji

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Kola Oyedeji
Nick yes, you're right the page still has to download with all the extra data, in addition to this turning the wddx packet into a javascript object (to be displayed)is adding extra processing to the page the page takes an average of 200 milliseconds. What i'm trying to acheive is an alternative

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread DeVoil, Nick
Right, that's exactly what cacheing the query will do for you. Nick -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:15 PM To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing Nick yes, you're right the page still has to

RE: CF 5.0 RC : Problem with CFFTP - 0 size

2001-05-08 Thread Rudy Rustam
Finally got a good solution in beta forum http://beta.allaire.com/betaconf/Thread.cfm?Thread_ID=229574mc=27 Thanks for the tips! - Rudy -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 May 2001 6:38 AM To: CF-Talk Subject: RE: CF 5.0 RC : Problem

RE: Daylight savings time on the server?

2001-05-08 Thread Paul Ihrig
Kevin, Thank You. no i am not using the GetTimeZoneInfo function. i didn't know there was one, should i be using it? how would i use it? i was just pulling the date from the db, which was inserted at class creation. Jim, thanks. but i think that may be unrelated. the article says it would only

Re: using WDDX for next 'n' style browsing

2001-05-08 Thread Michael Lugassy
I do search diffrently, I first get ALL the results (as COUNT(*)) into a variable, which I transfer from page to page. Then I QUERY search with maxrows=20 (or as many as you want displayed on a single page). then every time a user click next, he's transfering some info on the urls: 1-

cfstoredproc and cftransaction

2001-05-08 Thread MIKE GEORGE
What is the best way of handling the following situation. I have 3 stored procedures I want to call from coldfusion and once all 3 have executed sucessfully, I want to commit them, if any fails, I want to do a rollback. Can this be done with cftransaction or is that only to be used with the

RE: cfstoredproc and cftransaction

2001-05-08 Thread Andy Ewings
Use Distributed transaction control from within SQL. Don't let CF deal with it. You need a Stored proc which calls each of the three sp's within a distributed transaction. If either of them fails you need to trap the error and rollback the transaction. I'd put normal transaction contrpol

CF-Studio registration number

2001-05-08 Thread CF-Talk \(SD Solutions\)
Hi, is there a way to fill in the registration number of a CF 4.5.2 Studio EVAL-Version later after installation ? I downloaded it because I couldn't find my original CF-Studio-CD. I looked in the registry but I couldn't find anything concerning a registration number. Thanks for ideas. Uwe

yummy cookie!

2001-05-08 Thread Michael Lugassy
I use: cfcookie name=cookiename value=#value# expires=NEVER and the cookie is terminated/deleted whenever I close the browser. on the application.cfm there is: cfapplication name=appname clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes clientstorage=Cookie Any idea why this is

RE: Pause

2001-05-08 Thread Falksen, Steven A
There is a custom tag cf_wait that will wait so many seconds -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 1:04 AM To: CF-Talk Subject: Pause I have one page that goes to a server with form fields and makes it create a text file. I then

cfpop - how to display html content properly?

2001-05-08 Thread Rudy Rustam
Here is my scenario: Go to any website with a complex html like www.cnn.com or www.cnet.com Sent the page (not the link) to your popmail account. Use cfpop to retrive it. - The Problem (my problem) The mail doesn't show the html format properly, it's a mess html page. Is it possible that cfpop

RE: yummy cookie!

2001-05-08 Thread Darren Adams
Do you need to set the expiry details in the application.cfm as well ? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 14:17 To: CF-Talk Subject: yummy cookie! I use: cfcookie name=cookiename value=#value# expires=NEVER and the cookie is

RE: How to resolve help file links into web pages in Studio 4?

2001-05-08 Thread Darren Adams
The help files will be looking for your local host. If you are using another machine as the server then you need to put this machines IP address or name. I.E for our test server I need to replace the localhost bit of the url with uk1web2 to route it to the test server. -Original

Re: cfpop - how to display html content properly?

2001-05-08 Thread savan . thongvanh
are you changing the mime type? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Kola Oyedeji
Thanks i'll give it a try KOla -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 13:36 To: CF-Talk Subject: Re: using WDDX for next 'n' style browsing I do search diffrently, I first get ALL the results (as COUNT(*)) into a variable, which I

Re: having multiple groups

2001-05-08 Thread Paul Smith
I have three tables, Projects, Project Types (ProjTypes), and Project Categories (ProjCats). The are 7 Project Categories and 37 Project Types. Each Project Category may have several Project Types. Each Project Type may have several Projects. The table ProjTypeProjects relates IDs from

RE: UK-based ColdFusion training course for network administrator s

2001-05-08 Thread Darren Adams
You might want to check out Highlander.co.uk I did the advanced course there, they might well do a network administrators one as well. Daz -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: 03 May 2001 11:14 To: CF-Talk Subject: RE: UK-based ColdFusion training

RE: CF-Studio registration number

2001-05-08 Thread Dylan Bromby
just enter the serial number when you install it. you can uninstall and reinstall with the number. -Original Message- From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 5:13 AM To: CF-Talk Subject: CF-Studio registration number Hi, is there a way to

Re: using WDDX for next 'n' style browsing

2001-05-08 Thread Sean Daniels
On 5/8/01 6:52 AM Kola Oyedeji wrote: I am passing a query object which consists of 1000 records in a hidden form field between pages as a WDDX packet, are there any reasons why this is a bad idea, such as limits to the amount of data which can be held in a form field or passed in a form? I

RE: cfpop - how to display html content properly?

2001-05-08 Thread DeVoil, Nick
Try replacing with lt; and with gt; That does it for me. Nick -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 1:41 PM To: CF-Talk Subject: cfpop - how to display html content properly? Here is my scenario: Go to any website with a complex

GRRRR Claris Works 5.0 DB

2001-05-08 Thread Eric Dawson
G Claris Works 5.0 DB I have a Claris Works 5DB, and need to convert to anything useful in the W2K/Office 2000 World. ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

OT: Re: GRRRR Claris Works 5.0 DB

2001-05-08 Thread Sean Daniels
On 5/8/01 9:47 AM Eric Dawson wrote: G Claris Works 5.0 DB I have a Claris Works 5DB, and need to convert to anything useful in the W2K/Office 2000 World. ideas? Does Claris have any kind of export? Like, preferably export comma delim values, then you can import into Access quite

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Kola Oyedeji
Sean Thats a really good idea, just one question how do you manage all the query files such as old queries etc? KOLa -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 14:33 To: CF-Talk Subject: Re: using WDDX for next 'n' style browsing On 5/8/01 6:52

WDDX shows all the data!!!

2001-05-08 Thread Akbar Pasha
Hi all, is there a way to hide all the javascript that CFWDDX tag generates when action is CFML2JS its not only annoying but also shows up all the sensitive data that comes into it. Gosh now thats bad. any ideas?? TIA ::akbar ~~ Structure

Re: having multiple groups SOLUTION

2001-05-08 Thread Paul Smith
It's often so helpful to ask a question ;-) No sooner than I posted the below, I *think* I found the solution. SELECT ProjTypes.ProjType,Projects.ProjectTitle,ProjCats.ProjCat FROM ProjTypes,ProjTypeProjects,Projects,ProjCats,ProjCatProjTypes WHERE ProjCats.ProjCatID=ProjCatProjTypes.ProjCatID

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Paul Smith
The is no maximum number of cached queries. Turns out it's a CF Urban Legend. I cache a bunch and for cases like this I set the expire to 5 or 10 minutes. best, paul At 02:56 PM 5/8/01 +0100, you wrote: It was way faster than rerunning the query, and although caching the query would be

Re: yummy cookie! PLEASE HELP

2001-05-08 Thread Michael Lugassy
you're asking or telling? please help me, I can't seem to work this out. - Original Message - From: Darren Adams [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 2:33 PM Subject: RE: yummy cookie! Do you need to set the expiry details in the

Re: Credit Card DB Encryption Methodology

2001-05-08 Thread Kay Smoljak
On Tue, 08 May 2001 06:09:49 -0400 (EDT), Larry W. Virden [EMAIL PROTECTED] wrote: I'm rather surprised that I so seldom see someone suggestion using one's own public key to encrypt the data, and your private key to decrypt the data - are people just not using PGP and the like? We do exactly

RE: WDDX shows all the data!!!

2001-05-08 Thread DeVoil, Nick
If you convert it to JavaScript and send it to the browser, then of course you can see the data. If there's data you want to hide, don't send it to the browser. Nick -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:03 PM To: CF-Talk Subject:

Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Philip Arnold - ASP
Does anyone know if there is a limit to the amount of text that is passed in a CFQuery to SQL Server? I'm currently running a query that is 64KB of SQL text - and that wasn't a typing mistake! The problem is that when it seems to break a certain size and return zero records or the query won't

RE: CFIF Help

2001-05-08 Thread David Shadovitz
ListPosition is 0 because ListFind looks for a matching *element*, not a matching *string*. Use ListContains if you want your search for 1 to return the index of the 1st element which contains a 1. -David On Monday, May 07, 2001 10:52 PM, Joshua Tipton [SMTP:[EMAIL PROTECTED]] wrote: Why any

Re: having multiple groups

2001-05-08 Thread Gregg Kachel
Thanks Victor, the UNION operator worked great. Had never heard of that one, but I'm still learning ! Jason, thanks for your idea too, I will keep that in mind, but the idea of creating another table didn't sound too fun. Or is there away for access to do it for you? Or cold fusion? Gregg

RE: yummy cookie!

2001-05-08 Thread Philip Arnold - ASP
I use: cfcookie name=cookiename value=#value# expires=NEVER and the cookie is terminated/deleted whenever I close the browser. on the application.cfm there is: cfapplication name=appname clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes clientstorage=Cookie Any idea why

RE: OT: VSS versioning

2001-05-08 Thread Ken Johnson
If you are looking for a RDS/Server side version control, VSS is your only choice. I use a product call QVCS (http://www.qumasoft.com) which is a client side version control system. It integrates well with CF Studio and can produce reports by assigning Version Labels to specific revisions. It

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Dave Watts
I'm currently running a query that is 64KB of SQL text - and that wasn't a typing mistake! I wouldn't be surprised at all if the SQL string was treated as a variable in CF - with a limitation of 64Kb. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202)

RE: OT: VSS versioning

2001-05-08 Thread Andy Ewings
Hear hear!...another advocate for VSS!Do you know if it is possible to download a trial version? I have used it many times before but want to get a trial version to demo to bosses at work to try to persuade them to buy it. Can't find anywhere where I can do that.

Problems with forms in MSIE 5 Mac?

2001-05-08 Thread Paul Sinclair
I'm designing a data input system using CF. The data input person is running on a Mac using MSIE 5 (latest version of MSIE for Mac as far as I know). He keeps getting errors about form fields not being passed from one page to the next. That is, on 1.cfm he fills out a form and then hits the

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Ben Forta
Not really an urban legend, more like a restriction that was lifted post CF4 (but the CF Admin was not updated to reflect that g). --- Ben -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:13 AM To: CF-Talk Subject: RE: using WDDX for next

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread mjohnson
yes this is true. I have experienced it doing multiple inserts withing one CFQUERY statement. The worst part of it is that it doesn't return any errors it just chops off the end of the query. So in my case some records were missing from the db. My solution was to keep track of how much text was

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Andy Ewings
If I were you I'd put it in an SP. I know there used to be a limit to the length of an SP in 6.5 but as far as I'm aware this issue was addressed in 7 -- Andrew Ewings Project Manager Thoughtbubble Ltd

parsing text files - date problem

2001-05-08 Thread Kay Smoljak
Hi all, I am working on parsing text files to put email archives into a database. I thought I had it all working great, then it started choking on certain dates. The good dates are mostly in the format: Tue, 13 Feb 2001 23:17:08 - etc. But some have this: Mon, 12 Feb 2001 13:06:57 EST and

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Kola Oyedeji
Someone on another list proposed creating a unique id for each search query executed and then using this as a file name and writing the query as a WDDX packet to this file. Then on every page this id can be used to retreive the correct query object - and display it. Any one see any problemes

OT: ASP NumberFormat

2001-05-08 Thread Bernd VanSkiver
Sorry about bringing ASP in to the list but am having troubles finding the solution and was hoping someone here might know the answer. I am needing a way to format a number in ASP similar to the CF function NumberFormat() Is there a function or something in ASP for this? I'm not sure if ASP

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Paul Smith
My recollection it was post CF3. I believe CF4 allowed a user to specify more than 100. best, paul At 11:03 AM 5/8/01 -0400, you wrote: Not really an urban legend, more like a restriction that was lifted post CF4 (but the CF Admin was not updated to reflect that g). --- Ben -Original

OT: Who's a good merchant these days?

2001-05-08 Thread Erika L Walker
Hi all, I have to recomend a couple of good credit card processing companies to a new client. Other than iBill, CyberCash and Authorize.net, are there any others worth taking a look at, easy to integrate and have no problems? Look for fellow programmer references. Thank you.

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Dave Watts
Not really an urban legend, more like a restriction that was lifted post CF4 (but the CF Admin was not updated to reflect that g). Not exactly. The CF Admin doesn't say you can't have more than 100 cached queries, nor has it for some time. Other Allaire documentation and training materials,

RE: ASP NumberFormat

2001-05-08 Thread Andy Ewings
The VB function to convert to an Integer is CInt(string). Will obviously only work if the string can be converted to an int. However - If I remeber correctly (and it's been a while!) I thought that in ASP you can't delare datatypes for variables. i.e in VB you do: Private myvar as int in

CFFILE

2001-05-08 Thread Foggy, Doreen
Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag chh-test\www\lmts_int\cic is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element

RE: CFFILE

2001-05-08 Thread Adkins, Randy
use the complete path: D:\MyDir\Mysub\ -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:44 AM To: CF-Talk Subject: CFFILE Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the

Re: CFFILE

2001-05-08 Thread Howie Hamlin
If you are using UNC paths then you need to run CF under a user account with rights to the folder on the other server. By default, CF runs under the system account. You can change this in the NT Services applet. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc.

Re: OT: Re: GRRRR Claris Works 5.0 DB

2001-05-08 Thread Eric Dawson
You won't get any interface elements actually I am only interested in the data. Does Claris have any kind of export? unfortunately I haven't located a copy of ClarisWorks5DB or AppleWorks5DB yet (Not sure what the upgrade stream is on the ClarisWork4 on to ApplwWorks today), Plus I am guessing

RE: ASP NumberFormat

2001-05-08 Thread Dave Watts
Sorry about bringing ASP in to the list but am having troubles finding the solution and was hoping someone here might know the answer. I am needing a way to format a number in ASP similar to the CF function NumberFormat() Is there a function or something in ASP for this? I'm not sure if

RE: ASP NumberFormat

2001-05-08 Thread DeVoil, Nick
http://msdn.microsoft.com/scripting/default.htm?/scripting/vbscript/doc/vsfc tFormatNumber.htm ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it

RE: CFFILE

2001-05-08 Thread Foggy, Doreen
I used the complete path T:\lmts_int\cic and the same error was returned. -- Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag

OT: Automatic File synchronization between clustered servers.

2001-05-08 Thread Bill King
I have an issue with a client who has a shared server environment and due to the set up of the site and affiliate sites the client requires image files on both server boxes. The problem is that the images that are uploaded often don't copy to both places because of network contention etc. I

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Craig Bowes
Another idea for saving query times for N next records is to store the query as a session variable and you don't even have to run that query file at all. cfset session.savedquery = queryname then you can do your cfoutput query=session.savedquery maxrows=#nrows# be sure to put cflock around

RE: [Object Oriented CFML]

2001-05-08 Thread Craig Bowes
That's true, but my boss isn't just going to drop CF so I can do OO programming. Besides, there are certain development advantages to using CF, but it would still be nice to do OO programming. Plus, do JSP pages actually make objects that are callable as such or do they just make pages that

RE: CFFILE

2001-05-08 Thread Foggy, Doreen
I don't think it is a permission problem. I set the permission on the folder to everyone and still received the same error. It may be a network problem. When I upload the file to my hard drive destination path=c:\ It works. Any other path on my server returns the same error. Please advise...

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread mjohnson
Unfortunately it is often very difficult to build a very dynamic query using a SP. Imagine I want to build the entire syntax of a query via cf. Lets say I want to create 15 insert statements that all insert different values. I build a cfloop and start generating the SQL statement sticking it

Re: CFFILE

2001-05-08 Thread Mary_Baotic
CFFILE doesn't take unc paths from what I remember. You need to map a drive and give the user id running the cf application server rights to that share so it can see it. Then specify the file path as driveletter: \path Mary

store SQL time only

2001-05-08 Thread Michael Lugassy
I need to store in the SQL time only (as: 21:05:32) can someone please tell me the function for date/time display/formatting in SQL? I only know that this: (convert(char(10),getdate(),101)) will give me this: 30-01-2000 (display code 101), but what is the code for time only? help.

RE: CFFILE

2001-05-08 Thread Foggy, Doreen
Thanks...I was using the wrong pathI was using the drive that I set-up on my machine instead of using the drives on coldfusion server c and/or d... it works... :) Thank you -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:47 AM To:

Re: Automatic File synchronization between clustered servers.

2001-05-08 Thread Jon Hall
How are you handling synchronization now? Win2k FRS does this pretty well, and I haven't run into the problems you are seeing. If you are actually running into network contention on the link between the two servers. You may be able to put another NIC in each machine and specify the content

RE: CFFILE

2001-05-08 Thread Andrew Tyrone
Like Howie said before, the ColdFusion Application Server service must be logged on as a user with network rights, not the LocalSystem account. From your posts I surmise the drive you are trying to write to is a mapped network drive... Is that correct? If so, you will need to edit the CFAS

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread Kola Oyedeji
But wont that mean each query would be held in the server RAM? KOla -Original Message- From: Craig Bowes [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:15 To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing Another idea for saving query times for N next records is to

Re: CFFILE

2001-05-08 Thread David E. Crawford
Is this T: drive physically on your server, or is it on another server? If it is on another server, the CF Service must be run in the context of a user that would have access to that other server. Just because you can see the drive share doesn't mean CF can. DC - Original Message -

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Philip Arnold - ASP
If I were you I'd put it in an SP. I know there used to be a limit to the length of an SP in 6.5 but as far as I'm aware this issue was addressed in 7 My problem is that the majority of the data is the list of Identities used in the IN() I'm not sure how if a SP can handle this better than

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Philip Arnold - ASP
yes this is true. I have experienced it doing multiple inserts withing one CFQUERY statement. The worst part of it is that it doesn't return any errors it just chops off the end of the query. So in my case some records were missing from the db. My solution was to keep track of how much

RE: Daylight savings time on the server?

2001-05-08 Thread Kevin Miller
Were the classes that you are having a problem with created before daylight saving began, or is this a problem even with new events? Depending on how your specific DB stores dates, you may need to make an adjustment. Kevin [EMAIL PROTECTED] 05/08/01 04:35AM Kevin, Thank You. no i am not

Uploading a file

2001-05-08 Thread Nick Betts
Hi, I am trying to upload a file on a server using CFFILE. All is well in development, however on live server I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server

RE: CFFILE

2001-05-08 Thread Andrew Tyrone
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:30 PM To: CF-Talk Subject: Re: CFFILE CFFILE doesn't take unc paths from what I remember. You need to map a drive and give the user id running the cf application server

Maybe OT: Infinite categories/subcategories

2001-05-08 Thread Jeff Green
My goal is to make my app (store whatever) have the ability to have infinite categories/subcategories. I'm aware that there may not be a great need to go 10 subcategories deep, but if I make my app only go 2 deep and someone wants 3 deep well you get the idea :) I have done this

Re: CFFILE BTW

2001-05-08 Thread Michael Lugassy
by the way: what are the properites I can use for file (after cffile/upload) I know #file.serverfile# how can I get a list of them? the documentation says nothing. THANKS! - Original Message - From: Foggy, Doreen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08,

Re: store SQL time only

2001-05-08 Thread Mark Woods
108 06:32 PM 5/8/2001, you wrote: I need to store in the SQL time only (as: 21:05:32) can someone please tell me the function for date/time display/formatting in SQL? I only know that this: (convert(char(10),getdate(),101)) will give me this: 30-01-2000 (display code 101), but what is the code

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Bob Silverberg
Sure you can. If you want to create 15 different insert statements, that all insert different columns, then I'd agree that a SP would be pretty much useless. But if it's the same insert statement, with only the values being different you can definitely do it in an SP. I just finished an app

RE: CFFILE

2001-05-08 Thread Foggy, Doreen
Andrew and Howie, Yes, I was trying to write to a mapped network drive. Now I understand the error. I misunderstood Howie's first email. Thank you! -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:42 PM To: CF-Talk Subject: RE: CFFILE

Re: Next-Previous Record Display

2001-05-08 Thread Shally
Hi, Checkout the following if this helps.. http://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/CA3C99A0-EC34-11D3-85030050DABEAE1B/Tutorial_Page/1 Shally --- Steve Reich [EMAIL PROTECTED] wrote: Does anyone know of a good, robust tag to do the Previous 10 - Next 10 routine on

Re: using WDDX for next 'n' style browsing

2001-05-08 Thread Jason Lotz
Actually, if you want to do this, you can skip the cfset step. Just call the query as below: cfquery name=Session.MyQuery. - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 9:43 AM Subject: RE: using WDDX for next

Design Issue with update queries

2001-05-08 Thread Janine Jakim
I have a design dilemna Facts are this: 1. Each quarter grade information must be updated in each subject. Total subject + subcategories are gt 50 for each grade level. To display them in columns I am using: TD cfif Val(CourseGrade.GradeForSubject)#SubjectGrade# cfelseinput

RE: Automatic File synchronization between clustered servers.

2001-05-08 Thread Bill King
I need to do this on WinNT. Is this available, or has anyone seen another application that will do this. - BILL - -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:40 AM To: CF-Talk Subject: Re: Automatic File synchronization between clustered

RE: Problems with forms in MSIE 5 Mac?

2001-05-08 Thread JB
I've had that same problem. I can't recall what I did, but I do remember it was a minor change. I think I removed the enctype=multipart/form-data from the form tag and it fixed the problem. -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001

please help :: COM error 0x80040154. Class not registered

2001-05-08 Thread Paul Ihrig
how do i register a class on the web server? please give me a clue i am stumped. had great fun playing with a script to add stuff to my outlook calendar. uploaded it to the server it whimped out on me. guess i needed outlook on the server. so Dian told me i could possibly call on a class

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread mjohnson
What yo might want to do is a join instead of an IN(). I don't know what you are matching in your in statement, but here is an idea. Create a temporary table and insert all the values that would be in your IN() statement. Then do an inner join to the temporary table. Example: CREATE TABLE

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Bob Silverberg
Well, you could break the list up into smaller chunks and send each list to the SP as a parameter (using CFSTOREDPROC). In the SP, default each parameter to NULL, then dynamically build your SQL statement, and only include those parameters which are not null. Bob -Original Message-

Re: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread G
Our DBA (very smart guy) frowned on our use of the IN clauseperhaps you may consider taking a relational approach to this query. The entire thing could be done inside a stored procedure (eliminating your current problem) and without the use of the IN clause. - Original Message -

Re: Uploading a file

2001-05-08 Thread David E. Crawford
How large is the file? How much free diskspace and memory is available on the server? DC - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:40 Subject: Uploading a file Hi, I am trying to upload a file on a server

RE: Who's a good merchant these days?

2001-05-08 Thread Nathan Stanford
Hi Eric... I mean Erica opps that was Erik nope Erika whew... That was tough.. My first name gets Nathen or Mason My last name gets Standford or Stafford I tell them my last name is Stanford just like the College sometimes this helps. Erika :) Nathan Stanford Senior Programmer/Analyst

RE: ASP NumberFormat

2001-05-08 Thread Nathan Stanford
Your treading on THIN ICE mentioning that COMPETITOR... grin Nathan Stanford Senior Programmer/Analyst [EMAIL PROTECTED] -Original Message- From: Bernd VanSkiver [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:23 AM To: CF-Talk Subject: OT: ASP NumberFormat

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Bill King
It seems to me that there is a database setting (long text buffer size) that only allows 65,000 characters by default... In CF 4.5+ you can adjust this setting...do a character count of your insert in the database and I'll bet it is 65,000 characters. Let me know (if anyone knows) what this

RE: CFFILE BTW

2001-05-08 Thread Andrew Tyrone
Well, I don't know how you missed this huge html table in the studio docs ;) (from cf studio 4.5.2 docs): Note Although the File prefix is still supported, it has been deprecated in favor of the CFFILE prefix. The following file upload status parameters are

Verifiy a download?

2001-05-08 Thread Jeff Green
Hi all, My client plans on selling digital products, so after purchase I plan to offer a download, but I was hoping there would be a way to verifiy if the download was complete or not. Would I use cfcontent for this? TIA, Jeff ~~ Structure your

SQL 7.0 Single User Mode

2001-05-08 Thread Brook Davies
Does any one know why a SQL 7.0 database would continually go into single user mode? Brook Davies Maracasmedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: CFFILE BTW

2001-05-08 Thread Foggy, Doreen
I got the list form the ColdFusion 4.0 web application construction kit by: Ben Forta Chapter 28, Working with Files and Directories #File.ServerDirectory#\#FILE.ServerFile# #File.ContentType# #File.ContentSubType# #File.ClientDirectory# #File.ClientFile# #File.ClientFileName#

  1   2   >