RE: File Vs Database?????????

2000-10-31 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am making a small web application where in a candidate will be able to write his test on the web once he applies for a post.So i am making an on-line test paper. Since no huge data storage is required, so i want to develop this application

RE: File Vs Database?????????

2000-10-31 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Though I didn't originate this, thanks for the advice. I was going to pose the question today regarding using text in a database versus just having CF include a .htm file of the text by way of referencing the file name in the db. If I could

RE: Paranoid programming...

2000-11-02 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The database itself is sensitive enough that the owner does not want the userid and password put into the ColdFusion admin area either... I'm curious, why do you consider the ColdFusion admin area insecure? Is there a way the password can

RE: Paranoid programming...

2000-11-03 Thread Zachary Bedell
some level at which you trust your software hardware. If you can't trust your own code, It's not a matter of trusting code - it's a matter of not trusting hostile programmers... Then... I hate to say it, friend, but you really are screwed If there are individuals who meet the

RE: Potential problems with CF Express Server

2000-11-08 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes. This is exactly what I'm talking about. They want to be cheap and use CF Express, and I of course don't want that. I need to convince these folks that CF Express is NOT the way to go for hosting a large ecommerce site. What good

RE: launching executables on client machines

2000-11-09 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It's is possible to do this using Java or a ActiveX, but there are many security concerns. Justin MacCarthy Irish CF Head Is there an easy way to launch an executable on the client's computer? What I want to do is have the user

RE: CFID-CFTOKEN Confusion (newbie)

2000-11-09 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, it is entirely possible that two (or more) browsers could share the same CFID:CFTOKEN. It *shouldn't* happen, but flaws in the way CF handles these tokens allows it to happen under certain circumstances. CFID:CFTOKEN can be passed in

RE: CF Client Data Corruption Under Load?

2000-11-09 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Parts of this message quoted from my response to the CFID-CFTOKEN Confusion thread It's probably not client corruption you're looking at. It's probably more than one user sharing the CFTOKEN and CFID values. It's possible that two (or more)

RE: Best Practices

2000-11-10 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 CF_Rant_Rave_and_Vent... I might hazard a guess as to why the Java engine appears to be running faster than the C++ engine: the C++ engine has been a piece of junk since it was released. I've no doubt that Allaire could get a Java based engine to

RE: BULK INSERT Problem

2000-11-14 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The BULK INSERT is not carried out if I CFINCLUDE the following into a template: One idea occurs to me. Try making the CR/LF in ROWTERMINATOR explicit instead of relying on CF to stick one in there. Like so: !--- Read raw data from file

RE: BULK INSERT Problem

2000-11-14 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 "BULK INSERT"; Is that a SQL Server only thing? I could really use that... but I'm using Sybase on Linux which has a command line tool (BCP) but I never heard of a SQL statement to do bulk inserts. It's definately an MS-SQL extension. I dunno

RE: SQL Server Licesning

2000-11-17 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well... Looks like M$ has changed their licensing strategy again, but... Looking at the info from http://www.microsoft.com/sql/productinfo/pricing.htm, you're looking at $5000 per processor for unlimited user licenses. Not bad compared to

RE: SQL Server Licesning

2000-11-17 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It seems to me that, for CF users, SQL7 is a much better buy. In CF Administrator, you can limit the number of worker threads (simultaneous connections) to 5, for example. This means at most 5 CF users can use SQL7 at the same time. No

RE: SQL Server Licesning

