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 SkipVought 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. objuan

    Question about MSDE

    Thanks Perryf. The volume would be very low...a high estimate would be 10 consecutive users in the short-medium term. It sounds like it would be fine for this case, but I was hoping know at what point one would need to look at other options. And also to know when it could be considered for...
  2. objuan

    Question about MSDE

    I am wondering about any limitations that might be present with the use of MSDE (rather than SQL Server) for a low volume application. In reading some of the documentation, it appears that MSDE might be appropriate for this, but wanted to know if anyone has used it before for a production...
  3. objuan

    Return autonumber in Access like @@Identity

    Can anyone tell me how to return the AutoNumber from Access much like you can return the @@Identity in SQL?
  4. objuan

    Custom Namespaces/Best Practices

    I'm new to ASP.Net and I'm using some of the end-to-end samples to try to understand the framework. In looking at the IBuySpy Portal, most of the pages Import a Namespace called ASPNetPortal. This namespace seems to allow the use of Public Functions that are stored in component files, but I...
  5. objuan

    Rowset cannot be restarted

    This part is on the ASP page and calls the function Get Data Set rs = Server.CreateObject("ADODB.Recordset") Set rs= GetData(iOrgID, iAccountID) This is the function: '********************************************************************* Function GetData(ByVal iOrgID, ByVal...
  6. objuan

    Rowset cannot be restarted

    I have run into an error when trying to manage a Recordset that is being pulled by a Function that runs a Stored Procedure to a SQL DB using an ADO Command that executes the stored procedure by sending the parameters through. The RecordSet seems to be returning okay, but I can't seem to set the...
  7. objuan

    2 Functions Recordset Errors

    Thanks very much!!! The idea is to pull the users from the table and then filter to see if the userid already exists...if it doesn't, I'd like to Add the user to the table...via the Sub. However, I'm getting the error ...object doesn't support the property method on my attempt to filter...
  8. objuan

    2 Functions Recordset Errors

    1)I'm trying to pass a recordset back to Function 2...so parameters are sent from function 2 to function 1, function 1 builds a recordset and sends it back to function 2. 2)I'm trying to use a command object (in Function1) that runs a stored procedure in SQL to return the Recordset and then set...
  9. objuan

    2 Functions Recordset Errors

    I have two functions, both of which call on stored procedures to do certain things. Function 1 uses 2 parameters to build a recordset. Function 2 calls function 1 to assemble the recordset and then tries to filter that recordset as a check before doing anything else. When I call Function 1...
  10. objuan

    Topic of Discussion -- Cookies & Session

    Very helpful...given this discussion, does anyone have suggestions on the best way to check and notify a user that their cookies must be enabled for a site that requires cookies to maintain identity throughout a session...say in the case of a shopping cart.
  11. objuan

    What's your idea of designing an efficient shopping cart?

    ToddWW, Your explanation has been very helpful! I had a couple of questions on your recommendation. I was wondering why you suggest using an "altered" session identifier rather than the straight Session.SessionID from IIS. Is this to make absolutely sure that you don't have a...
  12. objuan

    Best Practices Importing Data Files to SQL

    Tarwn, Thanks for the insight...you hit on the point that I am wrestling with in terms of efficiency to get from point A to point B.(uploading the file, parsing the data, and getting it into SQL) Perhaps, a little more detail would be useful. First, the upload component is SAFileUp which...
  13. objuan

    Best Practices Importing Data Files to SQL

    I am looking at approaches to getting data from files (eg., xls, csv) that are uploaded by external users of a data driven site, imported into a SQL database, and then displayed to public. I am looking at the FileSystemObject as an approach to read the data out and then move to SQL with basic...

Part and Inventory Search

Back
Top