Hi
I haven't used the ASP.Net profiler much and considering using it for a new project.
It seems quite restricting as profile information is stored in on field. Also, does it keep history of updates to this field?
So a client updates their address or something does it keep a history.
As far as I can see it doesn't, it simply updates the field and no history is kept.
If this is the case...
theJonster
Last Activity: Feb 28 '09, 03:20 PM
Joined: Feb 13 '07
Location:
-
asp.net profiles and history
-
ah yes, I have done pivots before.
Thanks -
put rows together and group by another column
Hi
Say i have 3 rows and 2 columns
clientid1, details1
clientid1, details2
clientid1, details3
how do i get this result
clientid1, details1 details2 details3
so basically group by client and then add the rows together into one row.
feels like there should be a function for it.
thanks -
Hi
Thanks for the response. What you suggested is how I am also doing it currently. I just thought there may be some way to link updates to specific Primary Keys instead of just have a varchar field with say a persons name in it.Leave a comment:
-
DB fundamental
Bit of a big question, hoping to start a discussion or just get the best answer out straight.
Trying to work out which is the best way to database history of tables and who did updates to a record.
You have a table:
MEMBERS
MemberId
Name
LName
Email
Password
Now the member updates their details and you dont want to lose their history.
I can... -
FlashVar link wont work
Hi
I am embedding a swf object. I try:
[HTML]<script type="text/javascript" src="../scripts/swfobject.js"></script>
<script type="text/javascript">
var flashvars = {
linktarget: "_top",
link: "http://www.google.co.z a",
linkfromdisplay : "true"... -
FlashVar link wont work
Hi
I am embedding a swf object. I try:
[HTML]<script type="text/javascript" src="../scripts/swfobject.js"></script>
<script type="text/javascript">
var flashvars = {
linktarget: "_top",
link: "http://www.google.co.z a",
linkfromdisplay : "true"... -
Ya i have that query, but was trying to avoid the manualness part. gonna take half a day to rename all the references, am just lucky it a not-so-used table....Leave a comment:
-
Update table name and all objects that reference it
Is there anyway that a query could update a table name and all the objects that reference it.
e.g table name is 'Blah' change to 'BlahBLahBLah'
and this will update all the objects in the database that uses/references that table?
Do not feel like doing this maually.
Thanks -
saving data from multiple dynamically created input contols
Hi,
I have created a page with a list of items and next to these items are comment boxes and check boxes which were dynamically created like this:
...Code:check = new CheckBox(); check.ID = "Chk" + checkcount; if (dr["Checked"].ToString() == "True") { -
BETWEEN now() - 6days???? AND now()
Hi,
Tryin to get records between these two dates, 6 days ago and now.
Thanks -
never mind....had made stupid error..got it working!Leave a comment:
-
Invalid object name '#temp'
i calling the sp like this:
...Code://get the recs for the client public SqlDataReader GetRecs(int option, int client) { param = new string[2] { "@OPTION", "@CLIENT" }; values = new object[2] { option, client}; SqlDataReader dr = data.GetDataReader("spMovielist", param, values); -
thanks man, i had just found out about the union thing
but was not workin as left out some records
then i saw your 'all' thing and that works.
whats the difference?
thanks again tho!Leave a comment:
-
Whats wrong here?
SELECT *
into #temp
FROM
(SELECT *
FROM vwActor
UNION
SELECT *
FROM vwDirect)
tryin to put contents of both views into one temp table...both hav same fields.
Thnks -
Put 3 tables with same fields into one
hi,
i have three tables all with same fields i.e an id and a count.
table1 + table2 + table3 = #temp
thanks -
wow that was easier...
didn't know about that 'in' function
I assume cursors are slower..
thanks for the help!Leave a comment:
-
awesome i worked it out! :)
used a cursor...didnt know about those or how to use them but got it!Leave a comment:
-
delete records from one table that occur in another
hi,
i have tableA with column dvd_id and tableB with client_ID and dvd_id.
i want to remove from tableA all the records where tableB has the same dvd_id for a specific client_ID.
tableA tableB
dvd_id client_id dvd_id
17 1 12
12 1 ... -
specific records returned from 3 views using sql
Hi,
i am tryin to get 60 records returned from 3 views:
i.e: vwActors, vwDirectors, vwGenres.. all contain dvdID and a Count - for their occurrence in each table. then for each VIEW check if dvdID occurs in dbo.movielist.. if it does remove the row from the view. then select the top 20 from each updated view and return them to me.
i dont really have a problem with logic of this..more just the language and...
No activity results to display
Leave a comment: