logo-radria.gif
   
Blog Download Documentation Forum Tasks Home
Blog Download Documentation Forum Tasks Home
barside-right.gif
barside-left.gif
logo-sql.gif

Vanilla 1.1.3 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthortom
    • CommentTimeJan 19th 2009
     
    I have been following the book database tutorial from the address: http://radria.sqlfusion.com/video_tutorial_summary.php

    I created the query "book_search", and followed the rest of the instructions about on the pagebuilder etc, but the search doesnt work.

    should i create a report called "report_book_search" or something?

    I'm really excited by this software as it is exactly what i'm looking for, but i have no idea how to make the search work.

    Many thanks, Tom
    • CommentAuthorphilippe
    • CommentTimeJan 21st 2009
     
    can you past your saved query here as well as your table structure ?
    • CommentAuthortom
    • CommentTimeJan 22nd 2009
     
    QUERY:
    query name: book_search

    select *
    from book
    where title like '%[report_book_search]%'

    TABLE STRUCTURE:
    table name: book

    idauthor List Box
    idbook Simple Number (Integer)
    isbn One Line text
    title One Line text

    table name: author

    idauthor Simple Number (Integer)
    name One Line text

    Many thanks, Tom
    • CommentAuthorphilippe
    • CommentTimeFeb 11th 2009
     
    Tom,
    Did you figured out this one ?
    Seems like its related to the [report_book_search] variable.