than you for the explanation. This is exactly what I was looking for.
thank you for your time.
user1980
Last Activity: Jan 31 '12, 03:57 PM
Joined: Dec 7 '09
Location:
-
thank you so much for the suggestion. I will work on this.Your query works as required but it does not pick up students who have no record corresponding to the question id 2 ie students can have a record in the answers table and students table even if they have no answer for that question.
I will follow your lead and try to figure how it can be achieved. thank you once again.Leave a comment:
-
I tried it and unfortunately that does not work.thank youLeave a comment:
-
Question about query
Hi there -
I have two tables, of which table 1 records who have opened an application and table 2 records their answers.
table 1:
Std_id, Name, Status
table 2:
Std_id, Q_id, Answers
where q_id is question id.
Table 1 has one record for each student who has answered questions/just opened an application and table 2 has multiple rows for each student. The table 2 has answers... -
I have not taken a closer look at the expression..now it works..thank you....Leave a comment:
-
I do have the closing quote...anyways , this is what i have now...
...Code:function validatePartialDateInput(SourceField, FieldLabel) { var sField = document.getElementById('ctl00_ContentPlaceHolder1_'+ SourceField); var regex_dt = new RegExp('^(0[1-9]|1[012])[- /.](19|20)\d\d$',""); alert((sField.value)); alert(regex_dt.test(sField.value));Leave a comment:
-
thank you for the reply but still no use....Leave a comment:
-
thank you..i thought if it is java script I don't have to create a object.
anyways, when I created the object it worked...
Code:var regex_dt = new RegExp('/^\d{1,2}[/]\d{1,4}$/',"");
however, my regex always returns false..
...Code:function validatePartialDateInput(SourceField, FieldLabel) { var sField = document.getElementById('ctl00_ContentPlaceHolder1_'+ SourceField);Leave a comment:
-
Regex.match returns null
hi there
it seems to be simple but i do not know why my java script function does not work.
...Code:function validatePartialDateInput(SourceField, FieldLabel) { var sField = document.getElementById('ctl00_ContentPlaceHolder1_'+ SourceField); var regex_dt = '/^\d{1,2}[/]\d{4}$/'; alert((sField.value)); alert(regex_dt.match(sField.value));//returns -
Regex.Replace not working as required.
Hi there,
I am trying to replace text in my xsl file. I have to replace all the http and https. But I can leave any links that start with <a href>
Ie; http://www.google.com has to replaced. But < a href=”google.co m”>google.com</a> has to remain as it is.
I am using regex to find all the http(s) and a hrefs in the text. I am struck here.
... -
LINQ to DataTable
hi,
I am trying to join two datatables using LINQ. I am unable to use .CopyToDataTabl e in my code. I have added System.Data.Dat aSetExtensions. dll. It gives me the error, 'CopyToDataTabl e' is not a member of 'System.Collect ions.Generic.IE numerable(Of <anonymous type>)'.
I have searched online a lot about this. The solution was to add the dll which I did but still I get the error.
Also there are... -
use a loop for LINQ result
Hi,
I am trying use LINQ t join two different tables. I have to loop through an array list to obtain the two data tables.
Currently I am using a for loop to go through the array list and then obtain the result for each data table. I have only one row in each data table for one value in array list.
I am using LINQ to join these two datatables. I am sending this LINQ join to a data set and... -
Error when using LINQ to dataset
Hi,
I am using LINQ to join two different datatables. I am trying to put the result in a dataset.
This code was working fine till yesterday. But today when I run the code, it gives me the error,
Unable to cast object of type '<JoinIterator> d__61`4[System.Data.Dat aRow,System.Dat a.DataRow,Syste m.Decimal,VB$An onymousType_0`1 0[System.Decimal, System.DateTime ,System.DateTim e,System.DateTi me,System.DateT ime,System.Deci mal,System.Deci mal,System.Stri ng,System.Strin g,System.String]]'... -
Question about Datarelation and dataset
hi,
I am using datarelation to join two datatables.
Here is my code,
...Code:Dim dt1 As New DataTable dt1.Load(dr1) Dim dt2 As New DataTable dt2.Load(dr2) Dim datarelation As DataRelation Dim dc1 As DataColumn Dim dc2 As DataColumn Dim ds As New DataSet ds.Tables.Add(dt1) -
Error in LINQ join
HI there,
I am trying to join two datatables using LINQ.
...Code:Dim dt1 As New DataTable dt1.Load(dr1) Dim dt2 As New DataTable dt2.Load(dr2) Dim joinquery = From t1 In dt1.AsEnumerable(), t2 In dt2.AsEnumerable() _ Where (t1.Field(Of Long)("CLASS_N0") = _ t2.Field(Of Long)("CLASS_N0")) _ -
to elaborate my question, I have a primary key in T1 which is foreign key in T2 and similarly a priamry key in T2 is a foreign key for T1. is this possible? if so what would be the parent table in this relationship?
this was asked in an interview.thank youLeave a comment:
-
Can a table be both parent and child to another table.
hi there,
Can someone please clear this for me with an example. Can one table, say T1, be parent to another table, say T2, and also be the child of T2 at the same time.
to be more clear, T1 is parent of T2 and T1 is child of T2.
is this possible, if so can you please give me a an example.
thank you for your time -
hosting a new asp.net webpage for an existing domain
hello
I have a domain that is running which is http://testname.test.o rg. Now I have to add an new asp.net webpage to this site with the URL http://newpage.testnam e.test.org. I have the webpage developed as an asp.net website in Visual studio 2005. I have a windows server 2003 and IIS 6.0 to host this page.
The windows server has no firewall and its port 80 is open as there are running few asp applications from the...
No activity results to display
Leave a comment: