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. osensei

    MS Access shows #DELETED in result set

    I've just installed pgsqlODBC 7.03 on my workstation for use with MS Access (Access 97 on Windows ME). I'm connecting to a Postgres Sql Database on a Linux host. I guess I need help setting up the ODBC datasource in Access. When a add linked tables to the Access database I get mixed results...
  2. osensei

    MS Access shows #DELETED in result set

    I've just installed pgsqlODBC 7.03 on my workstation for use with MS Access (Access 97 on Windows ME). I'm connecting to a Postgres Sql Database on a Linux host. I guess I need help setting up the ODBC datasource in Access. When a add linked tables to the Access database I get mixed results...
  3. osensei

    Apache server cant started?

    Don't change 127.0.0.1 from localhost if that's what you have done. Create a new domain name (www.somedomain.com) and assign your webservers ipaddress to it in DNS. Then set your servername to the new DNS name in your httpd.conf. When DNS is running you should be able to access the site using...
  4. osensei

    force https for page when http entered

    Why not use mod_rewrite. This is how I do it on my site: RewriteEngine on RewriteRule ^/(*.)register\.jsp https://www\.myfoo\.com/register\.com This tells Apache to rewrite an URL that references a file name register.jsp to an HTTPS URL. Add a statement similar to this one to your httpd.conf...
  5. osensei

    Need help w/ Apache2+Tomcat4+SSL virtual hosts

    My Apache2 + Tomcat4 installation works fine, but now is the time for me to implement SSL. I've set up a vitual host on an aliased IP. The istallation is running the *.htm files but not *.jsp. What I'm trying to do is to build a secure shopping cart along with customer login, and checkout area...
  6. osensei

    Why GNU? A.K.A Just call me crazy!

    Not that I'm one to complain, but in a capitalistic USA I have problems understanding why anyone would want to get envolved in writing GNU licensed software. What's in it for them, or are they just another group who believe that stuff aught to be free? Now that that's out of the way what do...
  7. osensei

    Unique Indeces and null values

    Quite so! I guess I was thinking that x_id was the head of the index. As was noted earlier x_id is a separate primary key index. As a practice, I typically avoid allowing nulls in indexed columns. As mentioned by ceco nulls don't behave as one might expect when being compared to oneanother...
  8. osensei

    Unique Indeces and null values

    The rows that you have entered are unique based on your index specification. If your index key is indeed (a_id, p_id, c_id, g_id, and u_id) the no duplicate key violation should have occurred based on the data you provided. Can you provide more details as to the rules you want to apply to this...
  9. osensei

    SQL Query Question

    If I remember correctly from the old days of rule based optimizers you query would be processed as follows; select (sum(ac1.insertions) + sum(ac2.insertions) + sum(ac3.insertions)) as insertions, ac1.time_stamp from ac1, ac2, ac3 where ac1.time_stamp =...
  10. osensei

    Combos won't refresh in Access

    I not sure but I did get results by adding a requery in a procedure and referencing the proc from OnGot focus at the combobox in question. The problem now seems to be that neither OnGotFocus or any of the other events seem to fire with the frequency I like. Some fire too infrequently, leaving...
  11. osensei

    Combos won't refresh in Access

    Hi, I'm using MS Access to Postgres via odbc. The application in question makes use of the MS Access Tab Folder object. When new records are added to a particular tab's subform, they should be impacting the rowsources for combo boxes on the subsequent tabs. This is indeed the case, but only...

Part and Inventory Search

Back
Top