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.
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...
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.
Hi, I am using cffile to upload a image (which works great). But I am having problems with copying that image over.
How can I get the image path that I just uploaded so that I can copy it over?
Thank you.
Hmmm, thanks for replying. I will have to contact MLS on Monday and see if they have any procedure in place for this. I'm assuming they do since all the real estate websites do this.
Thanks.
Hi folks. I just got asked to develop a real estate website for a family friend, and it looks pretty clear cut, and I understand what their asking for and I'm confident I can deliver.
My main concern is how to show listings on the company website that gets pulled from MLS. All real estate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.