Search Help with CONCAT command
Software: Dreamweaver CS4
Extension: DataAssist 2.08
Hello, my database 'Notes' table have
'date' type called 'note_Day' and
'time' type called 'note_EndTime'
I use CONCAT command from sql to get the complete date as end time in search page.
CONCAT(Notes.note_Day,' ',Notes.note_EndTime) AS Date_Note
But I get the message:
Unknown column 'Date_Note' in 'where clause'
How I can solve this trouble ?
The file search.zip have the search-result page.