Search results for query: *

Hi All, i understand normal paging using using a stored procedure, but how would i page a resultset that has a row with multiple sub rows (like one-to-many relationship i guess) for example. say i return 5 recs per page: id name subid name 1 a 1 w 2 b 2 x 3 c 3 y 4 c 3 y 5 d 4 z if...

Hi All, I understand that its not possible to store multi-dimensional arrays in the application/session/cookies object. Can someone suggest a similar method/workaround for this problem? cheers mitSiguRi

Hi All, shouldn't the following sql: select dateAdd(m,-1,'5/31/2002') return '5/01/2002' instead of '4/30/2002 im using sql server 7 cheers alan

Hi All, I need help with this wee problem This works in access 2000 query designer: SELECT weekdayname(Duration.StartDay) as [start],weekdayname(Duration.EndDay) as [end] FROM Duration; but when i use the same sql in asp, it gives me: Microsoft JET Database Engine error '80040e14'...

Hi, wonder if someone can help me when siteid is null in the subquery, the count returned is 0. is there any way to return a value when the siteid is null. i tried setting ansi_nulls off but it doesnt seem to work in this subquery. heres the sql: set ansi_nulls off insert into...