itw_peter
Posts: 6
|
| Posted: 05/28/2009, 10:24 AM |
|
Hi,
If a text field is empty, CC ASP code will write a NULL into the database.
I need it to write an empty string instead of a NULL into the database.
How can I achieve that?
Thank you in advance.
Regards,
Peter
|
 |
 |
Edd
Posts: 547
|
| Posted: 05/28/2009, 4:13 PM |
|
Use he custom insert (SQL) or stored procedures.
I have one supplier who does this all the time and it really bites.
Cheers Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
davidwoo
Posts: 53
|
| Posted: 05/28/2009, 8:31 PM |
|
I think it's depend on yr database setup, I am using ASP/MySQL 5, the default value for the text set to empty string, numeric set to 0...etc.
BR
|
|
|
|
Edd
Posts: 547
|
| Posted: 05/28/2009, 9:07 PM |
|
My experience is MSSQL / Sybase and MSAccess - look at the code in the Common class but I think you will find that it converts to NULLs if the data field is empty.
Cheers - Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
peterr
Posts: 5971
|
| Posted: 05/28/2009, 11:42 PM |
|
Hi,
This doesn't depend on database if you use the first solution provided by Edd - the "If parameter is empty" option in Custom Insert.
This is standard CCS feature therefore should work the same with all databases.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
itw_peter
Posts: 6
|
| Posted: 10/20/2009, 10:34 AM |
|
Hi,
I tried using this piece of code in the events page:
If len(form1.account_sub_no.Value) = 0 then
form1.account_sub_no.Value = " "
End If
It still inserts null.
But if I use a space like this: form1.account_sub_no.Value = " " , then it works.
Is there a way to insert empty string rather than a space?
Any help will be appreciated.
Thank you in advance.
Cheers
Peter
|
|
|
|
musarrataziz
Posts: 2
|
| Posted: 10/21/2009, 4:56 AM |
|
Function Customer_DataSource_BeforeExecuteInsert
if len(Customer.name.Value)<1 then
Customer.DataSource.CmdExecution=false
end if
End Function
'' Hope you can Understand this..
_________________
Musarrat Aziz
Software engineer |
|
|
|
itw_peter
Posts: 6
|
| Posted: 10/21/2009, 9:40 AM |
|
Musarrat,
Thanks for your reply, however, that does not work for me.
Your solution will simply not insert the whole record.
What i need is that it inserts all the fields, with that particular field set to empty string.
Thanks.
|
|
|
|
ReneS
Posts: 225
|
| Posted: 10/22/2009, 2:37 AM |
|
Hi,
Got this from: http://forums.devshed.com/net-development-87/how-to-ins...rce-494170.html
So maybe this works: When designing your tables, SQL Server allows you to replace nulls with a default value on insert. Make your fields non-null in your database, and give them an empty string for a default value.
Hope it helps.
Rene
|
|
|
|
