Click here to Skip to main content
15,895,084 members
Home / Discussions / Web Development
   

Web Development

 
Questionsome help about arrays in javascript Pin
JUNEYT7-Sep-06 6:14
JUNEYT7-Sep-06 6:14 
AnswerRe: some help about arrays in javascript Pin
led mike7-Sep-06 8:21
led mike7-Sep-06 8:21 
QuestionSending Complex data across webservice Pin
BlueKooZZZZZZZZ6-Sep-06 23:19
BlueKooZZZZZZZZ6-Sep-06 23:19 
AnswerRe: Sending Complex data across webservice Pin
CWIZO7-Sep-06 1:06
CWIZO7-Sep-06 1:06 
GeneralRe: Sending Complex data across webservice Pin
BlueKooZZZZZZZZ7-Sep-06 4:52
BlueKooZZZZZZZZ7-Sep-06 4:52 
QuestionIIS Thread Pool going down Pin
Alsvha6-Sep-06 19:54
Alsvha6-Sep-06 19:54 
QuestionText/large varchar fields in SQL server Pin
pseudomorph6-Sep-06 18:27
pseudomorph6-Sep-06 18:27 
AnswerRe: Text/large varchar fields in SQL server Pin
Guffa6-Sep-06 21:37
Guffa6-Sep-06 21:37 
This is not a "periodic" problem that occurs sometimes. It's by design, and there is nothing unpredictable about it. Once you know how it works, you also know how to handle it. Smile | :)

The data for blob fields are not fetched along with the regular result, instead they are sent in a separate stream. As they are sent in a stream, they have to be read in the exact order that they come in the stream. If you read them out of order, the stream will skip to the item that you requested and the skipped items are discarded.

The value is read from the stream when you request it, and the value is not retained in the current record data in the recordset. That means that you can only read the value once from the recordset. That is why you have to read the value into a variable if you want to use it more than once.

The blobs are sent in the same order as you specify them in the select statement, that's why you shouldn't use "select *".


---
b { font-weight: normal; }

GeneralRe: Text/large varchar fields in SQL server Pin
pseudomorph7-Sep-06 7:30
pseudomorph7-Sep-06 7:30 
AnswerRe: Text/large varchar fields in SQL server Pin
Guffa7-Sep-06 8:17
Guffa7-Sep-06 8:17 
GeneralRe: Text/large varchar fields in SQL server Pin
pseudomorph7-Sep-06 9:15
pseudomorph7-Sep-06 9:15 
AnswerRe: Text/large varchar fields in SQL server Pin
Guffa8-Sep-06 7:07
Guffa8-Sep-06 7:07 
GeneralRe: Text/large varchar fields in SQL server Pin
pseudomorph8-Sep-06 10:09
pseudomorph8-Sep-06 10:09 
QuestionWindows 2000 Server not serving up PDFs Pin
Vodstok6-Sep-06 9:27
Vodstok6-Sep-06 9:27 
AnswerRe: Windows 2000 Server not serving up PDFs Pin
Edbert P6-Sep-06 16:03
Edbert P6-Sep-06 16:03 
GeneralRe: Windows 2000 Server not serving up PDFs Pin
Vodstok7-Sep-06 2:50
Vodstok7-Sep-06 2:50 
QuestionI need help to solve a error on my form Pin
bobolov6-Sep-06 5:19
bobolov6-Sep-06 5:19 
AnswerRe: I need help to solve a error on my form Pin
Paddy Boyd7-Sep-06 0:24
Paddy Boyd7-Sep-06 0:24 
GeneralRe: I need help to solve a error on my form Pin
bobolov8-Sep-06 8:22
bobolov8-Sep-06 8:22 
QuestionAttacking http [modified] Pin
militiaware6-Sep-06 3:34
militiaware6-Sep-06 3:34 
AnswerRe: Attacking http Pin
CWIZO7-Sep-06 1:04
CWIZO7-Sep-06 1:04 
QuestionMicrosoft Expression Web Pin
Sam Heller6-Sep-06 3:26
Sam Heller6-Sep-06 3:26 
AnswerRe: Microsoft Expression Web Pin
Kevin McFarlane6-Sep-06 4:54
Kevin McFarlane6-Sep-06 4:54 
Questionhow to develop a web based biometric application Pin
zubairy5-Sep-06 20:44
zubairy5-Sep-06 20:44 
Questionproblem on capturing the browser close event Pin
gtechrohit5-Sep-06 19:52
gtechrohit5-Sep-06 19:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.