473,320 Members | 1,993 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

problem entering data using a web form

109 100+
Hi all,

I am not sure this question will belong to a sql group or .net.

but the problem I have is, my data entry forms crashes when some enter a apostrophe character in one of the field. that field is of type varchar in sql server 2000.

for ex, Ryan O'neill will crash the application.

what should I need to do to allow user to add apostrophe and not to have application crash?

Please help it is very urgent.

Thank You,
Jan 23 '08 #1
3 1395
parshupooja
159 100+
I am tried using varchar and it works for me to enter apostrophe or any special character. You can try ajax filtered box so it won't let user enter any spcecial character

Hi all,

I am not sure this question will belong to a sql group or .net.

but the problem I have is, my data entry forms crashes when some enter a apostrophe character in one of the field. that field is of type varchar in sql server 2000.

for ex, Ryan O'neill will crash the application.

what should I need to do to allow user to add apostrophe and not to have application crash?

Please help it is very urgent.

Thank You,
Jan 24 '08 #2
kunal pawar
297 100+
Before enter your data in to database replace apostrophe by double apostrophe
for ex
str = "Ryan O'neill"

then
str = str.replace("'","''")

this will work.

Your allication crash at time of store entries in database coz
when you write query varchar field value enter enclose in apostrophe
like that

"insert into (name) values( '& str &' )"
after putting value i becomes

"insert into (name) values( 'Ryan O'neill' )"

this is problem due to apostrophe
Jan 24 '08 #3
arial
109 100+
Thanks kunal it worked.

thank you,
Jan 28 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: DataB | last post by:
Hi everyone! I have a forms problem. Bakground: I have created a number of tables. Of these, I have a main parent table (Personal Details) and a number of other child tables (Tax file No.,...
1
by: fc | last post by:
hi, i'm having a problem using C#'s lock and windows2000's text to speech (vtext.dll) ... basically it looks like the callback from the TTS is violating C#'s lock, which looks very very...
12
by: MeNotHome | last post by:
I need to be able to open up a URL and enter some data, press a button and then wait for the page to load and then click a check box and press another button. Is there a good example on the...
1
by: faiyeah | last post by:
Here is my database design: Entity ------ Publisher(, PubName) Author(, AuName) Sale(, Price, UnitOnHand) Book(, Title, BkType, PubCode)
7
by: Ron | last post by:
Hi All, Using Access2000, winXP. Table 1 = tblClients displayed on frmClients via qryClients. 2nd table = tblInvoices shown on frmInvoices via qryInvoices. 2nd table = tblDetails shown on...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a...
3
by: Robert Johnson | last post by:
Hi all. Created a simple table in my db. 3 colums one is a Int set for autoincrement. Itentity True, seed 1, Incremement 1, null False. The other colums are simple VarChar(50) null false on the...
4
by: dirk | last post by:
Hey, I'm new to php and I'm trying to write some php code so that I can insert data into a mysql database using html forms. I've got two text forms and a submit button. When entering data and...
2
by: robertns5411 | last post by:
I have two questions: 1) Say I have a form bound to a table. Assume the user is entering data into a new record at the bottom of the form. Now, suppose the user clicks a button on the form...
4
by: Neil | last post by:
Having trouble with inserting a record into a table. It's a list of names. But, for some reason, it won't take a particular name. When a user tries to enter a name into the table, the system hangs...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.