Help at asp.net [vb]

[tynum]

---

to summarize it bai when your coding asp.net dont think Php, maka libog na para nimu, daun your problem is not php but SQL, when mu display gani ka ug based sa where statement daun ang particular statement is example .... COLUMN AS NAME where value = Something.

its true bai na i think PHP while nag code ko sa ASP.NET... thats because what i want to achieve kay ma think nku via PHP and im thinking na there is somehow a similarity with the PHP code ug ASP code... coz they're both used in web apps... peru as of now nka realize jud ko na tungud sa kadali2x aning ASP lisud i manipulate kay halos nka tago tanan procedures in a function or in a feature... ngau lang ko tabang ninyu bai....

in regards to the sql... i know bai na naa ko problem sa sql... peru grabe sad nang wala ko kahibaw ug "where" oi... kamao sad ko mu gamit ana.. peru everything has there limits... nganu imo man i tukmod ang butang na d na matukmod all im asking is help.... not your judgment

back to topic ta... naa ba lain ways para ma achieve ni ang pag manipulate sa data ani nga column lamat daan...

[moz_k2]

unsay i display nga walay labot?
way labot nga column or row?

kung column depend na sa imo gi select na column.
kung row depende sa pag filter nimo sa data.

kato gihatag ni coldfusion na solution bro ni work nato pra sa YES/NO nga value?
If yes then ang problem nalang jud nimo is sa imo WHERE nga statement pra
sa kana date range na imo gi specify.

[bryanarzaga]

its true bai na i think PHP while nag code ko sa ASP.NET... thats because what i want to achieve kay ma think nku via PHP and im thinking na there is somehow a similarity with the PHP code ug ASP code... coz they're both used in web apps... peru as of now nka realize jud ko na tungud sa kadali2x aning ASP lisud i manipulate kay halos nka tago tanan procedures in a function or in a feature... ngau lang ko tabang ninyu bai....

in regards to the sql... i know bai na naa ko problem sa sql... peru grabe sad nang wala ko kahibaw ug "where" oi... kamao sad ko mu gamit ana.. peru everything has there limits... nganu imo man i tukmod ang butang na d na matukmod all im asking is help.... not your judgment

back to topic ta... naa ba lain ways para ma achieve ni ang pag manipulate sa data ani nga column lamat daan...

well first im not judging you that you dont know anything or even the gist of it but making you realize you shouldnt think PHP while in .net, lahi tanan, thats why its a different language, to make a small example of myself, when i had a backward experience with "c" and assembly, i used to ask unsaon2x well walay way to reference C to assembly..

how to manipulate your data in every row is not that hard, mysql imu gamit as DB,

also are you trying to write back yes or no sa DB? or just a notification sa end user?

your query in Mysql is fine, here's a little link MySQL - ASP.NET Forums

[tynum]

para nku bro kay murag d na lagi to mao ang solution bro... kay mu query ka para sa script_error_id, starts, ends...

select script_error_id, starts, ends, <condition> as error from script_error, script_run..... etc..

peru wat if sa script_run na table kay 5 kabuuk script 0001 nya lahi lang ilang start ug end... dba murag unsaon nman na nmu pag query??

EXAMPLE:

data at hand: script_id - 0001

imo pangitaon si 0001 sa script_run na table if ni exist xa...

if nka kita nka sa first existence ni 0001 (possible daghan 0001 sa script_run table) kay imo daun pangitaon c 0001 sa script_error table where date_created >= starts(same row of the first 0001) and date_created <= ends(same row of the first 0001).... meaning naay error sa pag run ani nga script at this very moment...

if na meet ang second condition YES ang labas sa ERROR column... else NO...

script_error_id.....starts.....ends......error
.....0001.............9am......10am.......YES
.....0001.............3pm.......4pm.......NO



sabot ka bro murag d jud na mada ug magic2x sa sql... nid na jud na ug tactics sa pag code diri sa ASP na side... or basin sa imo point of view madala pa?? mada pa ba??

[tynum]

[B]
also are you trying to write back yes or no sa DB? or just a notification sa end user?

pareng bryan... im not trying to put into the DB ang yes/no na statements... for the end users ra na...
paminaw nku d na jd ni mada ug magic2x sa sql... hehehe.... or basin mas gamhanan pa mo nku na ma magic pa na ninyu... hehehe...

[bryanarzaga]

pareng bryan... im not trying to put into the DB ang yes/no na statements... for the end users ra na...
paminaw nku d na jd ni mada ug magic2x sa sql... hehehe.... or basin mas gamhanan pa mo nku na ma magic pa na ninyu... hehehe...

