How Do I Define An Array Datatype
how do i define an array datatype I want to insert double datatype values in it.
View Replieshow do i define an array datatype I want to insert double datatype values in it.
View RepliesI want to make a dynamic comparison in order to find out all the duplicates in the table. Becuse the data is not so tidy, and sometime the strings have a little difference but still a duplicate, I don't compare with this field.
In this case, I have to select those fields that don't have so much confusion.
In short, I have a table containing field1, field2 ... fieldn :' "n" is a variable I want to make a comparison to next record by the fields selected, NOT all.
For example: Code:
how to validate the serial number in numerical format like this:06-02-01-xxxxxx
the code i try to use was as below but cannot be done:
Form_serial_no= request.form("serial_no")
If IsNumeric(Form_serial_no)=0 OR InStr(Form_serial_no,"-")=0 Then
Response.write "<br>*Serial Number in wrong format"
Validated_Form =False
End If
I just want to define a simple function in ASP with three parameters, like this:
function outputReport(type, values, categories)
' do something
end function
but unfortunately I get the following error:
Technical Information (for support personnel)Error Type:
Microsoft VBScript compilation (0x800A03F2)
Expected identifier
/eu_softing/raport.asp, line 24, column 22
function outputReport(type, values, categories)
---------------------^
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.40607)Page:
GET /eu_softing/raport.aspDoes anybody know what is wrong?
I get data out of a database and the user can save this data on his disk in Excel format.
Some cells has a large lenght of numbers (eg. 20060512000000). If I open the excel file, the cell where that number is in shows the following : 2.00605E+13.
I have to go into Format Cell and convert this to 'Number' and no decimal places. Is there a way in ASP to define the cells ?
I'm trying to define session variables using the following code:
Session("Employee")= [value]
when i replace the Session with Application, the value is available across all the pages, but the session variables are only available on the page i declare them. Is this a coding or a server issue.
Is possible to define height and width of a page that I want to open with an HREF link on a blank page?
View Replies View Relatedthis 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 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'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 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"))
%>
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
i want to excute given logic
select * from Product_Table where Product_Code in
ARRAY
i.e i want to select Product_Code from VB array and not from a query
is it possible.
I know I can do this programatically using a loop but I thought there might be
some easier or more effective way.
I am trying to invert an array.
i.e.
array1 = 1,2,3,4,5
but I want to get
array2 = 5,4,3,2,1
Is there something like array2 = invert(array1)?
I have to following code:Code:
dim arrRes(9),getal,som
arrRes=Array(4,4,4,4,4,5,5,5,5,5)
for getal=0 to 9
som=som+arrRes(getal)
next
response.write("Het klasgemiddelde is " &som/10)
I get a type not match error on the second line
I have a page in my admin system where the user can edit products they
have added. The problem I am having is with Related Products. These are
all listed in a multiple list. What I need to do is have those selected
when the product was added, already be highlighted in the multiple list
on the product edit page. Here is my post from another forum.
Code:
For some reason, when I try to run the following array, I'm getting an
error:
dim cat(0)
cat(0)="0407"
cat(1)="0102"
'I will be adding more to this array, but just trying with two for
starts.
for counter = 0 to 1
itno=cat(counter)
'I get an error when it runs through this function
Function rightvar(theVar,lengthNeeded)
Dim sResult
sResult=theVar
if Len(theVar)< lengthNeeded then sResult= String(lengthNeeded -
Len(theVar)," ")& theVar
rightvar=sResult
End Function
Can someone help me understand why?