Search results for query: *

forgot to mention it uses views....

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

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

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

No that was exactly what I mean but your code didn't change anything I still see the id in the link. Maybe I need new glasses but I don't see anything different in your code except that teh a href part is in a different place...

What's the diff in your example and my code then except the /a before /td and the a href in a diff place ?

Yes it works... But I see what you mean Have no idea what you mean by a wrap around ?

OK it's working like a charm.... $Ret .= "<TD><a href=\"displaypage.php?id={$row['idnr']}\">{$row['idnr']}</TD> <TD>{$row['sexecode']}</TD> <TD>{$row['voorl']}</TD>...

Thanks... How stupid of me....

Ok I hit a snag.. I display my data in a a table so I have addepted the example accordingly (or so I hoped)... What wrong with this code inside the while loop $Ret.="<TD> <a href=\"displaypage.php?id={$row['idnr']}\">{$row['achternaam']}</TD>\n>";

Thanks... Im gonna give that a try :D

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

That only applies to VFP tables... I have managed to get the webmaster to add some fields to the tables wich I will fill with a key so I can retrieve the correct record... Hans

Well that could be the answer to my problem I will ask the administrator of the website I he can put a new field in the database so that I can put my own key in theire --> Problem solved :D I don't worry to much about database traffic because it is on a very fast machine and internet...

Sorry to come on a bit strong theire ;) Mike, that might be just the answer and I will give this a try in the morning (it's evening here in holland). Thanks everone and I will post my results here Hans

Soory to sound a bit harsh But you all keep talking about requery, I CAN'T REQUERY because I have no KEY to ensure me that I get the correct record !!!!!! And I can't do it on the frontend either because it's not my Mysql server !!!!!

What I mean is... When you do a requety() just to get 1 record you need a keyfield to ensure you just get 1 record. And that keyfield is the ID and I don't know what that field is. When you do a requery() on the mysql table whitout a keyfield you just get all the records in that table. Hope...

Hmm Why can't I edit my repsonse ? When you do a requery() wihout the keyfield you will get all the data from that table into your vieuw !!! (as expected)

filles must be filled :D

I don't think that this will work because the vieuw is filles whith every data except the key field because that will be filled in by the mysql database. So how can you do a requery if you don't know the key field ? Hans