para nku bro kay murag d na lagi to mao ang solution bro... kay mu query ka para sa script_error_id, starts, ends...

select script_error_id, starts, ends, <condition> as error from script_error, script_run..... etc..

peru wat if sa script_run na table kay 5 kabuuk script 0001 nya lahi lang ilang start ug end... dba murag unsaon nman na nmu pag query??

EXAMPLE:

data at hand: script_id - 0001

imo pangitaon si 0001 sa script_run na table if ni exist xa...

if nka kita nka sa first existence ni 0001 (possible daghan 0001 sa script_run table) kay imo daun pangitaon c 0001 sa script_error table where date_created >= starts(same row of the first 0001) and date_created <= ends(same row of the first 0001).... meaning naay error sa pag run ani nga script at this very moment...

if na meet ang second condition YES ang labas sa ERROR column... else NO...

script_error_id.....starts.....ends......error
.....0001.............9am......10am.......YES
.....0001.............3pm.......4pm.......NO


ah, gets gets, ok bai give me 5 mins , bai give me all the fields sa imu script_run na table

[bryanarzaga]

bai question, how did the first 0001 be an error? please explain more is it because of this?

date_created >= starts(same row of the first 0001) and date_created <= ends(same row of the first 0001)

sulay ragud ta magic, there is a way bya pero displaying to the user will be a Dim'd variable na, we need information sa database para maka run ta ug sub procedure to detect unsa mga values g load sa grid para maka display ta ug YES or NO

also is Script_id example 0001 is the primary key?

[tynum]

bai question, how did the first 0001 be an error? please explain more is it because of this?

date_created >= starts(same row of the first 0001) and date_created <= ends(same row of the first 0001)

yes bro... mao na ang reason nga mu error ang first 0001... kay naa man log sa script_error table on that specific time and script_id....

sulay ragud ta magic, there is a way bya pero displaying to the user will be a Dim'd variable na, we need information sa database para maka run ta ug sub procedure to detect unsa mga values g load sa grid para maka display ta ug YES or NO

also is Script_id example 0001 is the primary key?

unsa na info ang need nmu bro bsta ang i display sa gridview kay ang script_error_id, starts, ends, ug ERROR... mao na...

regarding sa script_id example 0001 is not the primary key in script_run and script_error....
script_run_id = PK for script_run table
script_error_id = PK for script_error table

[bryanarzaga]

yes bro... mao na ang reason nga mu error ang first 0001... kay naa man log sa script_error table on that specific time and script_id....



unsa na info ang need nmu bro bsta ang i display sa gridview kay ang script_error_id, starts, ends, ug ERROR... mao na...

regarding sa script_id example 0001 is not the primary key in script_run and script_error....
script_run_id = PK for script_run table
script_error_id = PK for script_error table

ganahan ta ko sa tanan nimu na tables g kalibgan kai i want to try and make the program , i know ganahan raka tabang pero im curious pud how this runs bah,

hope ok ra nimu, kai maybe to specific ako nakit an that ang start ug ends are time data daun datecreated i would assume na dateni sya?

cge ato sulayan ug start ni para i can make the program and better visualize it

[tynum]

ganahan ta ko sa tanan nimu na tables g kalibgan kai i want to try and make the program , i know ganahan raka tabang pero im curious pud how this runs bah,

hope ok ra nimu, kai maybe to specific ako nakit an that ang start ug ends are time data daun datecreated i would assume na dateni sya?

cge ato sulayan ug start ni para i can make the program and better visualize it

tnx bro... i appreciate ur help.... basta ang thought ra jud ani bro kay bale mo monitor ni xa sa mga scripts na ni run...

steps:
1. run scripts...... from scripts table...
2. log script being run to script_run table..... logs script_id, starts(datetime), ends(datetime)..
3. if there is an error while running the script( like server down, poor coding, etc. ) logs script_id, reason, date_created(datetime when error ocurred) to script_error table...


my job:
1. get script_id from scripts table
2. looks into script_run table where script_id is equal to script_id in no.1
3. for every match in no.2 look into script_error table if there is an error while running that script at that time (starts, ends)
4, displays script_error_id, starts, ends, error(yes/no) via gridview in asp.net... script_error_id column kay hyperlinks ni sila na ma click aron ma view ang reason of error if any....

my problem:

unsaon jud nku para ma display nku c error column as either YES or NO... depending if that script errored on the time when it was run...

OK ba ako explaination nka sabot na jud error column ra ako problema... its for the end users....