RE: Future of Coldfusion

2002-06-14 Thread Tony_Petruzzi
personally I think CF is the bomb. I have tried other languages and they don't stand up to the ease of CF. I have yet to make the jump to CFMX because of the bugs that are still being ironed out even today. Once MM gets the bugs ironed out and changes a couple of things, I think I'll make the

RE: CFFILE

2002-06-14 Thread Tony_Petruzzi
this is true. it is limited to the server memmory. that is why if you are trying to append a file with some more data, you use the cffile action=APPEND. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bruce, Rodney S

fusebox 3.0

2002-06-14 Thread Tony_Petruzzi
alright, i will admit that i used to be a big fusebox fan. however after seeing that it took 400 milsecs to load a login page, i decided to drop it. and yes i did follow the methodology exactly. now i used the simple form / action methodology with a bunch of custom tags for reusability. what i'm

RE: CFFILE

2002-06-14 Thread Tony_Petruzzi
ok then. look like you're going to be using COM. ;) better reads up on FSO. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:49 PM To: CF-Talk Subject: RE:

RE: Coldfusion Apps You've Built

2002-06-14 Thread Tony_Petruzzi
i got to stop doing that. every time i write an app, i always look back on it them when i'm between projects and try to tweak them here and there. call it obsession if you want. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From:

RE: cfflush

2002-06-13 Thread Tony_Petruzzi
use a div and some javascript Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:39 AM To: CF-Talk Subject: cfflush The cfflush just works great for what I need

RE: Shopping Carts

2002-06-12 Thread Tony_Petruzzi
go to webmonkey.com and look in the coldfusion section. there is a tutorial on writing a shopping cart in coldfusion. I would suggest downloading the source code and poking through it. It is a great way to start writing your own shopping cart application. I would bet that after you've written

RE: Hack Attempt?????

2002-06-12 Thread Tony_Petruzzi
sure answer, yea it was an attempted hack. I see those alot on my server. personally you should never install the cfdocs on a production machine. just like you shouldn't install the IIS web admin on a production machine. another good thing to do, if you're running an ftp service, make sure that

RE: How do Client Var Behave

2002-06-11 Thread Tony_Petruzzi
word to the wise. just be careful about what you put into the server scope if you are on a shared server. do not put any sensitive information in any of the variables as they can be read by any application on the server. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED]

sql server text datatype

2002-06-10 Thread Tony_Petruzzi
anyone know how to pass in a text data type into sql server using cfstoredproc and cfprocparam? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Signup for the Fusion Authority news alert and

RE: Hacking a shared SQL server

2002-06-07 Thread Tony_Petruzzi
I personally always use uniqueidentifiers for primary keys, it's just a perference of mine. are they harder to work with? in my opinion, no, they are just as easy to work with as integers. do they add some extra overhead and extra access time to the application? if they do, i have never seen it

RE: Rumor of lay-offs

2002-06-06 Thread Tony_Petruzzi
whoa. calm down there andrew. you might pop something. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: Re: Rumor of lay-offs

RE: Hacking a shared SQL server

2002-06-06 Thread Tony_Petruzzi
that's because you didn't secure your database like your suppose to. I'm actually doing a presentation tonight for our CFUG about securing your SQL database. In a nut shell what you should do is create a user for the database (let's say the DB name is TEST) and give them DENYDATAREADER and

RE: Hacking a shared SQL server

2002-06-06 Thread Tony_Petruzzi
you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack

RE: Hacking a shared SQL server

2002-06-06 Thread Tony_Petruzzi
well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT

RE: Hacking a shared SQL server

2002-06-06 Thread Tony_Petruzzi
elaborate Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:47 PM To: CF-Talk Subject: RE: Hacking a shared SQL server If I only have access to run your

RE: Hacking a shared SQL server

2002-06-06 Thread Tony_Petruzzi
granted that that is true. however doesn't CF or any other programming language do the same thing. and if the way your getting at the data is by using form and url parameter, then it's very easy for me to do from the website and not even bother to try hack the database. using client variables and

RE: Hacking a shared SQL server

2002-06-06 Thread Tony_Petruzzi
damn good example david, damn good. I stand corrected. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:13 PM To: CF-Talk Subject: RE: Hacking a shared SQL

RE: msSQL/t-SQL BOTTOM

