Response.Write <a href=" & chr(34) & "editScheduleItem.asp?Submit1=" & cstr(fldvalue) & chr(34) & ">" & cstr(fldvalue) & "</TD></H4>" & chr(13)

Where fldvalue would be your unique ID Field. Then the page...

I just added some comments and added the variable @DayOfWeek to Zaltug's great script. I bet if someone else looks at this, they'll be able to get it down...

The only way I know of returning a value back from dynamic sql is to use the system sp called sp_executesql. Here's an example:

DECLARE @nvch500SQLStr as nvarchar(500),

@nvch500ParmStr as nvarchar(500),

@nvch20SegValLocal...

Okay, How about this?

select count(DriverID) from

(select driverID, Delivery_date,

DeliveryTime =

CASE

WHEN datepart(hour,Time_TargetDelivery) between 7 and 10

Then 'B'

WHEN datepart(hour,Time_TargetDelivery) between 11 and 15

Then 'L'

WHEN datepart(hour,Time_TargetDelivery) between 16 and...

DECLARE @nvch500SQLStr as nvarchar(500),

@nvch500ParmStr as nvarchar(500),

@nvch20SegValLocal as nvarchar(20)

--This is the select Statement and allows you to use Dynamic SQL AND also return a value from the statement

SET @nvch500SQLStr =...

You can also create a view in SQL Server that formats the data in the way you want and Crystal will access it just like a table. The views...

By looking at the code you gave, it appears that you're trying to set the values on the form instead of binding the form to the recordset. Try using...

As for the vertical selects, etc. versus the horizontal selects, I prefer using the vertical selects for inserts and updates and horizontal selects for selects.

Here's why.

When you're...

Hi Mark,

I don't mean to start an argument, but the UPDATE() function is field specific, so you WOULD have to test for each row because you might have updated multiple...

Your best bet would be to use a cursor. I don't like using cursors, but I don't know of any way to check the Update() values without scrolling through...