Search results for query: *

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

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

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

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

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

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

Have a form with a subform. The subform has 4 fields for the user to enter data into. If data is entered into all 4 fields the record updates the table properly. But the user wants only to enter data into 1 field and come back another day to finish entering data into the other 3 fields. The...

When a record is updated on a form I want a field in the table to show current user. My database is on a server. User can be login name or the w98 workstation name. My table has a field called operator. Is there a default value I can add to make this field update / record? Victoria

I want to update table.field1 with the data that is in my form's text box1 as each records updates. I believe that I need to attach some code to an event but not sure of the syntax. Victoria

I have 2 bound fields - Percent and Data. I need to separate the Data into two columns. I have 2 unbound text boxes. 50andOver and Under50. I want [50andOver] to equal [Data] if [Percent] => 50 else I want [50andOver] to equal &quot;0&quot;. I want [Under50] to equal [Data] if [Percent]...

Every other page has a few vertical grey lines when printing a report. I can not find out why this is happening. Does anyone have any clues? Victoria

For Data entry with a subform..Am I right in thinking that every record entered in the subform should also include the Main forms' data also. I have a year and a month in the main form and entering about 20 days in the subform. The table shows most records without yr and mo.

I want the default value for a new record field to be the previous record's data for that field. Example-- A clerk will have to enter 200 records at a time. If some of the fields' data remain contant with only a few variations then it would be easier to start a new record with the data from some...

I'm new to FMP5 and am having a hard time creating a script that will delete duplicate records... Any help will be appreciated. Thanks