Changing Ordinal Position And Datatype
Does anyone know how to change the ordinal number of a field and the field datatype in Access using ASP?
View RepliesDoes anyone know how to change the ordinal number of a field and the field datatype in Access using ASP?
View Replieshow to change the ordinal number of a field and the field datatype in Access using ASP?
View Replies View RelatedError Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
i donno what's happenning but this code is working already but i can't search for my data... but i can see it inside the database.
Anyone come across this error before? Its responding to <%=rs("FIRM")%>, but I have it declared in a sql statement in the code. Any ideas? Code:
<%
Set cst = Server.CreateObject ("ADODB.Connection")
Set RS = Server.CreateObject ("ADODB.Recordset")
DBpath = server.MapPath("../../../NHITADATABASE2.mdb")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBpath & ";"
cst.Open strConn
mysql = "SELECT lname, fname, email, firm, import_pro, export_pro, title, city, st, email, regions, country, website, address1, address2, zip, languages, product_service_description FROM NHITAmembership"
'Set rs = MyConn.Execute(mysql)
%>
I'm running a stored procedure that inserts a record into a table then
returns the Identity field value. I've done this kind of thing plenty of
times in the past, but I'm obviously doing something wrong this time..
I've tested the Stored Proc in QA and it works fine. The SQL code runs OK in
ASP (iAffected = 1 which shows the record is inserted), but when I try to
query the resulting recordset, I get an error:
"Item cannot be found in the collection corresponding to the requested name
or ordinal. " Code:
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......
Using 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'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.
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'm querying a table and the column has 6 positions. I need to check if the 5th position is a 2,3,6 or 7. If so I want to set a variable = "Y". Can someone help me out with this?
View Replies View RelatedI am using position feature for images...although its placing the image on the HTML file using the top left corner of the image. Anybody know how to make it use the center of the image?
<img src="image.gif" style="position: absolute; left: 54; top: 34">
I have a access db and I want to pull some info out of it with VBScript. How can I specify a starting record?For example, I want to start at the 15th record and pull everything beyond that out.
View Replies View RelatedWhen a page is opened is there a way to set focus of the cursor to a named input. I want the cursor to be in the input box when the page is opened.
View Replies View RelatedAfter I read in a value from a table i need to read in the last letter of the value and check if it has an "s" as its last letter, so that i can display either ' or 's.
Does anyone know how code to view the last letter of the value or move the variable into javascript so that I can manipulate it from their?
I've just gone to Google and there's a link saying "add world cup live
scores..."
I clicked on that link and there are a whole lot of boxes containing content
that I can pick up and drag around, changing their relative position on the
screen.
Fantastic - but how do they do this (were can I read up on this?)
I have been working on this site for the last couple of weeks and i am now in the process of testing and have found a problem.
Basically it is on my jscript function. I have written that if the value is >= 2000 do something else do something else, which is fine with the exception that the value isn't always going to go up in 1000's (sometimes it will be 1-10 others 500-5000 others 1000 - 10000[these values are generated within select tags]).
Basically i am wanting to know is there any way that i can use the select tag to work out the position from within the tag. For example if the position >= 2nd in list do this else do something else.
I have put serveral panel controls within a page, each of them matching to a action defined by buttons, so I want to fix all panels in one place( they already have same size, but different left, top values), how can I do it (in code, if I do it in desgn, is there a way to put the panels in different "layers" so the contained controls will not interupt with each other)?
View Replies View RelatedI use an array of elements and I want to know the position of a given element in my array
I know the filter function that allows to determine if the element i look for is in the array but this function doesn't allow me to know its position.
how do i find the occurence and position of a variable in a csv string. e.g. how do i find "hello" in hi,who,where,how,hello,greetings,xmas,etc. The starting position and if it occurs ? I tried using instr but cant seem to get it right.
View Replies View RelatedFound 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"))
%>