Click here to Skip to main content
15,921,452 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: email sent automatically from .aspx page Pin
chinnasrihari9-May-06 20:23
chinnasrihari9-May-06 20:23 
QuestionWhich way is the Page_Load event? Pin
Raul Davila9-May-06 13:24
Raul Davila9-May-06 13:24 
AnswerRe: Which way is the Page_Load event? Pin
minhpc_bk9-May-06 15:17
minhpc_bk9-May-06 15:17 
Questionneeed help about backtalk plz Pin
ksar0019-May-06 12:26
ksar0019-May-06 12:26 
QuestionAllowing html inside a textbox control Pin
Ista9-May-06 10:48
Ista9-May-06 10:48 
AnswerRe: Allowing html inside a textbox control Pin
Daniel Santillanes9-May-06 12:56
professionalDaniel Santillanes9-May-06 12:56 
AnswerRe: Allowing html inside a textbox control Pin
chinnasrihari9-May-06 20:34
chinnasrihari9-May-06 20:34 
QuestionHow to Prepare a Combined Setup using .NET 2.0 Pin
VenkataRamana.Gali9-May-06 9:14
VenkataRamana.Gali9-May-06 9:14 
Questionfiles Pin
irshan9-May-06 6:49
irshan9-May-06 6:49 
AnswerRe: files Pin
CWIZO9-May-06 8:43
CWIZO9-May-06 8:43 
QuestionDynamic breadcrumbs Pin
leckey9-May-06 5:36
leckey9-May-06 5:36 
AnswerRe: Dynamic breadcrumbs Pin
J4amieC9-May-06 5:39
J4amieC9-May-06 5:39 
QuestionRe: Dynamic breadcrumbs Pin
leckey9-May-06 5:46
leckey9-May-06 5:46 
QuestionCustom player Pin
venkatarama9-May-06 5:31
venkatarama9-May-06 5:31 
Question.Net Services Pin
munklefish9-May-06 5:30
munklefish9-May-06 5:30 
AnswerRe: .Net Services Pin
munklefish9-May-06 6:07
munklefish9-May-06 6:07 
QuestionMoving Web Parts without reloading page Pin
dave90879-May-06 5:29
dave90879-May-06 5:29 
Questionread xml string Pin
fmardani9-May-06 4:29
fmardani9-May-06 4:29 
AnswerRe: read xml string Pin
minhpc_bk9-May-06 15:51
minhpc_bk9-May-06 15:51 
QuestionNeed Help - problem with browsers while parsing innerHTML at clientside Pin
akjoshi9-May-06 3:55
akjoshi9-May-06 3:55 
QuestionCheck box in data grid Pin
jaikrishna9-May-06 3:52
jaikrishna9-May-06 3:52 
AnswerRe: Check box in data grid Pin
Daniel Santillanes9-May-06 13:03
professionalDaniel Santillanes9-May-06 13:03 
QuestionASP Split Function Pin
Programm3r9-May-06 2:35
Programm3r9-May-06 2:35 
Hi,

I'm struggling with the split function of ASP. I'm using Dreamweavers ASP, Javascript.
The string looks like this:

+ 'test=1L1S1=INSERT INTO SHIFTDEFINITION (SHIFT,DATACOLUMN,DATAVALUE,DATATYPE,FIELDDESCRIPTION,LINENO,SEQNO,COMPANY) VALUES ('ABC' + , + 'NTSTART' + , + '15:30' + , + 't' + , + 'Start Time', + 1,1, + 'ASP')L1S2=INSERT INTO SHIFTDEFINITION (SHIFT,DATACOLUMN,DATAVALUE,DATATYPE,FIELDDESCRIPTION,LINENO,SEQNO,COMPANY) VALUES ('ABC' + , + 'NTEND' + , + '16:30' + , + 't' + , + 'End Time', + 1,2, + 'ASP')L1S3=INSERT INTO SHIFTDEFINITION (SHIFT,DATACOLUMN,DATAVALUE,DATATYPE,FIELDDESCRIPTION,LINENO,SEQNO,COMPANY) VALUES ('ABC' + , + 'CHANGEDBY' + , + 'RICHARDB' + , + 'S' + , + 'Changed By', + 1,3, + 'ASP')

As you can see there is sql in the string. The L1S1 stands for LineNo 1 and SeqNo 1 and so on, because I'm building the HTML dynamically. There is a variable called id which runs though a loop and builds the id example. var id = ("L"+x+"S"+y);

I get the string from a hidden field in the HTML called "hide". The hidden field was populated with a javascript function that reads the sql out of a cookie passed on from another page.

Then I use the split function to extract the sql from the string to execute it.
And this is what I have tried so far with no success:

<%
var WordArray= new Array(11);
var THESQLString = new Array(11);
THESQLString = Request.Form("hide");
// with loops in this statement
WordArray[y] = THESQLString[y].split(id);

All I receive is an error saying: Object Expected or WordArray[y] is null or not an object

The en result must look something like this (for each Lines SeqNo):
INSERT INTO SHIFTDEFINITION (SHIFT,DATACOLUMN,DATAVALUE,DATATYPE,FIELDDESCRIPTION,LINENO,SEQNO,COMPANY) VALUES ('ABC' + , + 'CHANGEDBY' + , + 'RICHARDB' + , + 'S' + , + 'Changed By', + 1,3, + 'ASP')

Thanx alot if someone can Help me

Richard a.k.a Programm3r
QuestionProblem in datalist Pin
sandeep_thakur9-May-06 2:29
sandeep_thakur9-May-06 2:29 
AnswerRe: Problem in datalist Pin
KrIstOfK9-May-06 4:03
KrIstOfK9-May-06 4:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.