2002-06-06 Thread Tony_Petruzzi
select top 100 from tablename order by pk DESC the ORDER BY whatever DESC is the key Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:46 PM To: CF-Talk

RE: simple right-justify dollar fields in tables?

2002-06-05 Thread Tony_Petruzzi
check your code. the only thing that could do this is another piece of code, like a p, that is set to align left in the td tag. td align=right p align=lefttext will go left/p /td td align=right text will go right /td td align=right div align=lefttext will go left/div

RE: storing session variables in DB

2002-06-04 Thread Tony_Petruzzi
dude all you have to do is make sure that each app has it's own application name in the cfapplication tag. name of app1 cfapplication name=test name of app2 cfapplication name=test2 now the user's can't share session variables. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED]

RE: storing session variables in DB

2002-06-04 Thread Tony_Petruzzi
i think i read this wrong. you WANT people to be able to jump from one server to the other during a session. Well then, client variables to the rescue. you could probably mimic with session variables: in your database create a table that has these columns CDATA -- cfidchar(100) app

RE: storing session variables in DB

2002-06-04 Thread Tony_Petruzzi
see I found a mistake already :P. cfset request.thissession = #session.cfid#:#session.cftoken# should be cfset request.thissession = #cfid#:#cftoken# this way it would grab it if you passed the cfid and cftoken in the url or in seperate cookies called cfid and cftoken (which is what I would

RE: unscoped variables

2002-06-04 Thread Tony_Petruzzi
all unscoped variables are part of the variables scoped. cfset temp = testing cfoutput#temp#/cfoutput is also cfoutput#variables.temp#/cfoutput this happens no matter what page it is set on, includeing the application.cfm. if you want a variables to be in the appliction scope, you have to

RE: Client Variable DB storage

2002-06-04 Thread Tony_Petruzzi
we have a separate database for storing client variables. Strangely enough called cfclient :P. We do it because it becomes a hassle creating a client variables storage for every app. There is not good or bad reasons to have one for every database, just preference. Anthony Petruzzi Webmaster

RE: unscoped variables

2002-06-04 Thread Tony_Petruzzi
to an individual page. These variables (set unscoped in application.cfm) are used throughout the entire application. That's why I asked. Tony_Petruzzi@s heriff.org To: CF-Talk [EMAIL PROTECTED] cc

RE: Re[2]: Is this possible to do?

2002-06-04 Thread Tony_Petruzzi
just to throw a tidbit out there. Remember that if you use MSSQL server you cannot use IN inside a stored procedure that you are passign the list in. such that Store Procedure === CREATE PROCEDURE ProcessList @myList varchar(255) As SELECT * FROM MyTable WHERE myColumn

RE: Client variable storage question

2002-06-04 Thread Tony_Petruzzi
did you forgot to go into the cf admin on your laptop and setup the database as a client variable storage? :) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Richard Tugwell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04,

RE: Re[2]: Is this possible to do?

2002-06-04 Thread Tony_Petruzzi
well sortof. when you pass in the value to the storedprocedure, MSSQL looks at the string as a whole. to demostrate mylist = me, myself, and I to MSSQL, the string looks like: 'me, myself, and I' even if you enclose each element in ' . mylist = 'me', 'myself', 'and I' MSSQL looks at it

RE: Querying a table for its columns

2002-06-04 Thread Tony_Petruzzi
oh yeah. god forbid the table has 10,000 and more records in it. The query would take a while. Goto groups.google.com and do a search there. I have seen this posted for Access, mssql, and mysql before. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org

RE: Rumor of lay-offs

2002-06-03 Thread Tony_Petruzzi
i have been visiting FC for well over two years now. I must say that they are right on the money about their stories. I have no idea where Pud gets his info, but it's right on target. I personally think you could sell stock based off the information on his site. Just because the news is bad news,

RE: datetime formatting

2002-06-03 Thread Tony_Petruzzi
forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]]

RE: datetime formatting

2002-06-03 Thread Tony_Petruzzi
might be inserting the value yourself from a storedprocedure then. The default will only be used when the user hasn't specified a value. example: you are insert the datetime yourself DECLARE @mytime datetime, @title varchar(50) SET @mytime = getdate() SET @title = 'this is a

RE: Members Only section

