homepage Welcome to WebmasterWorld Guest from 54.205.193.39
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
create query to bracket years in database field
dreaming




msg:950284
 8:07 pm on Feb 12, 2005 (gmt 0)

I am a newbie to Dreamweaver and am trying to figure out if it (or I) can create a bibliography search engine. I have managed to create a basic page with a form that searches author and keyword but am having trouble adding a search for years. I found a description on the Macromedia support page that provides an example but it doesn't seem to be working for me. Below is the SQL query I have in my Recordset dialog box. Any suggestions? The error statement is: [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression.

SELECT AuthorNames, Keywords, Citation
FROM literature
WHERE Keywords LIKE '%listKeywords%' And AuthorNames LIKE '%listAuthor%' AND Year BETWEEN #listStartYr# AND #listEndYr#

 

Zaphod Beeblebrox




msg:950285
 11:04 am on Feb 13, 2005 (gmt 0)

Remove the #'s if the field Year is a numeric field.

mattglet




msg:950286
 2:49 am on Feb 14, 2005 (gmt 0)

Are those ASP variables you are trying to use in your query?

(listKeywords, listAuthor, listStartYr, listEndYr)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved