Textbox changes .t. string to 1.0 1

[Rutsagig]

I have a textbox to insert email address to mysql database.
Last day, entering an address like john.t.smith@gmail.com, I notice it saved it as john1.0smith@gmail.com.
It understand .t. and .f. as true or false, and change it to 1.0 and 0.0.
How could I solve this?
Thanks

 

[GriffMG]

DO WHILE ATC("(.t.",lcConsulta)>0
	lcConsulta=STUFFC( lcConsulta,ATC("(.t.",lcConsulta),4,'(1.0')
ENDDO 
DO WHILE ATC(",.t.",lcConsulta)>0
	lcConsulta=STUFFC( lcConsulta,ATC(",.t.",lcConsulta),4,',1.0')
ENDDO 
DO WHILE ATC("(.f.",lcConsulta)>0
	lcConsulta=STUFFC( lcConsulta,ATC("(.f.",lcConsulta),4,'(0.0')
ENDDO 
DO WHILE ATC(",.f.",lcConsulta)>0
	lcConsulta=STUFFC( lcConsulta,ATC(",.f.",lcConsulta),4,',0.0')
ENDDO

Something like the above should sort the INSERT INTO

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Rutsagig]

Thanks GriffMG, I added that and this too:

DO WHILE ATC(" .t.",lcConsulta)>0
	lcConsulta=STUFFC( lcConsulta,ATC(" .t.",lcConsulta),4,',1.0')
ENDDO 
DO WHILE ATC(" .f.",lcConsulta)>0
	lcConsulta=STUFFC( lcConsulta,ATC(" .f.",lcConsulta),4,'(0.0')
ENDDO

Because it has some queries like:

SELECT *
FROM CLIENTS
WHERE .T.

And if I don't change this '.T.' it doesn't work

 

[GriffMG]

You would drop the WHERE altogether in those cases

SELECT * FROM CLIENTS

is the same as

SELECT * FROM CLIENTS WHERE .T.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Chris Miller]

For other databases than VFP, when you absolutely want a universal WHERE .T. replacement, then take WHERE 1=1.

Chriss

 

[GriffMG]

Ricky, I think you have done what I did, not read the question...

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Mike Lewis]

Ricky, I think you have done what I did, not read the question...

Actually, Griff, this was a rather weak attempt at spamming the forum. As you can see, Ricky has now been expunged (and from other forums as well).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[GriffMG]

Ah, I did wonder, his code being PHP rather than VFP...

Thanks for the heads up.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​