Drew Wutka
DWUTKA at marlow.com
Tue Apr 1 17:48:18 CST 2003
Ya, just email me at dwutka at marlow.com Drew -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Tuesday, April 01, 2003 5:18 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Search archives Hi Drew: Just a question while we are on the subject; is your site set up to accepting query strings yet? Could you display the value received if it is not null or it's length is greater than zero? (For temporary debug purposes...) Maybe we could discuss this further, off-line as it is straying very close to totally list off-topic... Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco Sent: Tuesday, April 01, 2003 12:10 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Search archives: was Access 97 - Numeric field overflow I just got curious and pasted the HTML from your post into a page on my local machine. When I click search I get to your page but that's it. I can post the code on a web server if you want to see it but it's really nothing more than you posted below. Jim DeMarco -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: Tuesday, April 01, 2003 2:52 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Search archives: was Access 97 - Numeric field overflow What's the page you are trying this from? (So I can take a look at it.) Drew -----Original Message----- From: Jim DeMarco [mailto:Jdemarco at hshhp.org] Sent: Tuesday, April 01, 2003 6:58 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Search archives: was Access 97 - Numeric field overflow Drew, All this does is load your search page with no values loaded. Should it load the value passed in "SearchString" and/or perform the search too (just curious)? Thanks, Jim DeMarco -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: Monday, March 31, 2003 6:48 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Access 97 - Numeric field overflow Okay, here's what you should have: <form name="doesntmatter" method="POST" action="http://www.wolfwares.com/AccessD"> Search: <input type="text" size=25 name="SearchString"> <br> <input type="submit" name="Search" value="Search"> </form> The IP Address you have was with my old ISP. Just use the domain name. (Right now, going to www.wolfwares.com will swap to an IP Address in your browser (trying to get that fixed....), but the path works fine. Also, you want the method to be Post, so it sends the information through as a form. Drew -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Monday, March 31, 2003 5:27 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 97 - Numeric field overflow Drew: Yes I am... here is the code fragment from the search Form tag: ... <form name="search" method="get" action="http://207.13.30.36/AccessD?SearchString=SearchString"> ... You should be able to receive and manage the query string variable 'SearchString'. There might be so other issues but this is the sending syntax. I have never had a chance to actually test the process of transferring a query string to a remote site but this is the setting as read. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Monday, March 31, 2003 3:04 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Access 97 - Numeric field overflow Actually Jim, are you putting this into an HTML form? If so, can you just name the 'search' button 'Search', with a value of 'Search', and then the 'textbox' name as SearchString (as you have it). Right now, my ASP page looks for that value for the submit button, to do the search. Drew -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Monday, March 31, 2003 4:28 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 97 - Numeric field overflow Hi Drew: I was not trying to imply you should get on to the archive issue. I was just stating an observation. While we are on the subject, could you set your index page to check for an incoming query strings, named 'SearchString'; I think it is variable name you use. If the value is null, display normally else, fill SearchString variable from the contents of the received query string 'SearchString' and process the search. I guess the content/memo field should be the default field for searching? What do you think? This will/should only be a short-term fix until a more permanent home for the archive can be found. Thank you so much for all your work and effort. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Monday, March 31, 2003 1:51 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Access 97 - Numeric field overflow Okay, the archive will be fully available sometime very early Wednesday morning. I was working on writing the new ASP interface (well, the code behind it), and discovered that my indexer was chopping off the last letter of each word it was indexing. Long story. So after fixing that bug, I had to re-index the Memo fields. At 2 pm today, it had indexed 10,000 records (a little more...but close enough), and I 'restarted' the indexer last night at 3 am. So in about 11 hours it did 10,000, there are about 40,000 records in the database, so it's going to be about 33 hours from 2 this afternoon. (Also, the searching is there, just not totally complete....it'll take me a few hours to finish up the pages themselves, probably do that tonight) Drew > -----Original Message----- > From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] > Sent: Monday, March 31, 2003 3:22 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Access 97 - Numeric field overflow > > John: From someone on this list...need the archive. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] > Sent: Monday, March 31, 2003 12:28 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Access 97 - Numeric field overflow > > Nope, just starting to append records. And where did you get 65K > records maximum? > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] > Sent: Monday, March 31, 2003 1:47 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Access 97 - Numeric field overflow > > Hi John: > > You have not exceeded the maximum of 65000 records by any chance? > > Just a thought > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] > Sent: Monday, March 31, 2003 9:09 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Access 97 - Numeric field overflow > > In fact I was just appending the same data twice. I have a unique > index on a combination of fields that should prevent the data from going > in a second time. This was just a test of that index to make sure the > data would not go in again. > > In fact though the user may end up importing several different > files, one after another. The entire process is to ask the user to find > the file, copy it to a specific file name in a specific directory so that > the link works correctly, copy the original to a backup directory, then > run the append queries to get the data out of the spreadsheets and into > the table. From there a "all records in the previous" and "all records > NOT in the previous" will be run for reporting purposes. > > It shouldn't matter what I am doing though. If it runs once, it > should run a million times. It may very well come back and say "X records > could not be appended..." because of the unique index, but it should NOT > give me this "numeric overflow" error. According to help that means that > "the data is too big for a btrieve field" or some such. IOW, one of those > useless error messages. The fact that the data actually imports makes it > even more suspicious. > > I just don't want to send out work that pops up useless error > messages and has to be exited and reloaded in order to work. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Wortz, > Charles > Sent: Monday, March 31, 2003 11:11 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Access 97 - Numeric field overflow > > > JC, > > You got me confused when you say "The append process works the first > time it is run, then the second time, I get a Numeric Overflow." > What > are you doing the second time? Appending the same data to the same > records, or appending some other data to some other records, or > what? > > Charles Wortz > Software Development Division > Texas Education Agency > 1701 N. Congress Ave > Austin, TX 78701-1494 > 512-463-9493 > CWortz at tea.state.tx.us > > > > -----Original Message----- > From: John W. Colby [mailto:jcolby at ColbyConsulting.com] > Sent: Monday 2003 Mar 31 10:01 > To: AccessD > Subject: [AccessD] Access 97 - Numeric field overflow > > Guys, > > It's been awhile since I have dealt with A97. I am doing an import > of > data from excel spreadsheets. The data in the spreadsheet is a dbl > datatype, but is really a long int, i.e. no decimal points. I am > linking the spreadsheet, whereupon I see that the datatype of the > field > is dbl. I build a base query that runs these fields through a > clng() to > convert them to long integers. I then append the data into a table. > The append process works the first time it is run, then the second > time, > I get a Numeric Overflow. I get the overflow between the "you are > about > to..." warning and the "X records did not append..." error. In fact > that second error never occurs. Once the error occurs, I have to > shut > down the db and re-open it, whereupon the query will run > successfully > one time, then the error again. > > I am at SP2 for A97, and I don't remember what the latest SP is for > A97. > > Has anyone ever seen this problem? > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > ---------------------------------------------------- > Is email taking over your day? Manage your time with eMailBoss. > Try it free! http://www.eMailBoss.com << File: ATT00050.txt >> << > File: ATT00097.txt >> > > ---------------------------------------------------- > Is email taking over your day? Manage your time with eMailBoss. > Try it free! http://www.eMailBoss.com << File: ATT00125.txt >> << > File: ATT119867.txt >> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com **************************************************************************** ******* "This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". **************************************************************************** ******* _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com **************************************************************************** ******* "This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". **************************************************************************** ******* _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com