Recent content by AlwaysWilling

Hi Catadmin, thanks for the reply. I removed the $-sign but I still get that error. Am I calling the sp correctly?

Hi everyone, I am creating a stored proc like this: use northwind GO create procedure sp_insert_orderDetails @OrderID int, @ProductID int, @UnitPrice smallmoney, @Quantity smallint, @Discount real as insert into sp_insert_orderDetails (OrderID, ProductID, UnitPrice, Quantity...

Hi Catadmin. Thanks for the reply. What I mean by users is users that register from the website. These users can then access 'members only' content. I kinda had a feeling that the server load depends more on the server machine itself and not on the dB makeup. I will check the hardware...

Hi folks. My boss wants me to find out if the current database and its confiuration is right, so can someone help me decide? I'm not that knowledgable in this, and this was just thrown in my lap this afternoon. We are using MS SQL Server 8 on a DELL 1750 machine. The machine has 1GB of RAM...

I don't know why everyone was ganging up on GUJU, it's not like tek-tips.com itseld is validator.w3.org compliant. http://validator.w3.org/check?uri=http%3A%2F%2Fwww.tek-tips.com came back with 20 errors. GUJU, I like the design and layout. Very clean and easy to navigate.

Anyone?

But the same happens when I take out the cftransaction tag and only leave cftry/cfcatch tags. Does the cftry/cfcatch work the same way as cftransaction tag? In that if the insert into fails the record is removed from the database? Is there a way to make the PK value sequencial order even in...

I'm having some problems with using "cftransaction" with "cftry/cfcatch" tags. What happens is I make the insert into fail on purpose to see if the transaction would prevent the insertion of the new record. I am also using cftry/cfcatch to send myself an email when an error does occur. But I...

Sorry for the delay in responding back. I got busy with other things and didn't get the channce to come here. Thanks all for all the help! By the way, imstillatwork, I love your site. Very helpful. I love how you have a 'demo' of your code and the code itself. Great for begininers and...

imstillatwork, thanks for getting back to me. I was refrencing the tut at http://tutorial20.easycfm.com/ I like what you did also, but I want to know if its doable to show the user a dropdown of 3-4 choices and let them choose how many recs to be shown. Like: <select name="test"> <option...

Wullie, this is my code: Both servers are setup the same way. One is development and other is production. I want to move the image from development to production. <cfif isdefined("FORM.Submit") and FORM.myFile is not ""> <!--- server one path ---> <cfset dest =...

Hi, I see this on many sites, and want to know how I do that. I know I can do a 'Next N' records (easycfm has a great tut on that), but what if I wanted to do something like: 1. Show the user a dropdown with 4 choices (10, 25, 50, 100) 2. Then when the user makes their choice that many...

Wullie, thanks but the same error.

Hi guys thanks for the replies. I am now using cffile to upload the image to a folder on server1, and then using cfftp putfile command to push the the image onto the 2nd server. But I get this error: Connection closed without indication. What does that mean? Thank you.

Oh, and I forgot to mention I am uploading the image on one server and then copying it over to another server. Is that doable with cffile upload and copy? Thanks.