Databases :: How To Create Variable With Max Size In Sql Function
Mar 27, 2011how to create variable with max size in pls/sql function
View 2 Replies
Similar Messages:
Databases :: SQL - Create A Variable That Holds The Value For Each Row Of The Timestamp?
Feb 8, 2010I'm making a simple forum using MySQL and I use a repeater to display a list of all threads in it. I have two tables for posts, one for threads and one for replies, and I want to sort the threads by either when they were posted or when the last reply was posted in it. My SQL query is really long and hard to read so here's some psuedo code similar to it (easier to understand these column names, etc):
SELECT
threads.id,
threads.title,
threads.timestamp,
users.username,
(SELECT COUNT(*) FROM replies WHERE thread_id = threads.id) AS number_of_replies,
(SELECT COUNT(*) FROM views WHERE thread_id = threads.id) AS number_of_views,
(SELECT timestamp FROM replies WHERE thread_id = threads.id ORDER BY timestamp DESC LIMIT 1) AS last_reply_timestamp
FROM threads
LEFT JOIN users
ON threads.user_id = users.id
ORDER BY ************** DESC
What I do here is I fetch the values id, title, timestamp, the author's username, the number of replies and views for a specific thread, and I also get the timestamp for the last reply to this thread.
Then, what I want to do is sort the whole list so that the threads are displayed in an order matching when either it was posted or the last reply was posted in it (you know, like a normal forum) but I'm not sure how to accomplish this.
I tried this:
ORDER BY CASE WHEN last_reply_timestamp > threads.timestamp THEN last_reply_timestamp ELSE threads.timestamp END DESC
but that, I guess, maybe only looks at the first row and determines which one should be used so the order is not correct.
I'm not sure if it's possible to create a sort of variable that holds the value for each row of the timestamp that applies, if that's possible you could sort by that. For example:
(CASE WHEN last_reply_timestamp > threads.timestamp THEN last_reply_timestamp ELSE threads.timestamp END) AS last_activity_timestamp
...
ORDER BY last_activity_timestamp DESC
So each row has a field "last_activity_timestamp" containing either timestamp, whichever is the later than the other.
Can this be done somehow? How does everyone else solve this? It's so hard to search google because I just get lots of forums but no code.
Databases :: Decrease The Database Size From 40 GB?
Jan 8, 2010I have one desktop application which is maintain all information related to laws of high court. we have stored lots of data in my application and now
our database size is almost 40 GB.
So my application runs quite slow.
How can i reduce the database space on my hard disk.
Change Variable Color And Size?
Dec 6, 2010How would I change "newTicketId" to a bigger font and color blue?
[code]....
Allocate Size Bytes Array Variable?
Jan 31, 2010i declared byte array in my function
Try
Dim bytes As Byte() = New Byte() {}
If Not fupload1.PostedFile Is Nothing Then
Dim myfile As HttpPostedFile = Me.fupload1.PostedFile
' Get size of uploaded file
'here how to allocate bytes array variable already declared
Databases :: Increase The Database Size In Oracle Manually?
Jul 7, 2010Can anybody tell me how can I increase the size of the database in oracle manually.
View 2 RepliesSize For Variable Length Data Type Derived From Parameter Value?
Apr 21, 2010I have a few applications/websites running with LINQ to SQL and the other day I decided to go ahead and optimize some of the queries, etc and I found that the size for variable length data types is derived from the parameter value instead of the column actual size? for example a column is defined as nvarchar(30). when I use linq to query that column with a value that's 5 characters long the parameter in sp_executesql will be defined as nvarchar(5)...this causes a major procedure cache bloat even for a small utility site that has a lot of queries is there a way to optimize this?
View 1 RepliesAsp Font Size And Service Function?
Jun 22, 2010i've the following code in aspx page
<asp:Label ID="CittaLabel" runat="server" Text='<%# Eval("Citta") %>' Font-Size='<%# ReturnFontSize(Eval("Big")) %>'/>
and this is my code behind service function
Protected Function ReturnFontSize(ByVal Big As Boolean) As FontUnit
If Big Then
ReturnFontSize = FontSize.Medium
Else
ReturnFontSize = FontSize.Small
End If
End Function
But i get always a font very very small. So my question is : for changing "Font-Size" proprety of a control, from code behind, which return type i have to use, assuming that FontUnit not work?
Web Forms :: How To Create C# Search Function And Add Friend Function
Jan 1, 2010I need to create something which is like an Add friend function in my website which works like this:
1) User types in name of the person he wants to search in the search field and clicks enter
2) on the same page, the search result will come out with an "add friend" button beside every name
3) when the user clicks the "add friend" button, he will be brought to another page (or pop up with a message box?) with a text message field to send to the friend, and a submit button to submit the friend request.
4) over at the Friend's page, he will be able to view the add friend request and decide whether to accept or deny the friend request.
C# - Pass The Variable Into The Function Via Url?
May 14, 2010I have designed a asp.net page which create graphs. I have written a class file (which contain a function to render the graph,a function for entering data named insertdata(string[] s,double[] d)) in App_code folder. I pass the value into the insertdata during page load_event. I saw a feature of googlechart.when you pass the value in url address bar it will create a graph according to that passed value. how can i pass the value into the insertdata() function through url address?
View 2 RepliesDatabases :: Use MySQL Replace Function In C#?
Aug 5, 2010I am trying to use the MySQL replace function in C# but the resulting data ignores the columns inside the REPLACE function - i guess its because C# has its own Replace function
get the required column either through Mysql escape sequence or in the C# syntax
MySqlConnection mySqlConnection1 = new MySqlConnection("server=localhost; database=faohr; pooling=false; allow zero datetime=yes;");
Function And Variable Declaration Without An 'As' Clause?
Aug 25, 2010I get a message - "Function without an 'As' clause" for HMAC_MD5 and "Variable declaration without an 'As' clause" for Key and Value. But the code works. But the messages still exists. Is there a way to fix this to avoid the messages?
[Code]....
C# - How To Use Local Variable Of A Function In Different Page
Aug 2, 2010How to use a local variable of a function of a control in a different page in Asp.net.
View 1 RepliesDatabases :: Function Name Missing (Error S1000)
Aug 22, 2010I am continuously getting error for following line of code. It work fine in other Database.
ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver] Function name is missing. Am I doing any mistake
[Code]....
Databases :: Calling Excel Marco Function?
Aug 2, 2010How to call a macro function of Excel file using Microsoft.Office.Tools.Excel in VS2005?
View 3 RepliesSQL Server :: In Sql Function Check To See If Variable Is Null?
Feb 4, 2011Inside a function I need to check to see if a variable value is null, how to do this? I implemented the code but its not returning the value I thought it would return.If it's null I want to set the value of the variable, else I want to query the value from a table
[Code]....
Forms Data Controls :: How To Use A Variable Name In The #Bind() Function
Apr 1, 2011I am not a fan of using string literals throughout my code. I have the following code right now:
[Code]....
Pass Razor Variable To Jquery Function As Parameter?
Mar 3, 2011I am having the following piece of code that is not working:
<a href="#" onclick="Edit(@Interest);">edit</a>
where I have
@{string Interest=""}
Databases :: Run Query In SQL...while Using Datetime - Error In List Of Function Arguments
Dec 6, 2010 i am developing a webaaplication ASP.net using C# and MYSQL as backend..
i am facing problem to execute this query in MYSQL:
SELECT ID, Date, Event, Remark, school, section, class, schooltype, shift
FROM sessioncalendar
WHERE (school = 'SECONDARY SCHOOL') AND (class = 'IX') AND (section = 'B') AND (shift = 'SHIFT I') AND (schooltype = 'XYZ School')
AND MONTH ( Date )= '6'
AS the query works well wethout addind AND MONTH ( Date )= '6' ... but when i add this line query generate error
( Error in list of function arguments: ')' not recognized. Unable to parse query text.)
While same query is working successfully with Sql Server 2005...but i hvnt found any reason why my query is not working with Date(datetime) column..i hv google about it..but i found synatax is same in both SQL SErver 2005 and MY SQL syntax
Databases :: Convert Totalseconds To Hh:mm:ss By Converting It With Timespan Function Of Dotnet?
Nov 16, 2010I have a column as totalsecond in my database i take a avg of tht totalsecond column for the particular parameter and condition and when i come on my aspx page i show that data as hh:mm:ss by converting it with timespan function of dotnet and show this in datagrid but while doing this calculation in DataGrid_ItemDataBind it take so much time and the user have to wait for long time for the result after clicking button show when there is large amount of data.
How can i reduce the time of waiting for the user with some coding logic that speed up the calculation time.
Web Forms :: Pass Variable As Html Control Through To Javascript Function
Jan 24, 2011I have a function that gets the position of a control.
[Code]....
All the function needs is an htmlcontrol being fed to it as the parameter (elemRef). I can declare a variable in Javascript of the same content page but different function and pass the parameter successfullly getting returned values. For example, if I have the following function:
function (getPosition)
{ var txtBox1 = document.getElemendById('<%=txtBox1.ClientID %>');
getPos(txtBox1);
}
I will get the coordinates of the control txtBox1. But how can I accomplish this if I am calling this function from a javascript function or codebehind of the Master Page, or codebehind of the same content Page.
DataSource Controls :: How To Declare Scalar Variable @UserName In Function
Jan 14, 2010How do I define @UserName in my function:
[Code]....
I believe "UserName" = Me.User.Identity.Name
but I don't know the proper way to add it to the function.
Web Forms :: Passing Variable From Code Behind To A Java Script Function?
Feb 18, 2011can I pass a variable from code behind to a javascript function. if so, do you have a sample demo.
View 1 RepliesWeb Forms :: Using Javascript, Call One Function From Another, Pass A Variable That Represents?
Jan 20, 2011I have a variable created to manipulate a contorl on a page:
var pnl= document.getElementById('<%=pnl1.ClientID %>');
[Code]....
[Code]....
Html - Inject A Code-behind Variable Or Function Evaluation Into The Page Using <%# ?
Jul 23, 2010Can someone explain to me the rules around what can and cannot be evaluated/inserted into markup using the <%# %> and <%= %> tags in asp.net?When I first discovered I could inject code-behind variables into mark-up using <%= I thought 'great'. Then I discovered that if such tags are present you can then not add to the controls collection of the page (that's a whole different question!). But <%# tags are ok.
Is there a way I can inject a code-behind variable or function evaluation into the page using <%# ?