Search results for query: *

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 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'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...

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, 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.

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...

Hi, I have a looping problem. I would like tp display all the programs in a select box and only select the ones that are coming from the database (the user's saved programs). This is my code: <cfquery name="query1" datasource="#DB#"> SELECT F.ID, F.First_Name, F.Last_Name, F.a, F.b, F.c...

Hi all. I query the database and put the elements in a select box in a sequence order based on the sequenceid. The user can sort the sequence any way they want. EX: original sequence 1 - Me 2 - You 3 - Her 4 - Him new sequence 1 - You 2 - Her 3 - Me 4 - Him How can I do something like that?

Hello all. My boss wants a shopingcart added to our site now, and I did some research online for a decent shopping cart. I came accross: cfshopkart, cf-ezcart and cartweaver. Does anyone have any comments on which is better one to get? I went throgh the demo and read the features of all...

Hi people, I need some assistance here. We are coding a new CMS system and would like to know how to deal with updates. My scenario is this: suppose Bill logs in and clicks on the link for Product1 to edit/modify. Now, suppose Jane logs in 5 minutes later and she also clicks on Product1 to...

Hello. In the past when I wanted to pre-populate the form fields the user entered I did <cfif isdefined("FORM.fieldName")>#FORM.fieldName#</cfif>, but I got to know that this doesn't work when you use cflocation tag. So how else I can re-populate the user's answers on the form? My scenario...

Hello, I need help setting up my site with paypal. This is my situation: My shopping cart works fine, I can add products and their quantities to the cart, from the cart I click the "Purchase" link which takes the user to my form (this is where the user fills out their name, address, email...

Hello, I need some help in understanding what the process is in developing an eCommerce site. I know I need a vendor for processing the creditcard payments, and I also need a merchant account. But thats all I know. I don't know how the merchant account and the processing vendor interact, who...

Hi all, this is my first post here, so apologies for any mistakes I make. I am developing a site using coldfusion and want to use paypal as one of the payment methods. But I need some help in setting up my site with paypal and IPN. I have my own shopping cart, and have already been able to...