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 TouchToneTommy 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: *

  • Users: OldSmelly
  • Content: Threads
  • Order by date
  1. OldSmelly

    Strange Behaviour on a network

    Hi all, I have a realy strange problem.. My exe is running for a couple of years now without a problem but since a couple of weeks the users are getting errors like "variable not found" empty views etc etc.... It's even more stranger that they don't get it every time, sometimes days go by...
  2. OldSmelly

    Special chars in a databasefield

    Hello All, I have a problem with a field on the screen (and in a mysql database).. Here in the netherlands we have names like "in 't veld" as lastname and here it goed wrong.... If I redisplay the field for example after a validation function the field display "in \'t Veld" I have tried...
  3. OldSmelly

    POSTDATA

    Hi All, I have a system where the user can query a database, this wil show up on the screen and the user then can click on a "record" (wich is actualy a link made up) and the system then transfers to a detail page with more information on the record. But when the user comes back to the screen...
  4. OldSmelly

    Linking to a specific record from a query

    Hi All, I have a Mysql database from wich I can query and put the results on the screen by means of PHP. So far so good :D But I would like to be able to click on one of those records and go "deeper" into that record. I want tp display in a other screen for example more data from that record...
  5. OldSmelly

    Find out the ID issued in a auto-increment field in Mysql

    Hello, I have search but not found an answer to my problem. I connect to a Mysql database and add some data to tables by means of a remote view. How do I know what ID has been given to my records since the field is and auto-increment field? The database is a heavy used one so changes are that...
  6. OldSmelly

    Sending a pdf with cdo mail

    Hello, I have a routine that sends mail to my mailserver (sendmail under linux) with attachements and it works fine except when the attachement is a PDF file. Then I get the follow error OLE IDispatch exception code 0 from CDO.Message.1: The specified protocol is unknown. Anyone have a clue...
  7. OldSmelly

    Remote view on Mysql server

    Hello, I have a very strange problem, I have a view in foxpro 9 to a mysql databaseserver with myodbc 3.51.12. When I run this view in de manager all runs fine but when I run it in the exe file and I do a requer of the view it alywas says "view defintion has been changed" and the program stops...
  8. OldSmelly

    Input validation

    Hi all, I have a form where the user can input some data ie name adress etc. It works great but I wan't to do some validation like teh name field must be filled out. If a user press submit then a warning should be given preff without leaving the form. Is this posible and how ? Thanks Hans
  9. OldSmelly

    Confirmation Emails

    Hello, As with so many websites I want to send the user a confirmation email with a link to a activation page as the user changes his login credentials. Does anyone know how do to create these links ? I have a fare idea but just can't put my finger on it. Thanks in advance Hans
  10. OldSmelly

    Return values from a pulldown

    Hello all, I have the following problem, I have a pulldown in my form with all the countrycodes. I populate the pulldown from my mysql table and present it to the customer. So far so good. But If the customer changes the country code via the pulldown it doesn't change and the variable will be...
  11. OldSmelly

    Security

    Hello, On some website you have to key in a code from the screen in order to "proof" that your not a bot. Most of the time it's a picture of numbers and letters in some sort of pattern. I have no idea what's it called in english but I hope that you know what i mean. And if someone can help with...
  12. OldSmelly

    export to excel data

    I'm on fire now :D I have searched this form and come up whith this litle script to create a excel-sheet. But what it does it actualy creates a file with the jpg in it from my header ?? very weird I think Anyone got a idea function create_excel_file($querystring) { $file="test.xls"...
  13. OldSmelly

    Limit records on screen made up by a table

    Hi all, I have created a script where the user can choose to query the database. I devided the screen my means of a table into 2 parts. I want to display the result of the query in the second part of the table. So far so good BUT i want to be able to "browse" through the data. I tried to...
  14. OldSmelly

    MD5 32 bits encryption

    Hello, I have created a secure website using php and Mysql where the passwords are encrypted with the MD5 hashing methode. In php this wil result in a 32 bits length key. Now I whan't to upload data from foxpro into this table but foxpro hassn't got a MD5 hash. I have searched the net but only...
  15. OldSmelly

    Fields from more records into one record

    Hello Again, Is there a way to put the fields from multiple recors into one record. Let me explain what I mean.... I have created a table with the sql inner join command so the dest table can have multiple record for any given idnr (the join) But my client whant's to have a excel sheet with...
  16. OldSmelly

    Report with more then one child table

    Hello, I want to print a report with one parent table and 4 child tables ... Does anyone know how to do this ?
  17. OldSmelly

    Strange Behaviour SQLEXEC

    Hello All, When i run these lines of codes CLOSE ALL CLEAR ALL SQLDISCONNECT(0) gcOdbcConnect="cOdbc" STORE SQLCONNECT(gcOdbcConnect) TO gnOdbcHandle SQLEXEC(gnOdbcHandle,"Select * from kpnawgrp where ISNULL(opzegdatum) or EMPTY(opzegdatum) or opzegdatum > DATE()","vLedenTotaalStatistiek") *...
  18. OldSmelly

    Storing Word information

    Hi All, Last week ik asked a question what the best way was to store Word information(letters) in a foxpro table.. Up until now I stored it in a general field but this is not the way to go because of the problems with general fields so One person said you could store it in a memo field or as...
  19. OldSmelly

    The Best Way to attach/insert documents

    Hello, I have been struggeling with the following problem for some time now and I hope you guys can give me some pointers. I have a administration programm for fundraising where I want to be able to store the documents I send to this members so I can see what documents are send to them and...

Part and Inventory Search

Back
Top