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!

Register Log in
  • Congratulations Chriss Miller 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. shamsm

    Data Entery using a web interface

    Sorry about the vague post at the begining. You are right I didn't include all the details as I should have. The script I am looking for doesn't matter if it is ASP or php, all I want it to do is to enter data in to the fields of a mysql table (just one table in the DB), I prefer not to have...
  2. shamsm

    Data Entery using a web interface

    why would I be kidding! I am aware of phpMyadmin but that is to complex and it might effect the integrity of the DB if I let every tom dick and harry use it. I just thought that there may already be a ready made script that some one has used and that they might recommend that just enters the...
  3. shamsm

    Data Entery using a web interface

    Hi I was wondering if any body has stumbled across a script/code that allows data entry on to a mysql table using a webpage, and wouldn't mind sharing it with me. Many thanks M
  4. shamsm

    Exclussion

    Hi I would like to exclude a value from list of variable values from an SQL expression. Let's say I have a list of categories and I want all of them to be shown except one how can i do that? The values are numerical. Many Thanks
  5. shamsm

    Stock on a Query

    Thanks for your response, I manage to cracj it eventualy, as you mentioned in one of your posts I finally decided to incorporate an ASP code in the page which will do the mutipliction using the Euro value from the property tableand the CER from the cer table. Thanks for all your time and...
  6. shamsm

    Calcullation using code and mysql fields

    Can a calcullation be done in a web page using ASP where let say field1 is multiplied by field 2 from a certain mysql table? What code would one use? Thanks
  7. shamsm

    Stock on a Query

    Thanks for your reply. I am using ASP, I have looked at running a second query but its kind of difficult relating the prices to the properties(it becomes all jumbled up), as I can't think of a way to incorporate the CER primary key(id) into the property table. I was also thinking along the...
  8. shamsm

    Stock on a Query

    I am designing a property web site, using mysql on dreamweaver, I have four tables, one with property details, one with property location, one with property type and another with current exchange rates. As you can probably see from the query below I have managed to creat a recordset with...
  9. shamsm

    Is this possible?

    Your suggestion does make a lot of sense. I would like to give it a try, the problem I have though is that I would like to implement this on to a web site having never done any calculations on mysql, I would appreciate if you could let me know what would be the best way to start? Thank you fopr...
  10. shamsm

    Is this possible?

    Hi I would like to know if it's possible to have a field data calculated based on the data of another field. Let's say I have a Euro column which I enter data into directly but I would also like to have USD and GBP columns, is there a way where I can add a formula so that when I enter data into...
  11. shamsm

    ADODB.Fields (0x800A0CC1)

    I managed to sort the problem out it wasn't the code, It was the WYSIWYG editor meesing things about, when I started over it all worked fine. Thanks for trying Cheers Mehdi
  12. shamsm

    ADODB.Fields (0x800A0CC1)

    I think this is the code you mean Thanks for your reply <% set Rslts = Server.CreateObject(&quot;ADODB.Recordset&quot;) Rslts.ActiveConnection = MM_connSqlproperty_STRING Rslts.Source = &quot;SELECT property.*,location.Location,proptype.PType FROM property,location,proptype WHERE...
  13. shamsm

    ADODB.Fields (0x800A0CC1)

    Hi I am developing a website using ASP VB Script, I was using an Access Database to begin with but then decided to switch over to MySQL as I found out was some what superior. After swaping over the recordset I keep getting the following error, do you think that the error could be due to the...
  14. shamsm

    Linking MS Access 2000 to MySQL server

    Thank you for that, I managed to link my database. Regards
  15. shamsm

    Linking MS Access 2000 to MySQL server

    Hi I would like to link an Access 2000 DB to a MySQL Server which is connected to UltraDev, I know how to export tables but I need to know if the two can be linked in any way so the data is updated simultaneously, I need this as the site I am creating requires regular update. Regards

Part and Inventory Search

Back
Top