Using ASP.net1.1 and Parameters
I have many more fields to put into this statement.
How can I list them vertically instead of one long line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident,
TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor,
ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays,
@TheSNN, @TheJob, @TheSupervisor, @ThePart)" 3 1232
use the underscore character ( _ ) to split line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident, _
TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor, _
ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays, _
@TheSNN, @TheJob, @TheSupervisor, @ThePart)"
is that what you want?
Lit
"dancer" <da****@microsoft.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Using ASP.net1.1 and Parameters
I have many more fields to put into this statement.
How can I list them vertically instead of one long line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident,
TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor,
ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays,
@TheSNN, @TheJob, @TheSupervisor, @ThePart)"
I had tried that. I also tried using & _. I also tried putting & at the
beginning of the next line. But I always get this error:
String constants must end with a double quote
"Lit" <sq**********@hotmail.comwrote in message
news:ex**************@TK2MSFTNGP04.phx.gbl...
use the underscore character ( _ ) to split line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident, _
TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor, _
ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays,
_
@TheSNN, @TheJob, @TheSupervisor, @ThePart)"
is that what you want?
Lit
"dancer" <da****@microsoft.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>Using ASP.net1.1 and Parameters
I have many more fields to put into this statement. How can I list them vertically instead of one long line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident, TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor, ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays, @TheSNN, @TheJob, @TheSupervisor, @ThePart)"
Never mind. I realized I have to use vbCrLf _
Thanks.
"dancer" <da****@microsoft.comwrote in message
news:Og**************@TK2MSFTNGP03.phx.gbl...
>I had tried that. I also tried using & _. I also tried putting & at the beginning of the next line. But I always get this error:
String constants must end with a double quote
"Lit" <sq**********@hotmail.comwrote in message
news:ex**************@TK2MSFTNGP04.phx.gbl...
>use the underscore character ( _ ) to split line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident, _
TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor, _
ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays, _
@TheSNN, @TheJob, @TheSupervisor, @ThePart)" is that what you want?
Lit "dancer" <da****@microsoft.comwrote in message news:%2****************@TK2MSFTNGP02.phx.gbl...
>>Using ASP.net1.1 and Parameters
I have many more fields to put into this statement. How can I list them vertically instead of one long line?
Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident, TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor, ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays, @TheSNN, @TheJob, @TheSupervisor, @ThePart)" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: kartik |
last post by:
there seems to be a serious problem with allowing numbers to grow in a
nearly unbounded manner, as int/long unification does: it hides bugs.
most of the time, i expect my numbers to be small. 2**31...
|
by: kelvSYC |
last post by:
Say I have a really long list (more than 100 items, say). Because of
the enormous vertical space it takes up, I decide to present them in a
a way that I put five list items in a line (ie. the...
|
by: Danny Lesandrini |
last post by:
I'm using an Access database to drive a web site and the
colors of various table backgrounds are stored in Access.
I want users of the Access database to be able to select
colors for the site, but...
|
by: Spacen Jasset |
last post by:
The main two desirable things I feel error handling should provide are
these:
1) Debugging and diagnostic aid
2) User feedback
One method that is used a fair amount it to 'say' that all...
|
by: David Helgason |
last post by:
I'm calling one stored procedure with a prepared statement on the
server with 6 arrays of around 1200 elements each as parameters. The
parameters are around 220K in total.
This is taking a...
|
by: Fried Egg |
last post by:
Hi Pythonist(a/o)s
I am interested if anyone can shed any light on a web application
problem, both in the specific details (see below) but also in the
theory of how to do ad hoc data processing...
|
by: Charles Wilt |
last post by:
I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access
via a linked server from SQL Server 2000.
The following select works fine:
select * from...
|
by: XML newbie: Urgent pls help! |
last post by:
function to convert string to 1 dimensional array of long in VB.Net
|
by: J. Frank Parnell |
last post by:
Hi there,
I have a list of links which point to e.g.
thescript.php?album=somePictures1
thescript.php?album=somePictures2
This list is about 3000 links. Each album may have 500 or more...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |