It has been a while since I've worked with this...
I have an Access database with Numeric fields. In my ASP code I'm
trying to use a variable to enter those numbers, such as
Insert into MyTable (Item, N1, N2) Values ('NewThing', v1, v2)
I have set v1 and v2 previously with numeric values but they are not
recognized. Do I need to wrap v1 and v2 in some sort of identifier,
such as "#"?
2  1258 
If v1 and v2 are variables, you have to concatenate them into your SQL
string.
sSQL = "Insert into MyTable (Item, N1, N2) Values ('NewThing'," & v1 & "," &
v2 & ")"
--
Ray at work
Microsoft ASP/ASP.NET MVP
"Earl Partridge" <ea*****@pearnet.com> wrote in message
news:u4*****************@newsread2.news.atl.earthl ink.net... It has been a while since I've worked with this...
I have an Access database with Numeric fields. In my ASP code I'm
trying to use a variable to enter those numbers, such as
Insert into MyTable (Item, N1, N2) Values ('NewThing', v1, v2)
I have set v1 and v2 previously with numeric values but they are not
recognized. Do I need to wrap v1 and v2 in some sort of identifier,
such as "#"?
Aha... now it comes back. Thanks
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:O1**************@TK2MSFTNGP11.phx.gbl... If v1 and v2 are variables, you have to concatenate them into your SQL
string.
sSQL = "Insert into MyTable (Item, N1, N2) Values ('NewThing'," & v1 & ","
&
v2 & ")"
--
Ray at work
Microsoft ASP/ASP.NET MVP
"Earl Partridge" <ea*****@pearnet.com> wrote in message
news:u4*****************@newsread2.news.atl.earthl ink.net... It has been a while since I've worked with this...
I have an Access database with Numeric fields. In my ASP code I'm
trying to use a variable to enter those numbers, such as
Insert into MyTable (Item, N1, N2) Values ('NewThing', v1, v2)
I have set v1 and v2 previously with numeric values but they are not
recognized. Do I need to wrap v1 and v2 in some sort of identifier,
such as "#"?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Al Newton |
last post by:
I want to use STL's sort algorithm to sort a string vector. Some of
the strings are fairly long (300 to 400 chars) and the vector isn't
small (5,000 to 10,000 elements). Naturally, sorting time...
|
by: Micah |
last post by:
Hi,
I'm looking for a C++ package to use for scientific computing. Things that
would be nice:
* Fast matrix multiplication
* Arbitrary precision
* Equation solvers
* Easy to use!!
If you...
|
by: google |
last post by:
This is something I've done plenty of times in '97, but I can't seem to
get it to work correctly in Access 2003. Say, for example, I have a
form with an unbound combobox, the data source is a...
|
by: Larry Baxter |
last post by:
We have some computationally intense code that would
greatly benefit from any floating point performance
enhancement we could find. We have tests valarrays vs
vectors at all optimization levels...
|
by: Friday |
last post by:
Being an Old L.A.M.P guy, I beg you to please excuse my ignorance of
dot.net (and all things Windows, for that matter).
As part of an experiment (to learn enough ASP/VB.net to port a series
of ...
|
by: Edwin Knoppert |
last post by:
I simply want to insert a word before the numerics for paging..
*If* i need to manage this true a template then how to keep the numeric
stuff?
I was only able to prepare buttons which do adding...
|
by: Learner |
last post by:
Hello,
I have a situation that I need to be able to identify if there are
any numerical values in a string variable that might have numerics
including charecters.
For instanse Dim strValue as...
|
by: naveenkenexa |
last post by:
Can any one please suggest me how to remove numerics in a string of c#
|
by: Sanders Kaufman |
last post by:
I'm doing a check for only alpha-numerics, but I wanna try it with a regex.
Something like this:
$bReturn = is_alphanum($sString).
Can somebody help me do this with regular expressions?
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
