|
I have read that there can be a periodic problem when reading large varchar or text fields from SQL server (or memo fields from Access) using ASP--they can sometimes come up as empty strings. (See http://www.aspfaq.com/show.asp?id=2188.)
What I have been unable to find out is whether this problem is still around in recent versions of MDAC (>= 2.8). Does anyone know whether this problem still occurs--is it still necessary to follow the steps in that aspfaq article?
|
|
|
|
|
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. 
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; }
|
|
|
|
|
That makes sense to me, but the reason why I'm wondering about it is because I have been using SELECT * with varchar(5000) fields without a problem. If I am understanding you correctly, this should not work if x is a large varchar (5000) field:
Set rs = conn.Execute("SELECT * FROM [tablename] WHERE [ID] = 30")
Response.Write rs("x")
Response.Write rs("x")
But for me it does print the contents of x twice. Do you know why this would happen?
|
|
|
|
|
Because varchar is not a blob field.
---
b { font-weight: normal; }
|
|
|
|
|
OK, so am I correct in thinking that none of these problems occur with varchar fields (only text fields)? The aspfaq article (link in original post) had mentioned that varchar columns with a length greater than 255 also had the problem; is this incorrect?
|
|
|
|
|
You only have these limitations for blob fields. Depending on the database or database driver, large varchar fields might actually be implemented or returned as blob fields, but I have never used one that does it that way.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for all of your help! How can I find out if my database/database driver is implementing large varchar fields as blobs? (I'm just connecting to SQL Server using SQLOLEDB.)
|
|
|
|
|
I am basically looking to see if anyone s familiar with configuring iis on a windows 2000 server to serve up PDF files, or if there is somehting that mayhave been turned on/off to prevent it.
it runs some aspx pages that output to pdf, but as far as the server is concerned, these are aspx files. it is up to the browser to determine the output format. however, if i try pointing to an actual pdf in a known web directory, i get "The page cannot be found"
any ideas?
______________________
Mr Griffin, eleventy billion is not a number...
|
|
|
|
|
If you're serving a PDF from an ASPX file, you must set the mime type before writing the file to the page, e.g.:
Page.Response.Clear();
Page.Response.AddHeader("Content-Disposition", "attachment; filename=[yourfilename]");
Page.Response.ContentType = "[your file type]";
Page.Response.OutputStream.Write(buffer, 0, length);
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin
Edbert
Sydney, Australia
|
|
|
|
|
It serves pdfs from aspx files just fine. it seems to run normal web formats with no issue, even if they are outputting another format in the browser. the weird part is that any non-web standard file will not display at all. Basically, the standard web graphics and page formats work (htm, jpg, aspx, etc), and as long as that file extension is present, the file will load, but anything else (pdf, exe, doc) wont. i checked and no extra security has been added. its very confusing.
Luckily, these are only dev servers, but it makes me nervous to push anything to a production machien that i cant prove beyond a shadow of a doubt in dev.
______________________
Mr Griffin, eleventy billion is not a number...
|
|
|
|
|
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/Poonam/login.asp, line 40, column 148
Content = Content & "
Full name: "
<%
'Green colorset
'BackgroundColor="#C9DDB3"
'BorderColor="#006600"
'Blue colorset
BackgroundColor="#AFD1F8"
BorderColor="#000080"
'Purple colorset
'BackgroundColor="#FDC8F2"
'BorderColor="#800080"
Content = "" 'Clear the Content string
QStr = Request.QueryString("login") 'Save the login querystring to QStr
if ucase(left(QStr,6))="CREATE" then
Title = "Register"
else
Title = "Login"
end if
'The code below saves the contents the table must have in the variable Content
'The content depends on what's in the QueryString
if QStr="passfailed" then
Content = Content & "Wrong password Back"
elseif QStr="createpassfailed" then
Content = Content & "Wrong password Back
Cancel registration"
elseif QStr="namefailed" then
Content = Content & "Invalid username Click here to create an acount
Back"
elseif QStr="createnamefailed" then
Content = Content & "Invalid username Back
Cancel registration"
elseif QStr="creatednew" then
Content = Content & "Your account has been created Login"
elseif QStr="createnew" then
Content = Content & ""
Content = Content & "
Username: "
Content = Content & "Password: "
Content = Content & "
Full name: "
Content = Content & "
Country: "
Content = Content & "
Email: "
Content = Content & "
Question: "
Content = Content & "
Answer: "
Content = Content & ""
Content = Content & ""
Content = Content & "I agree to the Hi5 Terms of Service"
else
Content = Content & ""
Content = Content & "
Username:"
Content = Content & "Password: "
Content = Content & ""
Content = Content & ""
Content = Content & "Forgot Password"
Content = Content & "Click here to create an acount"
end if
%>
<title>ASP Login
function checkCapsLock( e ) {
var myKeyCode=0;
var myShiftKey=false;
var myMsg='Caps Lock is On.\n\nTo prevent entering your password incorrectly,\nyou should press Caps Lock to turn it off.';
// Internet Explorer 4+
if ( document.all ) {
myKeyCode=e.keyCode;
myShiftKey=e.shiftKey;
// Netscape 4
} else if ( document.layers ) {
myKeyCode=e.which;
myShiftKey=( myKeyCode == 16 ) ? true : false;
// Netscape 6
} else if ( document.getElementById ) {
myKeyCode=e.which;
myShiftKey=( myKeyCode == 16 ) ? true : false;
}
// Upper case letters are seen without depressing the Shift key, therefore Caps Lock is on
if ( ( myKeyCode >= 65 && myKeyCode <= 90 ) && !myShiftKey ) {
alert( myMsg );
// Lower case letters are seen while depressing the Shift key, therefore Caps Lock is on
} else if ( ( myKeyCode >= 97 && myKeyCode <= 122 ) && myShiftKey ) {
alert( myMsg );
}
}
// End -->
<%
Response.Write("")
Response.Write(Content) ' Paste the contents in the table
%>
Send Us Your Suggestion On the Site
Bobo
|
|
|
|
|
You can't wrap stuff over lines like this:
Content = Content & "needs closing quotes and a continuation...
|
|
|
|
|
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif) thank u paddy for helping me out... ...
|
|
|
|
|
Hello guys.
can anyone give me some support.
i'm searching for 2 days but i didn't find some real help
i want to learn how to attack a site, or search engine.
because i built a web application which is a seach engine.
and i want to test it from being attack.
So, ......some resources guys.
and thanx
-- modified at 10:54 Thursday 7th September, 2006
Faris Madi
Nothing Comes Easy (N.C.E.)
|
|
|
|
|
Ok, you need to write some proper English if you'd like some proper anwsers...
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Afternoon,
I just received this link from a friend who sits close to Microsoft.
http://www.microsoft.com/products/expression/en/web_designer/default.mspx
I'm sure most have you have heard of Expression but the lattest release of it has just gone live today.
What confuses me though is how does this fit into the grand scale of things. Do i drop Visual Studio or use it with this?? It seems to do most of the design work far better but I'm not even sure if you can add any programming to your projct using it.
Clue me up people...
www.mrjonfree.co.uk
|
|
|
|
|
From
http://www.microsoft.com/products/expression/en/expression_faq.mspx#q3[^]
How do the Microsoft Expression products interoperate with Microsoft Visual Studio®?
Each of the Microsoft Expression family of tools can be used together with Visual Studio for collaborative designer/developer workflow. Expression Graphic Designer provides output in a variety of industry-standard graphic formats (such as JPEG and PNG) for incorporation into Visual Studio projects, and designs can be saved as XAML, the markup language that describes user interface elements and media for the Windows Presentation Foundation.
Expression Interactive Designer shares the same project files as Visual Studio, and can pass both XAML and VB.NET/C# code back and forth between the applications so that designers can design the look, feel and behavior of the user interface. Developers can add functionality and build and deploy.
Expression Web draws on site functionality and Web services created in Visual Studio, and both products can be used collaboratively between designers laying out pages and developers building back-end functionality. ASP.NET 2.0 code and controls are fully compatible, and the design preview surface within both products is identical so that designers an
Kevin
|
|
|
|
|
I want to know that is that possible to develope a web based bio metric application , if yes then please send me some helpful links / material about that.
with regards,
umair zubairy
|
|
|
|
|
I need to capture the browser close event( when user clicks the 'X' button on top right) to confirm from the user if he wants to save the data on current page. I am able to capture the event by window.obeforeunload = ConfirmOnClose(this is name of function). Now when the user clicks on "Yes" to save the data, i use the method __doPostBack to call the server method to save my information. The problem i am faced with now is that a Default Message Box of window also prompts up to ask the user
"Are you sure you want to navigate away from the page.
Press Ok to continue or Cancel to stay on the current page."
This message box is not needed and i want to supress it.
I have tried to do window.opener='', but that also doesnot help.
I am using Asp.net 2.0 environment.
I need it very urgent. All suggestions will be highly appreciated.
i am pasting the code for reference:
function ConfirmOnClose()
{
if(window.event.clientY < 0 && window.event.clientY < -80)
{
if(Page_ClientValidate())
{
var result = confirm("Do you want to save the data in the form?")
if(result)
{
__doPostBack('ibtn');
}
}
}
}
Rohit
|
|
|
|
|
Hi
I am using system.web.mail
i have 6 dropdownlist in my page. user can select value from all 6 drop down list.
each drop down list selection will send email to relevant department.
if the drop down is not selected it should not send email to particular department when its dropdown is not selected
i dont know how could i do this
i used if else clause but it seems its not picking up those email address. my code below
If ddEurambieCCC.SelectedValue <> Nothing Then
msgMail.To= "webadmin@abc.com"
End If
If ddCastleGlenCCC.SelectedValue <> Nothing Then
msgMail.To = "ccceller@abc.com"
End If
If ddExcelsiorCCC.SelectedValue <> Nothing Then
msgMail.To = "cccepark@abc.com"
End If
If ddEllermanCCC.SelectedValue <> Nothing Then
msgMail.To = "cccexave@abc.com"
End If
If ddNRocksCCC.SelectedValue <> Nothing Then
msgMail.To = "cccnrock@abc.com"
End If
it only picks the last one i dont know how could i work this out
please help
-- modified at 1:04 Wednesday 6th September, 2006
|
|
|
|
|
Hi
AS per my understanding your problem is that you have to send the email to all the mail address which are selected in 6 dropdown list. If 5 of them are selected then you have to send 5 mails.
If that is the case then you have to create one mail object for each selected droupdown and then in each if condition you have to send the mail for each mail address if the values are selected.
Please let me know
Regards
Tushar kothari
|
|
|
|
|
Cant we actually add to CC with single mail object for eg.
if ddSelectone.selected <> nothing then
mailobj.CC = 'abc@test.com'
end if
if ddSelecttwo.selected <> nothing then
mailobj.cc = 'abc1@test.com'
end if
and so forth
please advise. why my this logic isnt working
|
|
|
|
|
|
Hi
Im very much a beginner with Asp.
I have a site that I would like to open an edit, but what ide is best? Tried Vs studio by just going >Open Project but cant get access to any of the files.
Used Visual Web Developer but when I view a page with browser an error occurs saying This type of page is not served. And it has been explicitly forbidden.
Please if someone could point me in the right direction. Would greatly appreciate it.
|
|
|
|
|
Are you trying to use ASP or ASP.NET (which version)?
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
