Record Sorting

[tekyge]

Below is my statement anyone know how I can get it to sort by last name record set [ProjectName]. Thanks for help

sql = "SELECT * FROM [Projects] WHERE [Projects].[ClientID]=" &Trim(session("myvar1"))
rs.open sql, conn

 

[DotNetGnat]

did you mean...

sql = "SELECT * FROM [Projects] WHERE [Projects].[ClientID]=" &Trim(session("myvar1"))& " ORDER BY [Projects].[ProjectName] ASC

-DNG

 

[tekyge]

Thanks dot, but its givin this error

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/cs/login/fr/index.asp, line 44

sql = "SELECT * FROM [Projects] WHERE [Projects].[ClientID]=" &Trim(session("myvar1")) & " ORDER BY [Projects].[ProjectName] ASC
--------------------------------------------------------------------------------------------------------------------------------^

 

[johnwm]

That will be because you are trying to embed quotes in a string, and not finally terminating the string, Try:

sql = "SELECT * FROM [Projects] WHERE [Projects].[ClientID]=" &Trim(session([COLOR=red]"[/color]"myvar1"[COLOR=red]"[/color])) & " ORDER BY [Projects].[ProjectName] ASC[COLOR=red]"[/color]

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[damber]

Just a small correction for our copy-and-paste friends:

sql = "SELECT * FROM [Projects] WHERE [Projects].[ClientID]=" &Trim(session("myvar1")) & " ORDER BY [Projects].[ProjectName] ASC"

A smile is worth a thousand kind words. So smile, it's easy!

 

[tekyge]

Thanks guys for your help works great!!

 

[DotNetGnat]

i just missed the quotes in the end...sorry for that...

glad its working for you...

-DNG

 

[tekyge]

10-4 I thank all of you for your help.