Hello folks,
I have a problem with an update query on an asp not updating the table
in an Access db. The code runs, I have no errors, but when I examine the
table, nothing was updated. The query works as it should in Access. Could
anyone direct me to some sources that describe solutions to what is likely a
common problem? The strange thing is, I have another update query for a
different db on an asp that works just great. Is there something I may have
neglected to do for the db itself whose update query on an asp doesn't seem
to work? Security issue?
Thanks for any ideas,
David
______________________________
Remove "_SPAM" to reply directly. 6 2194
David Shorthouse wrote: Hello folks,
I have a problem with an update query on an asp not updating the table in an Access db. The code runs, I have no errors, but when I examine the table, nothing was updated. The query works as it should in Access. Could anyone direct me to some sources that describe solutions to what is likely a common problem? The strange thing is, I have another update query for a different db on an asp that works just great. Is there something I may have neglected to do for the db itself whose update query on an asp doesn't seem to work? Security issue?
Hard to say without seeing code. Do you have "on error resume next" anywhere
in your code? If so, comment it out - it may be masking the problem.
Bottom line, we need to see some code to allow us to reproduce the problem
for ourselves before we'll be able to comment on what's happening.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
"David Shorthouse" <davidshorthouse@shaw_SPAM.ca> wrote in message
news:en*************@TK2MSFTNGP12.phx.gbl... Hello folks,
I have a problem with an update query on an asp not updating the table in an Access db. The code runs, I have no errors, but when I examine the table, nothing was updated. The query works as it should in Access. Could anyone direct me to some sources that describe solutions to what is likely a common problem? The strange thing is, I have another update query for a different db on an asp that works just great. Is there something I may have neglected to do for the db itself whose update query on an asp doesn't seem to work? Security issue?
Thanks for any ideas,
David
David,
I assume you are doing this in ASP? In which case, I would repost to
m.p.i.asp.db with a bit more detail, like some code for example.
As it stands we would be hard push to help you other than by guessing.
Chris
"David Shorthouse" <davidshorthouse@shaw_SPAM.ca> wrote in message
news:en*************@TK2MSFTNGP12.phx.gbl... . . . an update query . . . not updating the table in an Access db. The code runs, I have no errors, . . . The query works as it should in Access.
Are there any wild-card characters in your SQL?
Something like :
Delete From X
Where KeyField Like 'Z*'
The wildcard character for just about everything /other/ than
Access is "%".
HTH,
Phill W.
In my fiddling around, I think I solved it by really scrutinizing my code. I
had no idea that the "Where" parameter should be at the end of the string of
parameters for the Data Connection to the update query.
Dave
--
______________________________
Remove "_SPAM" to reply directly. I have a problem with an update query on an asp not updating the table in an Access db. The code runs, I have no errors, but when I examine the table, nothing was updated. The query works as it should in Access. Could anyone direct me to some sources that describe solutions to what is likely a common problem? The strange thing is, I have another update query for a different db on an asp that works just great. Is there something I may have neglected to do for the db itself whose update query on an asp doesn't seem to work? Security issue?
Thanks for any ideas,
David
If I understand you correctly, the key to determining the parameter order is
to test the query in Access. You should supply the parameter values in the
same order that Access prompts you for them when you test the saved query.
It has nothing to do with how you name your parameters (p1, p2, etc.) It's
all about the order in which they appear in your sql statement. The best way
to determine the proper order is to test the query in Access and keep track
of the order in which you are prompted for the values.
HTH,
Bob Barrows
David Shorthouse wrote: In my fiddling around, I think I solved it by really scrutinizing my code. I had no idea that the "Where" parameter should be at the end of the string of parameters for the Data Connection to the update query. Dave
I have a problem with an update query on an asp not updating the table in an Access db. The code runs, I have no errors, but when I examine the table, nothing was updated. The query works as it should in Access. Could anyone direct me to some sources that describe solutions to what is likely a common problem? The strange thing is, I have another update query for a different db on an asp that works just great. Is there something I may have neglected to do for the db itself whose update query on an asp doesn't seem to work? Security issue? Thanks for any ideas,
David
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Gotcha. I had no idea that the order was important.
Thanks.
--
______________________________
Remove "_SPAM" to reply directly.
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e4*************@TK2MSFTNGP09.phx.gbl... If I understand you correctly, the key to determining the parameter order is to test the query in Access. You should supply the parameter values in the same order that Access prompts you for them when you test the saved query. It has nothing to do with how you name your parameters (p1, p2, etc.) It's all about the order in which they appear in your sql statement. The best way to determine the proper order is to test the query in Access and keep track of the order in which you are prompted for the values.
HTH, Bob Barrows
David Shorthouse wrote: In my fiddling around, I think I solved it by really scrutinizing my code. I had no idea that the "Where" parameter should be at the end of the string of parameters for the Data Connection to the update query. Dave
I have a problem with an update query on an asp not updating the table in an Access db. The code runs, I have no errors, but when I examine the table, nothing was updated. The query works as it should in Access. Could anyone direct me to some sources that describe solutions to what is likely a common problem? The strange thing is, I have another update query for a different db on an asp that works just great. Is there something I may have neglected to do for the db itself whose update query on an asp doesn't seem to work? Security issue? Thanks for any ideas,
David
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: kalamos |
last post by:
This statement fails
update ded_temp a
set a.balance = (select sum(b.ln_amt)
from ded_temp b
where a.cust_no = b.cust_no
and a.ded_type_cd = b.ded_type_cd
and a.chk_no = b.chk_no
group by...
|
by: Philip Boonzaaier |
last post by:
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums...
|
by: Mike Leahy |
last post by:
Hello all,
This question is related to updating tables - is there any way to calculate or
update the values in a column in a table to the values in a field produced by
a query result? An...
|
by: Steve Jorgensen |
last post by:
Hi all,
Over the years, I have had to keep dealing with the same Access restriction -
that you can't update a table in a statement that joins it to another
non-updateable query or employs a...
|
by: dp |
last post by:
After looking and looking, it appears that Access ADPs graphic query
designer won't display:
update customer
set = .
from customer,
where customer. = .;
It comes up with the "Query...
|
by: Randy Harris |
last post by:
I imported records into a table, later found out that many of them had
trailing spaces in one of the fields. If I'd caught it sooner, I could have
trimmed the spaces before the import.
This...
|
by: Maxi |
last post by:
There is a lotto system which picks 21 numbers every day out of 80
numbers.
I have a table (name:Lotto) with 22 fields (name:Date,P1,P2....P21)
Here is the structure and sample data:
...
|
by: ARC |
last post by:
Hello all,
So I'm knee deep in this import utility program, and am coming up with all
sorts of "gotcha's!".
1st off. On a "Find Duplicates Query", does anyone have a good solution for...
|
by: giovannino |
last post by:
Dear all,
I did a query which update a sequence number (column NR_SEQUENZA) in a table using a nice code (from Trevor !).
1) Given that I'm not a programmer I can't understand why...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |