LiveCode Forums

dglass wrote:You should be able to find it in my profile.

I can use the CONTACT US form on your website.

I will be working on this program this weekend and this week, so I will ask you questions as I get stuck.

Thank you SO MUCH for your help!!!

Mike

To get around the problem, I intend to use .htaccess to limit who can use the software. This is ONLY for my client and perhaps one or two of their employees, so it will not be distributed to the masses at all. Because of this, I can either use .htaccess or build in a username/password capability to ...

Thanks Klaus.

I will probably need hints like this a lot as I delve deeper into MySQL programming in Live Code.

Mike

Great! Thank you. What chat client? I cannot seem to post email addresses or links yet. What is your email address?

Mike

Not sure what you mean?

Mike

Hello all.

Now that I know how to populate controls with data, I need to figure out how to create the right queries. Is there anyone available to help me? The database is already set up and working, this is for reporting only. No updating or new records will be created.

Mike

'quote' is equivalent to the double quote character (ASCII 34). Thank you. That did it. For anyone who needs it, here is the correct code: put "select Recruiting_Company_Address from RecruiterData where UserName = " "e & the selection "e into newselection put newselection into theQuery put ...

I pretty much have it figured out - but I need one more piece of help from someone. Here is what needs to be in the query: SELECT Recruiting_Company_Address FROM RecruiterData WHERE UserName = "mikerecruiter" Now, how do I enclose mikerecruiter in quotes programmatically? Here is what I have: put "s...

After your combo selection you'll need to do something like: SELECT <<whatever data you need>> FROM <<whatever tables you need>> WHERE UserName <<or whatever field is in the other tables>> = '" & the result of your selection & "'" Then do whatever you are going to do with the returned data. Thank y...

I have been able to login to the remote server's MySQL database. I have been able to do a simple query and put the result into a combo box. Now, I need to go way further. The end result needs to be the following: List all the Recruiters in the table RecruiterData (select UserName from RecruiterData)...

Bangkok, I followed your advice, logged into the cpanel and put my IP address in the appropriate place. I have been able to login to the hosted vps server's mysql database as a result. Now, since I and my client have DHCP routers/modems, the IP address physically entered will eventually expire. How ...