var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL statement
My DB is Access.I'm trying to pull data from access database into an XML file.I'm able to pull the data.But when I try to apply WHERE clause in my sql statement,it doesn't work and is giving me the syntax error.
Here is my SQL statement,
.Source = "SELECT * FROM ([GrantNet],[Categories]) " & _
"WHERE GrantNet.Issue_Number= 01-11"
I'm not sure what mistake I'm doing.Any help is appreciated a lot.Thanks,
most likely you need single quotes around the issue number, because what your query now looks for is issue numbers equal to -10, because 01 minus 11 is -10
also, it looks like you're getting a cross join of two tables, is that what you really want?
Thanks for the reply.But I tried putting single quotes around 'Issue_Number' .It generrates only the schema and does not generate the XML file at all.
sorry for delay in replying, AFK for a week or so
no, put the quotes around 01-11
as for XML, sorry, can't help, wrong language