2002-06-03 Thread Tony_Petruzzi
use client variables. cfif NOT Isdefined(client.deptid) OR NOT Isdefined(client.admin) cflocation url=../index.cfm addtoken=No /cfif cfif DateDiff( n, client.LastVisit, now() ) GTE 20 cflocation url=../index.cfm addtoken=No /cfif Anthony Petruzzi Webmaster 954-321-4703 [EMAIL

RE: Webtrends alternative

2002-06-03 Thread Tony_Petruzzi
http://www.123loganalyzer.com/ this thing is FAST and cheap too. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 4:36 PM To: CF-Talk Subject:

RE: IE 6.0 Bug??

2002-05-31 Thread Tony_Petruzzi
remove the # background-color: 66 Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 5:31 AM To: CF-Talk Subject: RE: IE 6.0 Bug?? I'll have some of that too

RE: File selection...is this possible?

2002-05-31 Thread Tony_Petruzzi
you could just put the files names into the select box and use the multiple parameter select name=selectfiles size=5 multiple option value=file1The file name/option option value=file2The file name/option option value=file3The file name/option option value=file4The

RE: Bulk email servers...

2002-05-31 Thread Tony_Petruzzi
someone once wrote a way here how send emails directly to MS SMTP service using cffile instead of cfmail. using this method you could easily send out a million plus emails a day. best of all ms smtp service is free with windows. Personally I would take the technique that he uses and write a vb

RE: CFTRY/CFCATCH Database errors

2002-05-30 Thread Tony_Petruzzi
uhhh, why not just do a cflocation to the temppage.cfm? Or rethrow the error on an Any and use cferror to catch the error information and email to you and then cflocation them to the temppage.cfm? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original

RE: MX training courses now available

2002-05-30 Thread Tony_Petruzzi
I second that. Adam and David are the authority (respect it!) when it comes to CF training. If you get the chance to go, GO (plus the food is good). Also if they are offering their database class anytime soon, I would mortgage your house or sell off your first born to attend that class. I went to

RE: CF MX in production?

2002-05-30 Thread Tony_Petruzzi
before you do that, I would hope that you have put a copy of your website(s) on a test server with CFMX and ran some test. Remember that there are some depreciated tags, cfhttp screwup (mentioned earlier on the list), and other concerns that you might want take a look at. I would't just jump and

RE: cffile parsing problem

2002-05-30 Thread Tony_Petruzzi
cffile action=READ file=C:\Inetpub\wwwroot\test\test.txt variable=stuff cfloop index=i list=#stuff# delimiters=#chr(10)##chr(13)# cfset variables.part = trim(i) cfset variables.partlen = len(variables.part) cfset variables.newpart = left(variables.part, variables.partlen

RE: Quick question on custom tags

2002-05-30 Thread Tony_Petruzzi
cfmodule template= Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Brian Eckerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:05 AM To: CF-Talk Subject: Quick question on custom tags Is it possible to call a

RE: Adult hosting

2002-05-30 Thread Tony_Petruzzi
check out http://webhost.thelist.com/business/ check adult content allowed. or goto http://www.overture.com do some search for adult web hosting and the like Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP

RE: SQL server trouble

2002-05-30 Thread Tony_Petruzzi
that's the first place to go whenever you have problem with a Microsoft product. Second is google groups. this list should be a last ditch effort. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Mario Martinez [mailto:[EMAIL

RE: SQL server trouble

2002-05-30 Thread Tony_Petruzzi
just out curiosity. I wonder, if the next time this happens, if you viewed the services file, (c:\winnt\system32\drivers\etc\services) if it would tell you what is hooked on that port. if it does, then you know what app is the culprit. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED]

RE: Re[4]: Preventing user from going back

2002-05-30 Thread Tony_Petruzzi
why don't you tell us why you don't want people to be able to GO BACK. Depending on the situation you're facing, you might be beating your head against the wall for nothing. The only reason I can think of why you wouldn't want someone to be able to go back, is because of form submission, and

RE: CFDIRECTORY

2002-05-30 Thread Tony_Petruzzi
http://www.xcreation.com/apps.cfm download the one called directory listing tag. Just drop it into the directory you want listed. Has built in security. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Critz [mailto:[EMAIL

RE: Re[2]: Preventing user from going back

2002-05-30 Thread Tony_Petruzzi
and then all someone has to do is use a program to spoof the referrer information and their in. The only thing that you as a web programmer can do without beating your head against the wall is to make sure you qualify all variables passed to the page, check them to make sure they are of the

