The Sql works (I think) If i put in a default value (a value which exists in my database) then if i click test. It returns back the correct result from th database. If i leave the default value in, then search using my IIS. It always returns the default value. If i put the default value to %...
Cheers. I have tried various statements but i still cant get them to work. the latest one being -
SELECT *
FROM Location, Service, Customers
WHERE LocID = 'varLocID' AND ServID = 'varServID' AND Location.LocID = Customers.LocationID AND Service.ServID = Customers.ServiceID
And for the...
Hi, I am new to all this programming lark, so please forgive me in advance for any stupidly obvious questions i ask.
Iam currently building a database driven website for work - well trying to anyway :(
iam using dreamweaver MX and Access.
I have 3 tables in access :-
-Customers -
Company...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.