This is the Tcl binding, right? You could replace the variable by its value using [string map]:
db eval [string map [list USER_ID $user_id ...] $sql_statement] or more directly: db eval \ "CREATE TABLE view_report_01 AS ... WHERE u.id = $user_id ..." Regards, Arjen On 2009-02-27 15:28, Alexey Pechnikov wrote: > Hello! > > Is there way to careate view such as > > db eval { > CREATE TABLE view_report_01 AS > ?SELECT s.name ?AS service_name, > ? t_l_r.cost AS cost > ?FROM work.users ? AS u, > ? work.user_contracts ?AS u_c, > ? work.user_services ?AS u_s, > ? work.services ? AS s, > ? telephony.telephony_log_rating AS t_l_r, > ? telephony.telephony_log ?AS t_l > ?WHERE u.id = $user_id > ?AND u.id = u_c.user_id > ?AND u_c.id = u_s.owner_id > ?AND u_s.service_id = s.id > ?AND u_s.id = t_l_r.user_service_id > ?AND t_l_r.log_id = t_l.rowid > ?AND ($date_from = '' OR julianday(date2iso($date_from)) < t_l.date_start) > ?AND ($date_to = '' OR (julianday(date2iso($date_to)) + 1) > t_l.date_start) > } > > I have params $user_id, $date_from, $date_to. There are a lot of queries to > this view and is needed to place params in the view. > > Best regards. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Delft Hydraulics, GeoDelft, the Subsurface and Groundwater unit of TNO and parts of Rijkswaterstaat have joined forces in a new independent institute for delta technology, Deltares. Deltares combines knowledge and experience in the field of water, soil and the subsurface. We provide innovative solutions to make living in deltas, coastal areas and river basins safe, clean and sustainable. DISCLAIMER: This message is intended exclusively for the addressee(s) and may contain confidential and privileged information. If you are not the intended recipient please notify the sender immediately and destroy this message. Unauthorized use, disclosure or copying of this message is strictly prohibited. The foundation 'Stichting Deltares', which has its seat at Delft, The Netherlands, Commercial Registration Number 41146461, is not liable in any way whatsoever for consequences and/or damages resulting from the improper, incomplete and untimely dispatch, receipt and/or content of this e-mail. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users