index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Straight SQL :: (5) Post a New Message | Post a Reply
Feb 8 2006, 5:12 PM	Straight SQL Post a Reply
aldegn since: Feb 3, 2006 from: United Kingdom	Hi, Is it possible to input 'straight' SQL in this solution? I was just thinking that some of the queries I need don't seem to be feasable with the interface but there might be a way of overriding in some cases...? How could I do LEFT JOINs, CASEs and things like that? Thanks
Feb 9 2006, 1:51 PM	Re: Straight SQL Post a Reply
ghost from: Washington, DC	The only way you can use straight SQL is by using the DataGrid object. The wizard does not allow the use of SQL because of security reasons. ------------------------- Ghost
Feb 14 2006, 9:35 AM	Re: Straight SQL Post a Reply
aldegn since: Feb 3, 2006 from: United Kingdom	Thank  you for your quick answer. Why is that a security issue? Wouldn't it be possible to just allow SELECT statements?
Feb 14 2006, 11:35 AM	Re: Straight SQL Post a Reply
ghost from: Washington, DC	Context sensitive data from certain tables or fields blocked from the code can be accessed if intelligent SQL statements were issued ------------------------- Ghost
Feb 14 2006, 12:29 PM	Re: Straight SQL Post a Reply
aldegn since: Feb 3, 2006 from: United Kingdom	Very true. Didn't think of that one. Shame! Thank you for your answers though.
Pages: (1)   [1]

search this forum: