Hi Guys ,
can any one tell me how to insert array in database using insert statement.
thanks
sdhawan
-2
Junior Poster
Recommended Answers
Jump to PostWhat database are you using?
Jump to Postif u r using sqlserver, it should be easy.
Before sending it to database traverse the array and make a single string with array values in a "," or ":" then save the string as varchar into database. When u need to fetch the data u just have to break …
Jump to PostSaving arrays in a database as any kind of delimited field is usually not a good idea. The point of databases is normalization. Why don't you save the array as individual rows in …
All 12 Replies
finito
46
Nearly a Posting Virtuoso
mono_jit23
1
Junior Poster in Training
sknake
1,622
Senior Poster
Featured Poster
kvprajapati
commented:
Very good suggestion.
+10
sdhawan
-2
Junior Poster
finito
46
Nearly a Posting Virtuoso
sdhawan
-2
Junior Poster
sdhawan
-2
Junior Poster
finito
46
Nearly a Posting Virtuoso
sdhawan
-2
Junior Poster
sdhawan
-2
Junior Poster
finito
46
Nearly a Posting Virtuoso
kvprajapati
1,826
Posting Genius
Team Colleague
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.