After all that I have worked it out!
set rs2use.source as the first query then rs2use.open
then
set rs2use.source as the second query then rs2.use.open
So simple!!
Thanks for your input guys!
This is the relevant part of the function I am working with.
I need to spilt the Insert query into 2 and run them both.
function quoteSaveQuote2DB()
Set rs2use = Server.CreateObject("ADODB.Recordset")
rs2use.ActiveConnection = MM_PrimaryLocal_STRING
rs2use.LockType = 3...
Erm thanks...but the guy I am doing the site for wants to preview the photos before uploading - through the website.
I could upload before the preview and then delete if the upload is not completed but why put that extra strain on the server.
Sorry but I don't think I explained it very well.
I have a function that calls and executes a query.
This query is an insert query.
What I meant was that I know how to split the sql query into 2 parts, but I don't know how to make the function call both queries.
Unfortunately I cannot post...
I have a script which uploads a photo to my server.
However, I want to be able to preview this before actually uploading the photo.
Is there any way this can be done in PHP?
Hi,
I have taken over a website which has a function that inserts data to a table using the recordset.
I need to split the insert query into 2 as we want to split the table being inserted into.
This is fine - I can write the queries required, but I am used to PHP and am unsure of how to run a...
OK, I have the browse box working now, but I do not want to open or save the file. I want to import it to a specific table in the database.
How do I go about doing that?
Thanks in advance!
Hi,
I want to be able to click a button and browse my hard drive and then import the selected file to the correct table.
I have read a few threads about this, but to be honest, it goes over my head.
I am new to VB programming so a guide for plebs would be gratefully received!!!
I think I already know the answer to this, but thought I'd double check!
Is there a way to get read receipts when sending mail via php mail() function?
Hi,
I am well aware that if you want to promote a UK website, then you host on a UK server, rather than a US server.
However, I have a friend who will be having a .com domain who wants to target mainland Europe - specifically France, Spain and Germany. Can anyone advise me where we should look...
Hi,
I have been asked the best way to access a remote computer, but I know very little about this sort of thing.
My mate splits their time between the UK and France, and wants to be able to access the UK computer while in France.
What is the best way - PC Anywhere, WAN or what? And does the...
I am having a spot of trouble with td height and IE.
I have a table with 3 colums and 3 rows - the middle column spans all 3 rows and the top 2 rows are fixed height - the bottom row expands as needed so has no height set.
This renders exactly as it should in FF and Opera, but IE expands the 2...
I develop sites for FireFox first and then worry about IE after.
I have a site that renders perfectly in Firefox, but not in IE.
I use an opaque gif as a background image in a table cell which is fine in FF but not shown in IE - although it is there in the source code.
Does IE not work with...
Hi,
I have just set up a form to send html newsletters. The newsletter shows up fine in webmail, but if you download it to an email client (I have Outlook) it downloads as an attachment.
Is there anyway I can get round this so it shows up as HTML when it's downloaded?
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.