RE: Image Servers

2002-05-29 Thread Tony_Petruzzi
how about something free like JGenerator http://www.flashgap.com/ the site even has a comparision between it and Macromedia Generator. Best of all, it's FREE! Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP

RE: Search Engines

2002-05-24 Thread Tony_Petruzzi
check out http://www.rolist.com rotating search engine. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:05 PM To: CF-Talk Subject: OT: Search Engines Does

Emergency: Authorize. net woos

2002-05-24 Thread Tony_Petruzzi
Alright is there anyone out there that has successfully implemented the new Authorize. net referer security reqquirement? I have been trying for two days to do this with no aval. Dave watts posted something here a couple of days ago saying that you can pass a httpparam with the type of cgi, the

RE: page security using cfabort

2002-05-23 Thread Tony_Petruzzi
the really bad thing about using cfabort is that EVERYTHING after it stops processing. So if you code like I do where I put my footer in the onrequestend.cfm file, well gues what, your footer doesn't process. Personally I just set a variable called variables.ErrorCode equal to 0. Then during

RE: OT: Making normalized tables from a single flat file.

2002-05-23 Thread Tony_Petruzzi
you know, you might not have to do that much work after all. you could use MS Access to import the information into an access database. after that, you can cut and paste the information into different tables and create relationships. if you really want to get jiggy with it, you can then use the

RE: Don't leave stuff lying around

2002-05-22 Thread Tony_Petruzzi
Personally I think this comes from not doing error checks in your code more than leaving stuff lying around. Don't get me wrong, I think that at least once month you should go through your production site and see if everything is in order. Actually you should do that with each update. However,

RE: Don't leave stuff lying around

2002-05-22 Thread Tony_Petruzzi
don't get what you mean. Tried some tests over here and all spaces were caught. please give an example. cfparam name=variable type=numeric will this automatically set the default value to 0 even though you aren't specifying it? should it be cfparam name=variable type=numeric default=0? Anthony

RE: Search engine safe

2002-05-22 Thread Tony_Petruzzi
how do accomplish something like this? Never did this before. Would be a good thing know. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 12:24 PM To:

cfmail error question

2002-05-20 Thread Tony_Petruzzi
have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail

RE: cfmail error question

2002-05-20 Thread Tony_Petruzzi
forgot to mention this, but the first thing I did was go through my cf-talk archives and try the code that writes directly to the pickup directory. get the same results, immediatly I get badmail errors. I guess what I'm basically looking for is not a cf solution but a windows error solution.

FW: cfmail error question

2002-05-20 Thread Tony_Petruzzi
From: Petruzzi, Tony Sent: Sunday, May 19, 2002 6:21 PM To: CF-Talk (E-mail) Subject: cfmail error question have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out

RE: Cfif cfelse question

2002-05-20 Thread Tony_Petruzzi
is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent:

RE: Annoying DB question

2002-05-20 Thread Tony_Petruzzi
how do you have the table setup? what column and default are you using for your PK? if you are using the two columns to form a PK, then you would get this error because, like you said, the values aren't unique. personally i always use uniqueidentifiers as PK and set the default of the column to

RE: Annoying DB question

2002-05-20 Thread Tony_Petruzzi
could you please post the create table statement. BTW IF EXISTS(SELECT * FROM tblBenefit WHERE acctid = @acctid AND visitNum = @visitnum AND benefitType = 1 AND benefitCode = @tempMealCode1) begin update tblBenefit set benefitCode=@tempMealCode1, visitNum=@visitNum

linux CF IDE

2002-05-17 Thread Tony_Petruzzi
anyone know of a linux ide for CF? i really want to make the switch to linux, but haven't found an ide that compares to cfstudio. I doubt I will, but there might be an ide that has promise. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org

FW: linux CF IDE

2002-05-17 Thread Tony_Petruzzi
From: Petruzzi, Tony Sent: Friday, May 17, 2002 3:33 PM To: CF-Talk (E-mail) Subject: linux CF IDE anyone know of a linux ide for CF? i really want to make the switch to linux, but haven't found an ide that compares to cfstudio. I doubt I will, but there might be an ide

RE: linux CF IDE

2002-05-17 Thread Tony_Petruzzi
I think I got that wrong :P. I should of said a CF IDE for linux. yeah that's it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:33 PM To: CF-Talk

dynamic select boxes in netscape don't work

