Solved

Search Results Problem

Posted on 2004-09-23
1
178 Views
Last Modified: 2010-04-25
I'm using DWMX / PHAKT / PHP / MySql.  I've set up a search query as shown below. When I test the 'DateListed' field with a real date, such as 2004-09-10, in the recordset Server Behavior window, it works fine.  But, when I run the same DateListed query from the actual search page, it produces no records on the result page.  All the other variables work fine on the results page.  

SELECT* FROM projects WHERE county LIKE '%varcounty%' AND license LIKE
'%varlicense%' AND DateListed >= 'varlisted'

Variables:
Name         Default        Run-time Value
varcounty    %                $HTTP_GET_VARS['county']
varlicense    %                $HTTP_GET_VARS['license']
varlisted      %                $HTTP_GET_VARS[listed]

What am I doing wrong?  Any help would be greatly appreciated.


Richard T

0
Comment
Question by:grnt
1 Comment
 
LVL 10

Accepted Solution

by:
rockmansattic earned 125 total points
ID: 12132528
This is not a Dreamweaver question, you would yeild better results in sql or Mysql section of EE.

BUT,
possibly change $HTTP_GET_VARS[listed] to $HTTP_GET_VARS['listed']

but the real problem looks like it lies in the data stored in that variable.  I would bet that it is not in the correct format YYYY-MM-DD as your test is in.

Rockman
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now