Member Avatar for arslanazam90

"SELECT * FROM table where column=" & Request.QueryString("querystringfeild")
i want to add order by condition along with where condition. But i don't know how to write syntax please help me. thanks!

  • 3 Contributors
  • 3 Replies
  • 65 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by xerohomicide
Member Avatar for Sahil89

select * from table ORDER BY empID

Member Avatar for arslanazam90

no i mean i want to wirte order by after where condition bu i dont know syntax i mean where to write commas or collan etc please help me in syntax

Member Avatar for xerohomicide

SELECT * FROM table where column='" & Request.QueryString("querystringfeild") &"' ORDER BY table_field"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.