2002-05-16 Thread Tony_Petruzzi
I'm writing an app that will use dynamic select boxes. you know, the ones where you select something in one box and it populate the other select box with the appropiate choices. the problems is that I'm trying to get this to work in netscape 4.79 for windows and it isn't working. works fine in

RE: dynamic select boxes in netscape don't work

2002-05-16 Thread Tony_Petruzzi
function ChangeSubCategories(obj){ cfloop query=GetCategories cfstoredproc procedure=WEBGetSubCategories datasource=#request.dsn#

RE: How to detect timeout session??

2002-05-16 Thread Tony_Petruzzi
cfif Datediff(n, client.LastVisit, now()) GTE 40 cflocation url=#request.serverroot# addtoken=No /cfif put this in your application.cfm. make sure to client variables enabled. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message-

RE: Client var problem

2002-05-15 Thread Tony_Petruzzi
why don't you just drop the client variable database and then recreate it. see if that fixes the problem. why waste your time beating your head against the wall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ian Lurie

RE: MS SQL vs MySQL WAS: [admin] List status

2002-05-15 Thread Tony_Petruzzi
article here http://www.eweek.com/article/0,3658,s=708a=23115,00.asp also you have to take into account that they were using JDBC drivers and MSSQL had problems. Quoted: Due to its significant JDBC (Java Database Connectivity) driver problems, SQL Server was limited to about 200 pages per

RE: Here is a strange one...

2002-05-14 Thread Tony_Petruzzi
is the cfexec service logged on as a local system account or a particular user? if it is logged on as a particular user, does that user login have the right permissions? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Adrian

RE: Computer Professionals / Cold Fusion Programmer

2002-05-14 Thread Tony_Petruzzi
god I wish! ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:31 PM To: CF-Talk Subject: Computer Professionals / Cold Fusion Programmer Does anyone know how

RE: Tag Updater for Studio 5 and MX?

2002-05-07 Thread Tony_Petruzzi
well if they don't, I'm sure it wouldn't be a problem to write them overselves. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 9:58 AM To: CF-Talk Subject:

RE: SELECT TOP n vs MaxRows...

2002-05-03 Thread Tony_Petruzzi
Tyler is right. Using TOP is way more efficient since you aren't bringing 1000 results throught the pipeline only to use 10 of them. The only thing about TOP is that you can't set it dynamically, as is TOP @maxrows. To do this, use the SET ROWCOUNT @maxrows. Just be sure that after your SQL

RE: SELECT TOP n vs MaxRows...

2002-05-03 Thread Tony_Petruzzi
actually thats not the same. SET ROWCOUNT will stop processing when @MAXROWS is reached, it ignores ORDER BYs. a TOP will order first then truncate the resultset. are you sure about it ignoring ORDER BYs? I just ran a test with SQL Server 7.0 and it returned the correct results and I included an

RE: session/browser problem??!!

2002-05-03 Thread Tony_Petruzzi
i posted the answer to this question a while back. I have found the light http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316112 basically you can't have illegal characters in the domain name. in my case it was a _. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED]

RE: SELECT TOP n vs MaxRows...

2002-05-03 Thread Tony_Petruzzi
the pk column is a primary key, so yeah. ;) well at least its something to keep in mind. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 10:41 AM To:

SQL Server permission question

2002-05-01 Thread Tony_Petruzzi
does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert,

RE: Distributing self-contained CFMX apps

2002-05-01 Thread Tony_Petruzzi
I would personally love this. right now I have to port all of the CF applications functionality to VBSCRIPT to achieve the same result. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]]

RE: CFMX

2002-04-29 Thread Tony_Petruzzi
i tried installing this thing for 2 hours under XP Por and IIS. couldn't get it to work for nothing. Finally did the install and told it to use it's own stand alone server and it works fine. Can someone tell me why. I would love to know. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED]

RE: WDDX Breaking Hidden Field

2002-04-26 Thread Tony_Petruzzi
why don't you use the urlencodedformat() before serializing the data. this will take care of any quotes, double quote, pound signs, or any other character that might cause a problem. then use the urldecode() to convert it back. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED]

RE: WDDX Breaking Hidden Field

2002-04-26 Thread Tony_Petruzzi
why don't you use the urlencodedformat() before serializing the data. this will take care of any quotes, double quote, pound signs, or any other character that might cause a problem. then use the urldecode() to convert it back. second time Anthony Petruzzi Webmaster 954-321-4703 [EMAIL

