I'm updating a record by opening a recordset, setting the fields and the
updating it with objRS.Update.
I need to set an image datatype to NULL. objRS("field") = NULL works for
datatypes int and varchar but not for datatype image, although there is no
error - the image field still contains the image!
I'm using SQL server and running an UPDATE statement including image = NULL
works.
Found that the code offered by aspupload to retrieve image datatype needs to be altered to work with MS SQL whereas it works fine with MS Access.
The following piece of code has the BinaryWrite executing prior to the ContentType request:
<%
' AspUpload Code samples: filelist_download.asp
' Invoked by filelist.asp
' Copyright (c) 2001 Persits Software, Inc.
' http://www.persits.com
' The file must not contain any HTML tags, not even HTML comment tags <!-- ...-->
' Build ADO connection string
Connect = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(".aspupload.mdb")
' If you use SQL Server, the connecton string must look something like this:
' Connect = "Provider=SQLOLEDB;Server=MYSRV;Database=master;UID=sa;PWD=xxx"
Set db = Server.CreateObject("ADODB.Connection")
db.Open Connect
SQL = "SELECT * FROM MYIMAGES where id = " & Request("id")
Set rs = db.Execute( SQL )
If rs.EOF Then Response.End
' Send actual file
Response.BinaryWrite rs("image_blob")
Response.ContentType = "application/octet-stream"
' Let the browser know the file name
Response.AddHeader "Content-Disposition", "attachment;filename=" & Trim(rs("filename"))
' Let the browser know the file size
Response.AddHeader "Content-Length", CStr(rs("filesize"))
%>
I have an interesting situation that needs to be addressed ASAP.
I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned.
The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever.
In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null.
I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.
this is really urgent and i cant seem to figure this out.I have his text area, once the user hits the save button, it tranfers the data to a memo datatype field in the database.
ok here's the thing...every time I copy paste something, this thing throws up a wierd error..:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '('text here....
I initially though it would ahve been becuase of the number of characters, but that was not the case.When i type things in and save , e'thing works fine
I just modified a SQL table field's datatype from char to text to accomodate
more text, and suddenly the results are not being displayed on my webpage.
Has anyone encountered this before?
I just stumbled into something which kinda of makes sense but I'm not 100% sure about.
I have a field as nvarchar.
I had the sql checking it: select blar from blar where blar = 0
weird thing is in the enterprise manager DTS the query parsed as ok. Overall the DTS failed because it came across some characters it said it couldn't handle.
The query changed to: select blar from blar where blar = '0'
and everything worked fine from there on.
---
What I'm wondering is, can nvarchar accept numeric values as well as string values?
if it can then the above all makes sense, if it doesn't... have I just found a bug?
I m updating a table which contains a field with datatype=ntext.
I use a stored procedure to insert/update data in it.
SP's parameter's data type is ntext.
Following is the code in which i created the parameter.
Code:
SET objParam1 = objComm.CreateParameter("@xmltempSrc",adLongVarChar,adParamInput,1073741823,txtXmlConte nt)
objComm.Parameters.Append objParam1
when i execute it, it give error as :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type text to ntext.
I m using Sql server and ASP.
i am having a small problem here i use sql server 2000 and in it the fields datatype is money i am displaying some items and here is how i do Code:
View Replies View RelatedI'm getting an error message "An unhandled data type was encountered." No line number, no nothing. Any ideas on what to look for?
View Replies View RelatedI have my code like this
checkintime="07/13/2006 5-6pm"
Set rs = Server.CreateObject("adodb.RecordSet")
strsql = "Select * From ProfTime WHERE Time1 ='" & checkintime & "'"
rs.Open strsql, conn, 2, 2
getid=rs("Prof_Id")
Time1 field is of varchar datatype
When i run the code it gives me an error saying
Microsoft VBScript runtime error '800a000d'
Type mismatch.
I need to write a function that takes four inputs and returns a value based on that.
For example, the inputs are name, country, state and city.
I have 25 rows and 5 columns of data. The data would be like this.
Jay, USA, CA, san francisco, san mateo, san bernadino, oakland, berkeley
Mike, Canada, Ottawa, montreal, toronto, edmunton, niagara, london
if the input values are jay, usa, ca, san mateo- the function needs to return
the next value in the row which is "san bernadino".
If I could store these values in the database, I could just write a query that
would give me the output. But don;t want to make a trip to the database. Code:
I have a problem to use the bit field, I know that accept the value 0 like false and -1 like true.
When I do the insert into and i put value -1 i receive an arror, if i put 1 and i try to read no the database i receive ever the value false. How can i correctly use this datatype?
I have a table (MSSQL 2000 server) with a column called "Content" whose datatype is text. Now I'm trying to insert data into the table using a stored procedure. What is the ADO constant that I should use to insert value into that column? Code:
View Replies View Relatedhow do i define an array datatype I want to insert double datatype values in it.
View Replies View RelatedIf execute the following sql on my MySQL database -
sqlremove = "UPDATE fib_note SET fib_note_actdone = 1 WHERE fib_note_id = '" &Request("id") &"' "
It seems to also be effecting another field in my table called fib_note_timestamp which is a timestamp data type with a default value of current_timestamp. How come and how can I stop this?
How do I convert one DataType to other using the CType Function?
and can you show some examples......
Does anyone know how to change the ordinal number of a field and the field datatype in Access using ASP?
View Replies View RelatedUsing ASP, I'm fetching a currency datatype from an Access database. When displaying the results, it shows "2" instead of "$2.00"
I know about FormatCurrency, but if the datatype is currency, should it not come out looking like currency?
I encountered a problem where I am retrieving a field from a recordset that is in the Money datatype and I then store it into a variable, exampe;
cur_BBOAmount = rsgetBBOAmount("BBO_Amount")
I am now trying to see the contents of cur_BBOAmount but nothing is showing up. In my if statements, I checked against blanks, I checked if it was zero, and I checked if it was Null, but nothing seems to work. I checked the variable type using response.write typename(cur_BBOAmount) and that returned the Currency datatype.
My question is, how can I test the value of this variable that is of the currency datatype?
I am repeatedly getting the error message 'error converting datatype varchar to bit'. I am passing a varchar variable to a stored procedure (where it is also a varchar) and then trying to write it to a table (where it is also a varchar).
View Replies View RelatedI have a client who has had a ASP site with an Access database for several years. It stores information for the used cars on his lot. I have stored text in the database that points to the location of the image for each record. Each record will have a thumb image that is supposed to display in a list of vehicles available then the user can select an item from this list and a new page displays with the information and the regular size image. So far everything has worked fine exept for the display of the images which are stored in a separate directory called veh-photos. All I get are image place holders. I am using Dreamweaver 2004 and and Access 2000 for the database.
Following is the code to list vehicles: ....
1.I want to show a image file of type '.tif' in the browser window; for that I'm writting as ASP code page.
2.This '.tif' type image can be shown better with 'Kodak Image Control'.
3.To have this 'Kodak Image Control' on my code page I just add it's ..ocx to tool box and then drag it from 'Toolbox' to the page.
4.Now after dropping this control to the code it's type is getting changed to 'object' instead of type 'ImgEdit'(and I think this is the
reason I don't get correct result).
5.On one button's 'Onclick' event I'm calling a javascript function with which I'm setting a 'Path'and'Display' property of a control.
6.And want to show a image at location -- '..MFTDRCMF919685173-62.tif' which get shown in new browser window but could not get shown in that particular control. That means the path is correct, then what is the problem?
For better understanding of problem I'm pasting a following code which I've tried up till now......
..................................................
<%@ Language=VBScript %>
<% OPTION EXPLICIT %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT LANGUAGE=javascript>
<!--
function showpic()
{
var path;
path = document.frmtif.path.value;
alert(path);
document.frmtif.ImgEdit1.Image =path;
document.frmtif.ImgEdit1.Display;
window.parent.self.open(path);
}
//-->
</script>
</HEAD>
<BODY bgColor=#ffe4e1>
<form name="frmtif">
The Image
<P>
<OBJECT id=ImgEdit1 style="WIDTH: 409px; HEIGHT: 218px" type="ImgEdit"
align=left
border=1 classid=clsid:6D940280-9F11-11CE-83FD-02608C3EC08A
name=imgtif></OBJECT>
<input type="hidden" name="path"
value="..MFTDRCMF919685173-62.tif">
<input type="button" name="show" value="Show" onclick="showpic();">
</P>
</form>
</BODY>
</HTML>
..................................................
I am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
else
display default image - hardcoded in program
endif
I have had a go and come up with the attached but I get an error with my if statement...
I can convert an image that is retrieved from a FileUpload object into a byte array and insert it into the database..
When the user signs-up i wish tosimply insert into the Picture (DB Type = Image) field to an image i already have saved in my images folder?
Anyone know of a way to do this? Tutorials, articles or advise??!
I have created a table. How do I limit the result of that table to only show the entries that have the "address" filled in. In Access here is the sql coding to acheive the results.
SELECT Dropoffs.City, Dropoffs.StateInitials, Dropoffs.AcceptedItems, Dropoffs.MoreInfo, zipcodes.Address
FROM zipcodes, Dropoffs
WHERE (((zipcodes.Address) Is Not Null));
How do I set this up in my VBSCRIPT page?
Here is my working page so that you can see what I am trying to acheive. When the page comes up you can type 45255 for the zipcode.
I try to select the not null value from the database in column comment.
select s.ques_no, s.task_no, s.goal_no, g.comment from step_tab s, gen_tab g where s.id = g.id and g.comment is not null
But it still return all the null value.
Can anyone please tell me why?
Besides that, why i can't increase the number that i selected from the database.
id_no = rs("id_no")
id_no = cint(id_no") + 1
Why the id_no never increase even i had "+1"?
I might be doing this wrong but I am modifying the body tag depending on what a recordset tells me.
It works fine if the value exist, but if it is returned null then I can't get it to work ...
I had set up the following 'trouble-shooting' code to determine how a certain value was being 'evaluated' for lack of a better term. The field "status" in this example has no value in it.
<%
status = RS("status")
If isnull(status) Then
response.write("status is null")
end if
if status = "" Then
response.write("status has no value")
end if
%>
The database field 'status' has no value in it. If I run the above trouble-shooting code, the first statement "status is null" will print out. If I remove the first if statement and use the second if statement 'if status = "" ...', the statement will NOT print indicating that the value <> "".
Questions: What is the difference between something not having a value and NULL?
Most importantly, what is the PROPER way to check for a field not having a value in it? In the past I have always checked for a 'no value' using double quotes.
I'm using the following code to, firstly erase any old logins the user has. Then to check whether the page has been idle for longer than 30 minutes or not. If it has been idle for longer than 30 mins then the user will be required to input their password again. However it's not working! Code:
View Replies View RelatedMicrosoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15
What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?
how to check any value in asp that it is null or not.
View Replies View RelatedI have a condition that will run depending if a field in the database is NULL. It will not run at all, and I tried various way to write it but none works so far
'not working
If assignee = DBNull Then
'not working
If assignee = null Then
'not working
If assignee = "" Then
If I write assignee to the page then the value of assignee will write if it has a value and nothing if it is null.
I have a data entry form. If the user submits the form without entering any data, the record should be inserted with null entries for the respective fields.
But when i execute the INSERT SQL query with these null values, it gives me an error.
This is vat I am doing:
<%
.....
address = request.form("address")
if request.form("Age")= "" then
ageValue=""
.....
.....
%>
I use these values in SQL query
This is the SQL statement when the above is executed
" INSERT INTO tblStatistics (Age,address) VALUES (, aaa)"
Because of no value for age, the query is not gettin executed.
I dont want a 0, I want a nul entry (<null>).
Could someone throw some light on how to set the age field to null?