This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I'm trying to find a way to use create a parameterized query using the RawSql feature of the Lightspeed 5 Query object. It seems like this should be possible but I can't find any documentation on how to pass parameters into the query object? Any help would be much appreciated. Thanks. |
|
|
|
|
No, .RawSql is just a raw string so you need to manage it yourself so we would definitely not recommend it for use with any user supplied input. We have supplied this strictly as a crude escape hatch so you can mix standard queries with custom built queries. If you are looking to execute a parameterised query in isolation you can use UnitOfWork.PrepareCommand or UnitOfWork.FindBySql to achieve this.
|
|
|
|