2000-11-17 Thread Zachary Bedell
Native Medical Center -Original Message- From: Zachary Bedell [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 17, 2000 6:48 AM To: CF-Talk Subject:RE: SQL Server Licesning -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well... Looks like M$ has

RE: How to prevent BACK and FORWARD button from clicked?

2000-11-17 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have created a critical web based application which is not allowed the user to press BACK and FORWARD button in order to prevent data integrity. How do we disable the BACK button using CF, instead of using Javascript

RE: amusing studio error msg

2000-11-21 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sounds rather on par for CFStudio... As for the attachment, it's just as well you didn't send it -- CFTalk doesn't support attachments. All we'd see is a BIG mess of MIME garbage at the end of your post. Granted those of us so inclined could

MS SQL 7, CF4.5.x, nvarchar, and LOTS of PCode errors. SQL Guru's please help!

2000-11-21 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all! It's recently come to my attention that ColdFusion is not entirely happy about dealing with Unicode characters from MS SQL server. It seems as tho CF 4.0.1 can handle nvarchar's in CFQUERY's, but dies with Unicode in CFSTOREDPROC's.

RE: Printing mailing labels in a browser -- Joy... :-O

2000-11-27 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I managed something decent for an in-house only project. The labels were UPC stick-ons for inventory. Since the format of the label was fixed, all we needed to do was fill in the blanks with ColdFusion. I used MSWord to design the label, then

RE: SQL 7.0 Question

2000-11-30 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL

RE: IP Address blocking

2000-11-30 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You might be able to use the HTTP Referer of the request to determine whether to show the page or not. We use a similar thing to prevent direct linking to image content on our site -- we use CF to serve images via CFCONTENT. The page checks the

RE: Java and CF

2000-12-01 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Allaire has annonced that CF 6 will be entirely written in Java on the back end, with CF Tags actually being translated into JSP Code and then passed to a servlet engine, all on the back-end. My only question: What kind of crack is Allaire

RE: GetTicketCount() - where and when

2000-12-01 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 GetTickCount is just a number. It's fairly meaningless on its own. I think it's the number of milliseconds since the server was started or something... It becomes useful when you have two calls to it: cfset StartTime = GetTickCount() !---

RE: CF Does not like MSSQL7 @@ROWCOUNT

2000-12-01 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Except he's not looking for the identity, but the count. Setting nocount on kinda kills that... We ran into this once before and according to Allaire when CFQUERY evaluates a multi statement argument it waits for the SQL server to respond

RE: CF SP2 + Win2k/Memory Leaks

2000-12-04 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Could I just add one niggling little detail to this thread? I know it's a small thing, but... If ever someone's having a problem with Microsoft SQL Server 7.0 (and I presume 2000 is the same), asking if they're using ODBC or OLE/DB is rather moot.

RE: CF Does not like MSSQL7 @@ROWCOUNT

2000-12-04 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 03, 2000 1:08 AM To: CF-Talk Subject: Re: CF Does not like MSSQL7 @@ROWCOUNT Except he's not looking for the identity, but the count.

RE: normalization problem?

2000-12-04 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It returns an "out of memory/resource" error; "Error Diagnostic Information Error occurred for unknown cause." First of all... That error is most likely a sign of larger problems. Perhaps problems w/ memory leaks other such garbage similar to

RE: Assembler.....

2000-12-05 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lately I wuz thinking of picking up an extra language to add to my long list of the ones I currently know ;) As most people know you can develop custom COM, CORBA, CFX other types of add-ons using alot of different languages like C++, VB,

RE: CF4.5.1 SP2.

2000-12-14 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am still experiencing huge memory leaks but I notice it is from Inetinfo.exe and NOT CF. There is no doubt in my mind the CF is the culprit, but how in the world does Allaire put out this lousy of a product update? This is reminiscent of

RE: cfcrypt

2000-12-14 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Download the demo of 4.0.1 server from Allaire. In any case, there's no difference between the two programs. They both produce the exact same (easily decrypted) output. Best regards, Zac Bedell Zachary

RE: Purging CDATA and CGLOBAL

2000-12-18 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As another poster mentioned, CFEXEC is the magic behind CDATA purging. Additionally, I wouldn't recommend anyone running the query listed below to manually change or delete the client data stores. We tried doing that for a while in a scheme to

RE: creating an url return string

2000-12-18 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In the calling page, before you redirect to the authentication pages, setup returnURL like so: cfset returnURL = Cgi.Script_Name "?" Cgi.Query_String Now returnURL will contain anything that was passed after the question mark. Hope that helps,

RE: [Compress HTML output]

2000-12-18 Thread Zachary Bedell
Make sure the contents of the variable are all valid in a filename. CopyLeft 2000 Zachary Bedell [EMAIL PROTECTED] You may use this code as you wish provided I retain credit in the comments or elsewhere. No Warrenty

ThisTag.GeneratedContent

2000-12-19 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This seems like a really dumb question, but I can't seem to find a definitive answer anywhere... Is there an equivalent to a custom tag's "ThisTag.GeneratedContent" variable for the base executing page? I know CF buffers all HTML output until the

RE: [Compress HTML output]

