How Do I Define An Array Datatype

how do i define an array datatype I want to insert double datatype values in it.

View Replies


ADVERTISEMENT

Define Variables

I 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:

View Replies View Related

Validation Of Define Serial No

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

View Replies View Related

Define A Simple Function

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?

View Replies View Related

Define Excel Cells

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 ?

View Replies View Related

Define Session Variables

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.

View Replies View Related

Howto Define Height And Width Of A Page In The Link?

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 Related

Memo Datatype

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

View Replies View Related

SQL Text Datatype

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?

View Replies View Related

Sql Server Datatype

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?

View Replies View Related

NText Datatype

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.

View Replies View Related

Datatype Issue

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 Related

Unhandled DataType

I'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 Related

Datatype Error

I 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.

View Replies View Related

Question On Datatype To Use

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:

View Replies View Related

Problem With SQL On Datatype Bit

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?

View Replies View Related

What Is The ADO Constant For Text 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 Related

MySQ Timestamp Datatype

If 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?

View Replies View Related

How To Convert One DataType To Other Using The CType Function?

How do I convert one DataType to other using the CType Function?
and can you show some examples......

View Replies View Related

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 Replies View Related

Displaying Currency Datatype From Access

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?

View Replies View Related

How To Check The Value Of A Varialble With The Currency Datatype?

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?

View Replies View Related

Setting An Image Datatype To NULL

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.

View Replies View Related

Error Converting Datatype Varchar To Bit

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 Related

Aspupload Response.Binary Retrieve Image Datatype

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"))


%>

View Replies View Related

Rebuilding Of An Array From An Existing Array

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.

View Replies View Related

Array Integers Vs Array Variables

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:

View Replies View Related

Create A New Array From An Array

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?

View Replies View Related

Array In Sql

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.

View Replies View Related

Array

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)?

View Replies View Related

Array

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

View Replies View Related

ASP Array?

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:

View Replies View Related

Array

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?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved