Escaping characters for FileMaker queries

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Escaping characters for FileMaker queries

Dale Abrams
Hello,
I have a login form that I'm trying to get to work with a FileMaker datasource. The problem I am having is that when a username or password has a special character in it (@, #, etc), it is processing them as operators, rather than literals. Is there some built in function that will automatically escape these operators with a backslash? What is the best route here?
Thanks,
Dale



#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Escaping characters for FileMaker queries

Doug Gentry-2
In your FM database you can change how the text field is stored. See Define database, fields, options. I forget the actual value at the moment but one of those storage options will give you want you want. It then also becomes case sensitive I believe.

...Doug

Sent from my iPad
541-261-8501
plain-sense.com

On Apr 9, 2013, at 2:10 PM, [hidden email] wrote:

> Hello,
> I have a login form that I'm trying to get to work with a FileMaker datasource. The problem I am having is that when a username or password has a special character in it (@, #, etc), it is processing them as operators, rather than literals. Is there some built in function that will automatically escape these operators with a backslash? What is the best route here?
> Thanks,
> Dale
>
>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Escaping characters for FileMaker queries

Dale Abrams
In reply to this post by Dale Abrams
Thanks for your reply Doug. I was able to get around it by adding in some search/replace lines to escape out the special chars that FM uses as as search operators.



#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Escaping characters for FileMaker queries

Seth Ganahl
In reply to this post by Dale Abrams
Easiest way to do this is put the FileMaker exact match operators in your
inline:

Inline,
  -Database='my_db',
  -Password='my_pass',
  'email'='=="'+$email+'"',
  'password'='=="'+$password+'"',
  -Search;
/Inline;

This is the same as typing =="username" and =="password" in a FileMaker
search.


On 4/9/13 4:10 PM, "[hidden email]" <[hidden email]> did quoth:

> Hello,
> I have a login form that I'm trying to get to work with a FileMaker
> datasource. The problem I am having is that when a username or password has a
> special character in it (@, #, etc), it is processing them as operators,
> rather than literals. Is there some built in function that will automatically
> escape these operators with a backslash? What is the best route here?
> Thanks,
> Dale
>
>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>   the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

-------------------------------------------------------
Seth C Ganahl (501) 282-4867
Ganahl Consulting ­ Web Applications
http://www.ganahlconsulting.com/
[hidden email]
-------------------------------------------------------



#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>