Recent content by Overmyhead2

by adding 156e to the query, I get this error: Error converting data type varchar to float Victoria

[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '156e' to a column of data type int. Getting this error. ItemMaster.ItemID col has some itemid's that are characters. 156e is an itemid. If I add this 156e to the GetAllItems query, then I get this error...

YES!Thanks to both of you...This worked..<cfif IsDefined("Form.Qty")> <cfloop From = "1" To = "#ListLen(Qty)#" index = "Counter"> <cfquery datasource="#Datasource#" name="insertItems"> INSERT INTO OrderItems(Qty, OrderDate, SiteID, ItemID) VALUES(#ListGetAt(Qty...

Thanks for the replies! I tried the sugested code untill it inserted something to the db. The items! are gonig in ok .. but the Qty is counting 1, 2, 3 ..incrementing for each row instead of the value of the form field Qty. Here's my code <cfquery name="OrderData" datasource="#DataSource#">...

I have been able to insert either Item or Qty but not both. A cfloop inside of a cfloop is not working.. How can I do a cfloop with 2 lists? Here is my Action page.. <cfif IsDefined("Form.Item")> <cfloop index="i" list="#form.Item#"> <cfif IsDefined("Form.Qty")> <cfloop index="x"...

I think my problem is an extra space. I have this link... <A HREF="OrderHistory#page.Select_Category#.cfm?OrderID=#OrderID#"> I get this error.... File not found: /nuts/Frames/OrderHistoryBread .cfm How do I get rid of the space before .cfm? Vickie Victoria

I have 2 tables: tblA- Item1 Item2 Item3 Category tblB- ItemName Description Category I want to SELECT from tblA qty values from the 3 Item Columns & SELECT from tblB ItemName, Description WHERE tblA.CATEGORY=tblB.CATEGORY and tblA.Column...

I need help. I've been reading everywhere. I've learned so far that this is not good programming practice to use col names like this.(forgive me). BUT.. just this once I need a SELECT query that will use Column Names to help put item descriptions into a report. I think I need dynamic SQL. 2...

My first CF project. I'm using frames and I have a cfinclude login.cfm in an application.cfm. All works fine except an unwanted login screen appears in the banner and left column when first opening site. What is a good way to exclude these two frames from including the login.cfm? Appreciate any...

Thanks for the quick responses! After doing a search for the file name on the system I found another cfm file(older ver), same name, that wasn't being updated. FYI- In DW the page I was editing and had open was not the page displayed when I hit view in browser.[smile]

This is my first CF project so any help would be appreciated.. I have a form that was submitting data to the db just right... I then changed some of the table Column Names in the db and the cfm. I now get an error showing the old column names as invalid. I can't seem to find where CF is getting...

Related fields mean ..I want to display the record *(item1, item2, item3 etc...)from this query: <cfquery name="get_OrderDate" datasource="Orders" > Select * From #page.select_category# Where SiteID=#SESSION.Auth.SiteID# that corresponds the the selected #OrderDate# and...

I have 2 related list boxes that work. The second box show a list of dates for the user to choose. How do now display a table containing the date chosen and it's related fields? Here is my code: <CFFORM ACTION="#CGI.SCRIPT_NAME#" METHOD="Post"> <CFIF IsDefined('form.Select_Category')>...

Thanks.. Too easy.. I was looking in the wrong place.. Victoria

It is updating the db with 0's now .. but how can I get the user to see 0's in the form fields beforthey enter any data in? Victoria