Discuss "Lock page/recordset?" in the ASP Development forum.

Rebelle · #11 October 16th, 2008, 02:41 PM

Hi Wolffy,

Can you see what I'm doing wrong here?

Record Results screen, to:

Code:

<TD><a href="edit.asp?MyID=<%=rs("MyID")%>&RecDate=<%=rs("RecordDt")%>">edit</a></TD>

now on the Edit screen, I don't get any records with:

Code:

Dim sMyID,sRecDate
sMyID = Request("MyID")
sRecDate = Request("RecordDt")

Set rs = Server.CreateObject ("ADODB.Recordset")
 
'build SQL
sSql = "SELECT * FROM dbo.tblTEST"
sSql = sSql & " WHERE MyID='" & sMyID & "' and RecDate='" & sRecDate & "'"

Wolffy · #12 October 16th, 2008, 03:02 PM

OK, see what you are trying here. When you get to the Edit screen, you want to make sure that the record you pull up hasn't changed since being displayed on the results screen, right? Sound good to me.

Looks like you're pulling "RecordDt" and then comparing to "RecDate" tho. Are this both fields in your table?

Rebelle · #13 October 16th, 2008, 03:10 PM

um...nope, ony RecordDt...is that the problem?

Wolffy · #14 October 16th, 2008, 03:12 PM

Then I think the WHERE clause should be and RecordDt = '" & sRecDate & "'" unless I'm missing sumpin'

Rebelle · #15 October 16th, 2008, 03:22 PM

if i take off the AND and RecordDt = '" & sRecDate & "' ...i get the record...

I have to have that correct? so when I do the update part you suggested...

Wolffy · #16 October 16th, 2008, 03:33 PM

Sorry..what I'm getting at is the field called RecDate or RecordDt? Assuming the field name is correct, I'd then Response.Write the value of sRecDate to ensure it's what you think it is (i.e. not blank, has full date/time not just time, etc).

Rebelle · #17 October 16th, 2008, 03:53 PM

seems to be good Wolffy....

it returned:

Code:

SELECT * FROM dbo.tblTEST WHERE MyID='249' and RecordDt='10/16/2008 1:29:38 PM'

Wolffy · #18 October 16th, 2008, 04:47 PM

Hmmm...OK, then go and pull up record 249 and see what's there. I suspect that you are truncating the milliseconds from the datetime value as stored in the record and thus not getting a match.

Working with datetime values can ugly -- however it's interesting to note that a datetime is stored as a numeric and can be converted to a float. Sometime they can be easier to work with as a numeric value.

Rebelle · #19 October 17th, 2008, 08:45 AM

ok...i checked and this is what it had in it

10/16/2008 1:29:38 PM

datetime(8)

Wolffy · #20 October 17th, 2008, 09:30 AM

I'm still leaning toward truncation of milliseconds here. Run the following query and see what you get:
Select cast(RecordDT as float), cast(cast('10/16/2008 1:29:38 PM' as datetime) as float) from dbo.tblTEST WHERE MyID='249'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to retrieve unknown recordset field names in table?	BLaaaaaaaaaarche	ASP Development	2	August 10th, 2008 08:33 AM
Help with asp display / recordset (troubleshoot)	Rebelle	ASP Development	27	June 30th, 2008 11:19 AM
go page to page questionaire app	peebman2000	.Net Development	3	April 26th, 2008 04:42 PM

Discuss "Lock page/recordset?" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). Visit the ASP Development forum for help with ASP/VBScript and ASP/JScript applications.