Recent content by joebickley

Hi Want to be able to put a line into an ASP page that stops the browser from cache'ing it. As it stands sometimes it doesnt update after underlying data changes. I want it to fully re-run everytime. how do i do this? Thanks Joe

Perfect, thanks muchly

Hi I have a stored proc that returns two recordsets. Is it possible to use both of them in VBA as i can only seem to pick up the 1st one that is returned. Thanks Joe

Hi thanks for your help. I neglected to mention that the years ran november to november and that i would pass in a year at random but i took your idea and worked on it. heres the code for reference. select count(*) from (select distinct employeeid from tblapplications where...

Hi I have a table with 10000 applications in it each application is made by a person with an ID. I need to be able to find out how many of the people who made applications in the last 12 month period had never applied before. Ive done this in MS access by making a qry for the old data and a...

Hi Outlook 2000 and exchange. If i receive and email from external to the business and click reply to all i am always on the recipients list, meaning if i forget to take my name out i end up emailing myself with my reply. It doesnt do this on a reply to all from a mail from within the...

I know i can use the CASE method but with 50 fields its not very practicle. And as for building the SQL string and executing it, like i said in the original post there are other things preventing that. No matter i will look for another way Thanks anyway

Hey no fair i told him first :)

well you could get it to use a default to make the code for you on insert or if the prefix of your serial number doesnt change then u could just put an input mask on it in you VB app.

Calm down was only trying to understand ur use of it. life of a proc as in if u had a proc doing a load of stuff and u didnt want any triggers to fire while it was doing it. ALTER TABLE tableX DISABLE TRIGGER triggerY that will do it ALTER TABLE tableX ENABLE TRIGGER triggerY strangly...

thats what an indentity field does.

permenantly or just for a life of a proc?

Hi, im trying the following in a stored proc Select * from tablex order by coalesce(@sortfield, referencenumber) I want it to sort by a field that i pass into it, if it is not provided i want to use the reference number but it doesnt work. I cant build up the SQL text and execute it as i have...

Perfect !! thanks a lot for that!

Hi Im trying to make a proc return a list of data depending on what parameters are sent too it. There are 8 parameters all of which are optional. If non are sent it returns all the records if 2 are sent it uses them etc etc How can i build a wher clause to reflect this as it can be different...