Search results for query: *

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

I want 0's to fill my form input boxes.. If users don't fill in all fields then the value of 0 will insert to db instead of nulls. How do I pre fill with a value? <cfif IsDefined("FORM.L259F") AND #FORM.L259F# NEQ "">#FORM.L259F#<cfelse>NULL</cfif> Victoria

For W98 workstations...My users home directory on the NT server is: \\server\home\BOB , \\server\home\SUE,..ect... In the enviro.. Profile I have Connect H: to \\server\home\%username% and I've tried \\server\home$\BOB, and \\server\home\bob ..... In the script I have net use h: /home After...

How can I set a varible to = the computer name in w98? Victoria Victoria

Not sure how to use a varible. Where do you add it to the report. How do I get iSiteCount to show on report? I copied and pasted the code and I assigned a textbox control source to =iSiteCount.. No luck...

I have 133 records. 133 days. Each record has a site, day,data. The report is grouped by site. In the footer I have: count([Site]) . I get 133 sites. There are only 5 sites. I need a distinct count of the sites. Looked in Help docs but unable to find how to do this. Victoria