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
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
...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 applicationApprovedDate between '2003-11-01 00:00:00' and '2004-11-01 00:00:00'
)...
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
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...
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...
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...
Hi
Im trying to create a proc to update a single field in a table, but that field can be different each time. ie i pass in the field name and the value i want it to be set to. What i have tried to do build and SQL statement into a string and execute it. This works but only from SQL server not...
As i said in the original post, i know you can do it in a select statement but i dont wont to return a set of data its just the decision tree i wanted. JamesLean is right they are not supported
I just asked in case i had missed something and someone new better
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.