I'm tring to use this code on a page with column header sorting and page next/back. but I get an error
The value "" cannot be converted to a number
The Error Occurred in D:\wwwroot\PrintStreamTest\Profit_By_Customer\NextNIncludeBackNext.cfm: line 13
11 : <cfloop...
here is the code, I have been fooling with this for days, I can do the sort but when you sort and then try to go to page 2 etc, it goes by to the default sort,
This is the detail page, I have it keeping the session var from the summary page.
--->
<cflock scope="session" throwontimeout="no"...
I need to run 3 access database, what we do is they are sch to run at night, they create copie of table we use for reporting on the next day. We do this because we found it is faster then accessing the the database during the day. I have 3 because 1 was to large. The problem is they are...
I want to set the data so if the date is < 03/31/05 in a record, you can not change any data in that record, you can look at it but not change it. How would I do this
I have a form that is being use to update a file, I placed an unbound control on it and will use this to look for the record to update. It founds the record if it is there fine, but if nomatch I want it to ret to the seach field. I put this code in the afterupdate event of the search...
I need to use >= <= in a lookup, I'm not getting errors now but I get null. I have a weight1 and weight2 field which is the range fields, then on the form I have the weight, I need to check the weight1 and weight2 and get the cost for the weight from the table.
I'm using this in the...
=DLookUp("[PMrate]","rategood","weight1> =' " & Form!weight & " ' And weight2< =' " & Form!weight & " ' ")
Here is the lookup, I know it is just the " ' are in the wrong place
thanks
I have a database to keep track of domistic postage, I need to just get the foreign postage from a table of rates for the weight and print out a sheet to go in the jacket. I don't need to keep this info we don't track it. I just want to give the billing people the rate to charge for the foreign...
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.