single quote in database field....

vijay garg · #1 (**permalink**) 05-29-04, 03:46

Hi All,
I am creating array in ASP from field in database.

like:

arr_hm_name[i] = OraDynaset("HMName")

I am filling array throu loop (1..recordcount)
When there is single quote in name field. This line is giving error.
Does anyone have faced such prolem. What's the solution...

Thanks

ASP-Hosting.ca · #2 (**permalink**) 05-30-04, 18:21

What is the error?

rokslide · #3 (**permalink**) 05-30-04, 19:07

From what I can see there is nothing obvious that would cause a problem. What is the actual error or perhaps the rest of the code that goes with the snippet you have given....

Seppuku · #4 (**permalink**) 06-01-04, 11:43

For one thing, array's in ASP don't use [brackets]. They use (parenthesis):

arr_hm_name(i) = OraDynaset("HMName")

rokslide · #5 (**permalink**) 06-01-04, 19:20

good spotting seppuku, I've been writing javascript too long it would appear.

Seppuku · #6 (**permalink**) 06-01-04, 19:23

I have a hard time keeping it straight myself.. going between ASP, JavaScript, Perl, and a host of other languages that handle them all differently, it requires quite a bit of mental discipline... I keep reference guides for them all... even though I know the languages, it those minute details that sometimes get me hung up the worst...

rokslide · #7 (**permalink**) 06-01-04, 19:56

Yeah, and arrays that start from 1 instead of zero and other stupid things like that...

You know what would be cool.... a consortium or standards committee for programming languages....