2000-12-20 Thread Zachary Bedell
quot;WRITE" file="#RawHTMLFile#" output="#Content#" !--- Compress the tempfile to another tempfile --- cfx_GZip action="GZIP" InFile="#RawHTMLFile#" OutFile="#GZippedFile#" level="#Attributes.Level#" cffile action="delete&q

RE: The +.htr bug strikes again

2000-12-21 Thread Zachary Bedell
Someone should probably make an official "checklist" to run through when you setup a CF server. How about these additions to said checklist: In addition to removing the .htr mapping, also remove the mappings for any other extensions that you won't be using on that server. Like: htw --

RE: Alternatives to Coding Username and Password in Application.c fm

2000-12-21 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Here's a trick that "should" make you more or less immune to .htr, ::$DATA or other similar source exploits. Since all of these bugs allow you to access the unprocessed contents of script files within your webroot, the secret is to store your

RE: ThisTag.GeneratedContent

2000-12-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there an equivalent to a custom tag's "ThisTag.GeneratedContent" variable for the base executing page? To the best of my knowledge, there is no way to retrieve this generated content from within the scope of the request itself. Answer

RE: [Compress HTML output]

2000-12-22 Thread Zachary Bedell
ill be created here for each request. This directory must exist or the tag will error. CopyLeft 2000 Zachary Bedell [EMAIL PROTECTED] Special thanks to: Orlando Correa [EMAIL PROTECTED] for suggesting the Directory attrib

RE: [Compress HTML output]

2000-12-24 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Not sure if this has been talked about in detail but with the interest in dynamic html compression I will throw my two cents in. And donations of this sort are *always* appreciated! Thanks! ;-) Why use a cfx tag with coldfusion to compress

RE: [Compress HTML output]

2000-12-24 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Could you please explain how this compression works. I keep seeing this as it is being compressed and decompressed at the server, or is it being compressed at the server and decompressed at the client. After CF is done creating all of the

RE: [Compress HTML output]

2000-12-24 Thread Zachary Bedell
Ok I understand what has been done the only thing I see as a problem is that the tag is writing a file. Now without locking or without a unique name something bad is bound to happen. And once you put locking on the writing of files there is gonna be a slowdown. The filename for the

RE: [Compress HTML output]

2000-12-24 Thread Zachary Bedell
The overhead is most likely on the cache file writes and cache reads. You just gave me an idea for a work around that could be better and faster than all the options we have just discussed. With both ISAPI and CFX, the system has to compress each and every single page output as it is a

CFLOCATION, CF401, Weird...

2000-12-26 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm having some weirdness with CFLOCATION on CF 4.0.1. I can't see any way that this isn't a bug / limitation in something, but I was wondering if others might have the clue that I lack. If I do this, the page request hangs indefinitely: !--- Lots

RE: Script Kiddies

2000-12-26 Thread Zachary Bedell
the vulnerability to do harm or publicizing it for others to use. We could use a whole lot more of the second kind... Best regards, Zachary Bedell CTO, Adirondack Technologies, Inc. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com Comment: Please use PGP

RE: CFLOCATION, CF401, Weird...

2000-12-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You've probably figured this out already, but the cause of this could be a CFHTMLHEAD tag with content greater than 1024 characters, positioned above a CFLOCATION tag. This is a bad combination ... cflocation writes to the http headers, and

RE: CFX CyberCash Question....

2001-01-05 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As someone else mentioned, you need to take the a href=" stuff out of the CCPS_HOST line. Tho I suspect that might have been your mail software doing you a favor by turning that into a link as opposed to you actually doing that yourself... The

RE: CFHEADER

2001-01-08 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Just a guess... Try replacing attachment with inline in the CFHEADER value. That might convince the browser to display the PDF instead of saving it, but it would still allow the proper filename to come through if the user did decide to save it by

RE: Is networksolutions behind with zone changes?

2001-01-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We've been trying to get some domain record changes completed through networksolutions and they haven't taken effect over the last couple days. We've sent the request form a couple times. Last batch of changes we made several weeks ago went

RE: CFContent question....

2001-01-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 CFContent works fine in sp6a. You can't do the URL faking thing anymore, but that was a bug that was fixed never should have worked in the first place. SP6 broke both CFContent and the URL thing. SP6a fixed CFContent, but not the URL thing.

RE: image root resolving

