Search results for query: *

It worked!! Thanks a lot! Thanks, (-: Brian

:( Even this gives me a syntax error: "UPDATE log SET section = IIF (section = 'FULL', 'SKIP', 'FULL') Thanks, (-: Brian

Either way, I still get a "syntax error in the UDATE statement" ... Any ideas? Thanks, (-: Brian

Oops... I have one more question... What if there are 2 cases where I don't want to switch this... and that case is if the value in the column "area" is "DIS0" or "DISX"... Will this add much complexity? Thanks, (-: Brian

And these are all single quotes, right? Thanks, (-: Brian

wait, wait: sql$ = "UPDATE Table1 SET Section = IIF ( section = "FULL" or section = "SCREEN", "SKIP", IIF ( section = "SKIP", "FULL", section ))" Thanks, (-: Brian

Ok, cool. Now let me see if I have it right: sql$= "Section = IIF ( section = "FULL" or section = "SCREEN", "SKIP", IIF ( section = "SKIP", "FULL", section )) Is that right? Thanks, (-: Brian

lespaul- Yes, thank you. What about if I had a third condition? I need all "screen" to be changed to "skip" as well. Thanks, (-: Brian

Thanks again! I see how it will work now. I'm a bit confused about the format, still. Should the SQL statement read: sql$= "UPDATE Table1 SET Section = IIF ( section = "FULL", "SKIP", IIF ( section = "SKIP", "FULL", section )" Thanks, (-: Brian

Thanks for the reply! Two questions: 1) Is that all to be as one SQL statement? 2) Won't that change everything to "Full" since it will change everything to "Skip" and then all "Skip" to "Full"? Thanks, (-: Brian

Hello, Right now I have code that successfully inserts one table into another. I would like to be able to change the values in one column on the final merged table. strsql$ = "INSERT INTO table1 SELECT table2.* FROM table2;" db.Execute strsql$ In the final table1, if the value under the...

Great! It worked! Thanks, (-: Brian

Hello, I am trying to merge table1 with table2, but only when the "section" column has a certain value. The statement worked fine until I added the last WHERE clause. I get the error "Too Few Parameters. Expected 1." The error explanation on the Microsoft website says, "you refer to a column...

That worked. Thank you very much! Thanks, (-: Brian

Thanks for your feedback! I seem to be having a problem with this solution. My final string looks like this: "INSERT INTO table1 SELECT table2.* FROM table2 WHERE ID = 01" However, I receive an error 3464: Data type mismatch in criteria expression. The line also does not work when I add a...

Hello, Right now I have a statement in VB6 that inserts all the contents of one table into another. However, I would like to only select a certain ID from that table. Here is what I have now: strsql$ = "INSERT INTO table1 SELECT table2.* FROM table2;" db.Execute strsql$ How can I modify...

It worked! Thank you all very much! Thanks, (-: Brian

Thanks for all your help. Hang in there with me... I am receiving an Internal Script Error on the page. It says it is expecting a ')' at character 63. Am I correct in saying that I do not need to change _myURL to anything when I implement the code? I just copy the script just as it is in...

Jeff- Yes, I understand where this code would go, however I'm still unsure about one item, please bear with me: What do I replace with the _myURL in the java script, and does it need to be in quotes? Is it the URL of the current page? Thanks, (-: Brian

Jeff- Thank you very much for your reply. My webpage has several different links pointing to different destinations, and so is there a way I could make this work for multiple destinations? It appears this would only work for a page with a single link for which I would like this message to...