Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. avikohl

    is email synch with inbox only?

    I'm a newbie palmer using a m130. I use Eudora 5 and find that the palm email program that came with it gets the emails in the Eudora inbox when I do a hot synch. Is there a program that synchs with other the other mailboxes I have in Eudora, particularly the outbox and to other data such as...
  2. avikohl

    better to use find method of rs object or sql filtering?

    Thank you for your very informative answer. By the way. How do you measure how long a segment of code takes to execute?
  3. avikohl

    better to use find method of rs object or sql filtering?

    I notice that people write logn scripts with the find method of the recordset object. Isn't it better to filter with a WHERE clause in the query and test login with value of myRecordSet.eof? My assumption is that the find method of the recordset object is scrolling throug all the record, which...
  4. avikohl

    importing data to a query

    The problem is I don't know the first thing about writing macros. so I think what I'll do is import the data into a table, write an asp script that assigns the imported table to a recordset, and scrolls down the record set inserting the data into the the existing tables by executing sql insert...
  5. avikohl

    importing data to a query

    Thanks. That sounds like good advice. I'll try it. What I'm confused about is that with asp and ado you can create recordsets based on queries and when you update those recordsets the tables, upon which the select query was based, get updated. So I figured you could do the same thing in Access.
  6. avikohl

    importing data to a query

    I need to import data from a text file to an access2000 db. The text file is obviously in a flat format, ie non-relational and the access file is relational. I thought that if I create a query which displays all the data in the two related tables I would get the same data structure as the text...
  7. avikohl

    book store db design

    Thanks for your comments. Your last paragraph, Rob, confirms my second option, which I am now leaning towards. As far a ISBN is concerned, I don't think its going to function as a key for every single item that I will have in the data base. Its just one piece of data that I will record for most...
  8. avikohl

    book store db design

    Here is a specific question about how I should represent a real life situation with database design. The book list I'm working with has many examples of book titles shared by many books where there are many different parameters which may differentiate between them and some of those parameters...
  9. avikohl

    textstream object not working

    Would it work without the dll If I write instead write set ObjTextS=objFs.openTextFile(file,1,0) ?
  10. avikohl

    textstream object not working

    Having trouble getting text stream object to work on local iis server. The following code results in no response to the browser and subsequent requests to the website after this code is run also get no response from the website until iis is reset. The set ObjectTextS line is the culprit. When...
  11. avikohl

    critique my online bookstore db design

    Just took a look at some marerial on the Duamish project at the msdn library. I couldn't find was most interested in; a diagram of the db tables and relationships. But I will be taking a look at the material there... Thanks for pointing me there. It looks quite interesting. Being originaly...
  12. avikohl

    critique my online bookstore db design

    Thanks for your comments. I am aware of the problem of storing credit cards on a website db and have a plan to protect the privacy of my customers. This isn't really what I meant by critique of the db design. But while we are on the topic, can you recommend a company for processing online credit...
  13. avikohl

    critique my online bookstore db design

    Here are the tables that store information about website users, mainly customers, their accounts, login keys, group affiliations, discounts, primary addresses and shipping addresses. One thing I wasn't sure about was whether or not to store discount information in the users table in addition...

Part and Inventory Search

Back
Top