2001-01-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Assuming your webroot is pointing at c:\inetpub\wwwroot\ (IE http://www.yoursite.com/index.cfm is really c:\inetpub\wwwroot\index.cfm), then you don't need to do anything to do what you want. /images will be /images no matter what. Now... images

RE: HTTPS setup

2001-01-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We do have other sites on the same IP, but none of them use SSL. That shouldn't matter, should it? The default site if you go in by IP is a different site, but that's only for port 80, so I guess its irrelevant. Is it possible for you to

RE: CFerror and its

2001-01-12 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Check out the docs for CFError. CF code doesn't execute in the page specified for a CFError tag. It's assumed that if you're already in an error situation, running more code might not be the best idea. I dunno how valid that is, but that's what

RE: Netscape 4.04

2001-01-16 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sorry to extend a finished thread, but Does anyone else see the irony of version "four-oh-four" of a browser having unusual bugs? Maybe they should have skipped to 4.05. Kinda like they skip the 13th floor in hotels Again, apologies for

RE: CFLOCK for 4.0.1 AND 4.5.1

2001-01-23 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The scope="" is optional as you can use the same locking syntax as in 4.0, ie. named locks (scope and name are mutually exclusive though, so don't try both). I don't think Allaire would cut their own throats by being that backwards

RE: CFLOCK for 4.0.1 AND 4.5.1

2001-01-23 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't think Allaire would cut their own throats by being that backwards incompatible; Actually... There is deep red arterial blood pouring from the Allaire's severed jugular They did indeed do something stupid by making 4.5

RE: CyberCash built-in at CF 4.5

2001-01-26 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 No such luck. 4.5 doesn't have any built in CyberCash functionality. You still have to use the CFX_CyberCash tag (which does a fine job). It's on Allaire's tag gallery if you don't already have it. Best regards, Zac Bedell -Original

RE: custom CFERROR pages, what's your solution?

2001-01-26 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Under CF 4.5.x, you can set the CFERROR type to Exception and then execute CF Code in your error pages. Under 4.0, you're SOL... I used to make the CFERROR page a page that did an HTTP meta refresh to another CF page passing all the error

RE: SQL Server Licensing Woes

2001-01-30 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The last time I read the full SQL 7 license agreement, I found a little loophole. They fixed it in the SQL 2000 agreement, but if you're only using 7, maybe this could help you. CF_DisclaimerI am *not* a lawyer. I am a coder. That said, my grasp

RE: Windows 2000 Professional and CF Server 4.0.1

2001-01-31 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 4.0.1 works great provided it was there before Win2k. If you do NT4, CF, then upgrade to Win2k, you should be okay. Basically 4.0.1 works fine under 2k, but the installer is brain dead. Rather than patch the installer, Allaire would rather you run

RE: W2K vs. NT

2001-02-07 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of

RE: Upload module

2001-02-15 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 How about this: Wrap the CFFILE call in a CFTRY block. Catch the error deal with it if necessary, otherwise the code will just work as it should. Best regards, Zac Bedell -Original Message- From: MJS @ Four Eyes [mailto:[EMAIL

RE: Win2K and SQL Server 7.0 quest

2001-02-16 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 12:16 PM To: CF-Talk Subject: RE: Win2K and SQL Server 7.0 quest what are SP's for, and are they free? SP == Service Pack. I.E. a whole

RE: CF Source Code?

2001-02-16 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Okay... This thread is kinda going south anyways, so perhaps I can add my two cents without anyone thinking I'm outta line... Has anyone ever thought of creating a Windows Scripting Engine that could handle CF code? Basically, that would allow you

RE: How to choose Name or Scope when locking

2001-02-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I haven't seen anything yet that talks explicitly about when to use the Name attribute and when to use the Scope attribute. There have been a number of threads around whether to single thread updates to a single table. For example, lets

RE: Cheaper Alternative to SQL Server 2000

2001-02-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well, there's always MySQL, but I bet there's a chorus of folks here who'll say it ain't ready for primetime, which is why I'm posting... could anyone expound on this? Especially using mySQL with CF. Ok... I'll bite... Probably the biggest

RE: How to choose Name or Scope when locking

2001-02-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I haven't seen anything yet that talks explicitly about when to use the Name attribute and when to use the Scope attribute. There have been a number of threads around whether to single thread updates to a single table. For example,

RE: How to choose Name or Scope when locking

2001-02-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Zac, Thanks. This was very helpful. One clarification question. Does a Named lock prevent a same-named thread within the session or application(on a single server?)? Well... I'm not quite sure what you're asking. The three scoped

RE: Cheaper Alternative to SQL Server 2000

2001-02-23 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 system). Another option is to join the MS Developer Network and get a universal subscription for about $600 (plus tax/shipping). With that, you get all the commerce server, visual studio, office and a whole bunch of other software, including

RE: Cheaper Alternative to SQL Server 2000

2001-02-23 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Does anyone have the link to Subscription page for MS Developer Network? I have looked through the site and can't find it. http://msdn.microsoft.com/subscriptions/prodinfo/overview.asp That's the info page about the different levels. There's a

RE: whitespace in cfloop

2000-05-25 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm running a loop over a query cfloop query= I don't have anything to output in the loop and I can't get the whitespace out of the final output. I have enlosed the entire page in cfenablecfoutputonly but it seems like cold fusion

RE: returning autoID after insert [sql] [tip]

2000-05-25 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If you're using MSSQL, here's a non-StoredProc way to accomplish this. This is nicer in a case where a stored proc doesn't really make sense for a quick little query: CFQUERY name="Whatever" datasource="#Application.DSN#" SET NOCOUNT ON

RE: Help!

2000-06-20 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You should be able to do the following: cfquery name="GetMasterID" datasource="master_data" DELETE FROM MasterTable WHERE SignUpDate = #SignUpDate# /cfquery Or cfquery name="GetMasterID" datasource="master_data" DELETE FROM MasterTable

RE: Streaming audio

2000-06-21 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone here ever made a CF site that involves on-demand streaming audio? If so, what streaming server did you use? Does CF have any effect on server choices, etc.? We're using Windows Media Services w/ CF. We chose WMS over

RE: OT: IIS sharing on IP address

2000-06-21 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What I'm asking is say I make it up the ip address is 192.168.0.2 the port is 80 and the header is www.here.com, what do I call the folder to keep the website in. Do I call it what I called my header, and do I make 2 headers, one for

RE: OT: IIS sharing on IP address

2000-06-21 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nope. Only with HTTP. Best regards, Zac Bedell So .. will all of this work with FTP as well? .Todd | when you create the website in IIS you will define the root directory of | that site. So if you have the header, port and IP setup for

RE: List of tables in Access 97

2000-06-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: SELECT Name FROM MSysObjects WHERE Type = 1 That'll get you all tables. If you want to exclude all of the system tables, one of the following added to the WHERE clause should do it. AND Name Not Like 'MSys%' - -- OR -- AND Flags = 0 I'm

RE: Tracking users through a site

2000-06-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What would be the best way to track user movements throughout a site (i.e. what pages they have requested, what keywords they have searched on, their IP, etc.)? The users are already required to login with a userID and password. I need to be

RE: Error message

2000-06-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Generally it means all heck has broken lose in CFAS, and it's time to restart the service. You shouldn't get that error unless there's some degree of corruption in the CFAS process' memory space. Possible causes include failure to properly lock

RE: List of tables in Access 97

2000-06-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: SELECT Name FROM MSysObjects WHERE Type = 1 That'll get you all tables. If you want to exclude all of the system tables, one of the following added to the WHERE clause should do it. AND Name Not Like 'MSys%' -- OR -- AND Flags =

RE: Tracking users through a site

2000-06-22 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yes, to a degree the logging tools would be useful, but this particular set of information would be used as an audit trail... so it would have to be permanently stored in a database, and searchable as well. You *could* periodically analyze

RE: Tracking users through a site

2000-06-22 Thread Zachary Bedell
Another possibility, if cookies are an option, would be to continuely pass a "Click Stream" cookie back forth to the user. At each page request, just take the current cookie that they've sent back to you, append the current page w/ keywords to the end, and send it back to the user. Alot of

RE: labels and bar codes

2000-06-22 Thread Zachary Bedell
I have a possible project coming up that may require label and bar code printing via browser anyone doing this or have ideas on this. I think someone may have already mentioned this. Sorry if it's a repeat... There's an excellent barcoding tag in Allaire's Tag Gallery. I've been

RE: Tracking users through a site

2000-06-23 Thread Zachary Bedell
:~~ : From: Zachary Bedell [EMAIL PROTECTED] : Another possibility, if cookies are an option, would be to : continuely pass a "Click Stream" cookie back forth to the : user. At each page request, just take the curr

RE: Logical Limit of NT User Accounts

2000-06-23 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Under NT 4, it was 20,000 accounts per domain. Under Win2k, there's no pratical limit. Regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original

RE: PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

2000-06-26 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Any ideas what might be causing this error? It's intermittent and has been raised by multiple templates in my application that have SQL select clauses. Lemme guess You're using 4.5.1,

RE: NULL using it in CF

2000-06-27 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Use CFIF #myvariable# IS ""do something/CFIF Erf... Don't do THAT... This is 2-3 times faster: cfif Not Len(myvariable) It's empty cfelse It's NOT empty /cfif Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version:

RE: Help - where in the encryption function for Custom Tags?

2000-06-27 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 For reference, CFCrypt.exe was renamed to CFEncode.exe. Still in c:\cfusion\bin\. It uses the exact same "encryption," so I have no idea why they changed the name. Best regards, Zac Bedell - -Original Message- From: Mark Warrick

RE: um, looking for an ad...

2000-06-27 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Available until June 30, 2000... Purchase 2 copies of ColdFusion Server 4.5 Enterprise and 2 Two-year Subscriptions and receive at no extra charge - 3 copies of ColdFusion Studio and 3 Two-year ColdFusion Studio Subscriptions! Contact: Sandy

RE: CF_UPSPrice

2000-06-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is anyone using Ben Forta's CF_UPSPrice tag? its doesnt seem to be working, I dont think its getting a response from the ups site. If you're using 4.5, the tag may have been broken by the changes Allaire made to CFHTTP. We're using the OTHER

RE: NULL using it in CF

2000-06-28 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 But don't use: cfif #myvariable# IS "" Can you tell us why we shouldn't use this? There's a couple of things wrong with that. First, you don't need the #'s around myvariable. It'll work with them there, but I believe the CFML parser prefers

RE: Location of a Client

2000-06-30 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am developing an application that will be accessable in multiple languages. I would like the application to be able to identify the location of the client and present them with the page in the proper language. *snip* Does anyone know

RE: UPS CHECK DIGIT

2000-07-02 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This is what I came up with. Anyone have anything any faster? I'm not sure if this is any faster, but I think it's a little easier to grok. It's not in tag form, but should be easy enough to tagify... Hope this helps. Best regards, Zachary

RE: UPS CHECK DIGIT

2000-07-02 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Just a comment, that's the kind of thing I would have written that as a cfscipt block. It would be a little faster and less bulky looking ~Justin MacCarthy Very true! That was a quick dirty hack that I haven't got around to

RE: Compiling CFX Tags

2000-07-06 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have gnu 2.9 installed - I'll see if I can get that to work. Just out of curiousity, why are you using the Sun compiler at all? My boss' fiance worked for Sun, and she got us a couple of old Sparcs to play with. I asked her if she could get

RE: UPS Online Tools

2000-07-06 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 So if I understand this correctly, Ben Forta's tag (CF_UPSPrice) is offically dead as of Sept. 30 (pending a rewrite), but Ken McCafferty's tag (CF_UPSShipRate) should still be alive well. Can anyone else confirm or deny that understanding?

RE: CFSCRIPT Question

2000-07-10 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You can't use any kind of tag in cfscript. 4.5 finally has support for creating objects in script instead of with CFObject, but that's about the best you can do so far. I do hope Allaire makes the rest of CF's functionality accessible from script

RE: cf_mail problem...

2000-07-10 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try escaping the double quotes for CF like so: it goes something like this: cfoutput query... ... subject="#Replace(subject_here,,"","all")#" /cfoutput Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3

RE: stop reload data

2000-07-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I mean, after you insert the record, do cflocation .. to, say, the same page. This will help for sure. You may do silent http redirect. I have an insert form, which updates the data, however if I reload the action page, it inserts

RE: cfset vs setVariables

2000-07-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Can someone please explian when it would be more advantageous to use setVariables instead of cfset? In general, for static variable names, you should use cfset, or better yet an assignment statement in a cfscript block. Your best use for

RE: Chinese language

2000-07-11 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Because CF can't do unicode, you can't use nvarchar, ntext or nchar, you must use varchar, char and text. U I don't think so. Our entire site is built on nvarchar fields w/ SQL 7 CF4.01. No problems of any kind. Non-US form data

  1   2   3   >