RE: Is there a CF open source shopping cart program

2002-04-25 Thread Tony_Petruzzi
i bet that one of the shopping carts that alot of us looked at when we first got into CF is the How to write a shopping cart in CF at www.webmonkey.com It has the source and is a great way to start. once you get the foundation, you can write one yourself easily. you can also look at the developer

RE: Macromedia XML feed contest

2002-04-25 Thread Tony_Petruzzi
just wondering but isn't wddx a form of XML? couldn't you use an XML parser to parse WDDX packets? if this is true, then why don't they just have a wddx packet. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL

RE: Another mistery

2002-04-25 Thread Tony_Petruzzi
this has happened to me before. i have no idea what causes it, but i think this might fix your problem since it did in my case. right click on your website from IIS manager and goto properties. click the home directory tab. at the bottom there is a drop down box called application protection.

RE: Macromedia XML feed contest

2002-04-25 Thread Tony_Petruzzi
question: where to get it ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 9:20 AM To: CF-Talk Subject: RE: Macromedia XML feed contest If you guys are

RE: Hosting

2002-04-25 Thread Tony_Petruzzi
I will second that! you guys are the best ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 3:27 PM To: CF-Talk Subject: Re: Hosting www.HostMySite.com If you

RE: Keeping track of logged-in users...

2002-04-23 Thread Tony_Petruzzi
client.lastvisit does the same thing and is handled by CF. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 5:12 AM To: CF-Talk Subject: Keeping track of

RE: A way to hide the CF source on a website?

2002-04-23 Thread Tony_Petruzzi
I'll be honest, there is not way! yes you can encrypt it with cfencrypt and I can download a program that will unencrypt it. there is no way for someone to right-click in their browser to view your CF code.(NOTE: this is possible with the .htr and a bunch of other security flaws. are you up to

RE: A way to hide the CF source on a website?

2002-04-23 Thread Tony_Petruzzi
http://shrewm.net/cfd/ Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:28 AM To: CF-Talk Subject: Re: A way to hide the CF source on a website? Try the

RE: Archives

2002-04-23 Thread Tony_Petruzzi
http://www.mail-archive.com/cf-talk@houseoffusion.com/ or Kevin L. gave me this idea. just save all the messages in outlook and use outlook find to search them. of course you have to be using outlook. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org

where can we make announcements?

2002-04-22 Thread Tony_Petruzzi
want to know where we can make announcements about CF projects (ie. tags, useful tools) we are developing? is it appropriate to announce them here? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org

RE: DSNless connections

2002-04-22 Thread Tony_Petruzzi
you don't have to pay $$$ for the hosting company to setup a DSN for you. ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:29 PM To: CF-Talk Subject: RE:

RE: manipulating a text file...

2002-04-19 Thread Tony_Petruzzi
you can use cffile, the thing is how big is the file? if it is too big (like 100 meg) it might take awhile and might even crash the system if you don't have enough ram. might actually want to do this in VB if you know it. VB has some very simple fuctions for working with files. Anthony Petruzzi

RE: CF Server Logging Questions

2002-04-19 Thread Tony_Petruzzi
seems like this problem has been around a while. since cf 2.0. http://groups.google.com/groups?q=%22Windows+NT+error+number+232+occurred%22 hl=enselm=60s8ds%24i7d%241%40wolfe.wimsey.comrnum=2 haven't seen anything on what causes it though. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL

neo question

2002-04-18 Thread Tony_Petruzzi
weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide

RE: neo question

2002-04-18 Thread Tony_Petruzzi
sorry about that. i tried to logon into the forums and i forgot my password. i'm waiting to get a reply and i thought that i could ask the list. it won't happen again. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Raymond

RE: RecordCount is 0 en Stored Procedure

2002-04-18 Thread Tony_Petruzzi
from what i have been told, this is suppose to be faster and more efficient. i just like the fact that i don't have to declare variables. ;) IF NOT EXISTS( SELECT UserName FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND

RE: Purge cfVar db using SQL script

2002-04-17 Thread Tony_Petruzzi
make sure you use truncate table cfdata truncate table cfglobal it's faster then DELETE FROM cfdata DELETE FROM cfglobal also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more about it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org

  1   2   3   >