>Doubled quotation mark works for me. In any case, if you use SqlCeParameter,
>the provider will escape the string for you correctly.
>By the way, what is the error you are getting?
An unhandled exception of type
'System.Data.SqlServerCe.SqlCeException' occurred in
System.Data.SqlServerCe.dll
I ended up discovering that my function to add the extra quote, while
it was being called fine, and was returning the correct value, it was
not updating the one that is used in the SELECT statement. *redface*.
Cheers for your help, without following the train of thought I did as
a result I doubt I would have found the problem so quick.
Re: Wrong sintax...? GOT IT! ... > It's a lot easier to use command object with parameters. ... Then the provider... > will escape anything that needs to be escaped for you. ... >> string into the field you would have to make the string ... (microsoft.public.data.ado)
Re: java.util.Properties extending from HashMap ... It's sort of useless to speculate why Sun did that, since everyone over there admits it was a mistake for Properties to inherit from Hashtable. ... Given the simplicity of the code fix, plus the ability to compile using "-source 1.4" until the source can be corrected, I would bet that Sun would consider the benefit of additional error checking to outweigh the inconvenience of source changes during the developer's transition to Java 5. ... You cannot make conclusions about how to use Provider based on Properties' documentation, and you cannot make conclusions about Properties based on Hashtable's documentation. ... either an or a <String, String> version, and the parameters are never cast - the raw type accepts Objects only. ... (comp.lang.java.programmer)
Re: Custom membership provider problem ... user wizard and someone said I should switch to custom membership provider.... >>An error has occurred while establishing a connection to the server. ...>>Boolean& failoverDemandDone, String host, String failoverPartner, String ... (microsoft.public.dotnet.framework.aspnet)
Re: Can ASP.NET 2.0 Use SQLServer 2000 For Membership Function ... from the IIS admin tool (setting the conn string and membership provider) ... with a sql 2000 database in the back and IE7 ... that the Web App Admin Tool shows when it cannot connect to the database. ... Create a connection string to your ... (microsoft.public.dotnet.framework.aspnet)