Search results

Psst Bob a quick definition of "spammers" mate, means different things on different sites. Now where's that viagra ad I meant to put in me sig ;)

sSQL = "SELECT B.BookID, B.BookTitle, B.Book.SubTitle, C.CategoryName, R.FirstName, R.LastName, " _ & "P.PublisherName, B.DateSent, B.DateReceived, B.DateRequested, B.DateReturned, " _ & "B.JournalMonth, B.Reviewed FROM Books AS B " _ & "INNER JOIN Category AS C ON...

Oops nope .... will give it a go on the second testing round :)

I have this problem as well :D Actually if the site owners are unaware it should be a modification available from vbulletin.org I would imagine. Nope don't use vBulletin in answer to anyone asking, use invision myself :)

Yes pretty much the free is knocked out of everything, and you apparently immediatly do everything wrong :confused:

Okay sussed it, SQL doesn't like the "-" in the selection data. A bit of use of the string function and a Like clause and away we go :) Drat, damn, who designed this database!

Thanks for the answer Gizmo but it's actually a text rather thna date field :)

Bit of a splurge during the week. Zombie's "Devils Rejects" dear god in heaven he's ripped scenes from TCM 2. NIghtmare on Elm Street 1, 2, 3 <- cheap box set. Double dipped with the four disc R4 Spiderman release. Evil Dead Trilogy Tin winging it's way by courier.

Closing on the quarters and the Saffas, Aussies, and kiwis are going okay. England look not a trace of the 03 team, the French are a shambles, and other six nation sides don't look to hit. Los Pumas doing well, though they could still be nudged out if Ireland down them by four tries and 7+ points.

Just on the off chance, can you access the database via the MySQL control panel?

The error you are getting sounds like MySQL is objecting if that's any helpes. Sorry use MySQL with PHP but haven't tried with vb6. Should strPassword have a value?

Just brought Battllestar Gakactica Seaon 1 over the weekend due to being well impressed with the mini series someone lobbed on Friday while we were waiting on France v Argentina Since I was in the shop also got my grubby hands on Stargate Season 6 The Changeling The Descent Pulse (U.S...

Sounds like the pages in the other folders do not have the path to the database perhaps :confused:

To backup Jakboi here, do a google for a product called wamp5 and install that. The easy way to get the products listed installed, a few questions and you're done ;) Of course it's more fun to do it manually, but simple can't work out how to get php working with apache on XP platforms :( Never...

Strangely have a splitting headache at the moment and am blaming a woman for it. She shouldn't have opened the third and fouth bottles of wine last night :( Going to be a loooooooonnnnnnnggggggg day.

seb from form3 you can access objects in form2. For example you might want to populate a text box so you would simply do: form2.txtWhateever.text = cboWhatever.text HTH

Vince you seem to have mixed a whole lot of skills in there. Generally dynamic data driven websites are built around one technology and associated stuff. So for example you would have an asp site or a php site. Never a good idea to mix and match the two imho. If interested can give you contact...

Okay found something and going into modification mode on it. About 60% of what I require. If anyone wants a copy of the finished product scream out and I'll happily send it over to you. Should take about four weeks to complete coding. Currently setting up an apache/mysql/php development box.

Wayne code is in vb6, access is our backend database. Requirement is to allow the software client to switch databases to either oracle or unidata in the future. Not seeing a "BeforeUpdate" method in those available. Thanks for the reply.