Databases :: How To Create Variable With Max Size In Sql Function

Mar 27, 2011

how 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, 2010

I'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 COUNT(*) FROM replies WHERE thread_id = AS number_of_replies,
(SELECT COUNT(*) FROM views WHERE thread_id = AS number_of_views,
(SELECT timestamp FROM replies WHERE thread_id = ORDER BY timestamp DESC LIMIT 1) AS last_reply_timestamp
FROM threads
ON threads.user_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.

View 6 Replies

Databases :: Decrease The Database Size From 40 GB?

Jan 8, 2010

I 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.

View 3 Replies

Change Variable Color And Size?

Dec 6, 2010

How would I change "newTicketId" to a bigger font and color blue?


View 2 Replies

Allocate Size Bytes Array Variable?

Jan 31, 2010

i declared byte array in my function

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

View 2 Replies

Databases :: Increase The Database Size In Oracle Manually?

Jul 7, 2010

Can anybody tell me how can I increase the size of the database in oracle manually.

View 2 Replies

Size For Variable Length Data Type Derived From Parameter Value?

Apr 21, 2010

I 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 Replies

Asp Font Size And Service Function?

Jun 22, 2010

i'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
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?

View 2 Replies

Web Forms :: How To Create C# Search Function And Add Friend Function

Jan 1, 2010

I 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.

View 1 Replies

C# - Pass The Variable Into The Function Via Url?

May 14, 2010

I have designed a 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 Replies

Databases :: Use MySQL Replace Function In C#?

Aug 5, 2010

I 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;");

View 2 Replies

Function And Variable Declaration Without An 'As' Clause?

Aug 25, 2010

I 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?


View 4 Replies

C# - How To Use Local Variable Of A Function In Different Page

Aug 2, 2010

How to use a local variable of a function of a control in a different page in

View 1 Replies

Databases :: Function Name Missing (Error S1000)

Aug 22, 2010

I 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

View 2 Replies

Databases :: Calling Excel Marco Function?

Aug 2, 2010

How to call a macro function of Excel file using Microsoft.Office.Tools.Excel in VS2005?

View 3 Replies

SQL Server :: In Sql Function Check To See If Variable Is Null?

Feb 4, 2011

Inside 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


View 5 Replies

Forms Data Controls :: How To Use A Variable Name In The #Bind() Function

Apr 1, 2011

I am not a fan of using string literals throughout my code. I have the following code right now:


View 1 Replies

Pass Razor Variable To Jquery Function As Parameter?

Mar 3, 2011

I am having the following piece of code that is not working:

<a href="#" onclick="Edit(@Interest);">edit</a>

where I have

@{string Interest=""}

View 2 Replies

Databases :: Run Query In SQL...while Using Datetime - Error In List Of Function Arguments

Dec 6, 2010

i am developing a webaaplication 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

View 1 Replies

Databases :: Convert Totalseconds To Hh:mm:ss By Converting It With Timespan Function Of Dotnet?

Nov 16, 2010

I 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.

View 4 Replies

Web Forms :: Pass Variable As Html Control Through To Javascript Function

Jan 24, 2011

I have a function that gets the position of a control.


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 %>');

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.

View 4 Replies

DataSource Controls :: How To Declare Scalar Variable @UserName In Function

Jan 14, 2010

How do I define @UserName in my function:


I believe "UserName" = Me.User.Identity.Name

but I don't know the proper way to add it to the function.

View 6 Replies

Web Forms :: Passing Variable From Code Behind To A Java Script Function?

Feb 18, 2011

can I pass a variable from code behind to a javascript function. if so, do you have a sample demo.

View 1 Replies

Web Forms :: Using Javascript, Call One Function From Another, Pass A Variable That Represents?

Jan 20, 2011

I have a variable created to manipulate a contorl on a page:

var pnl= document.getElementById('<%=pnl1.ClientID %>');


View 1 Replies

Html - Inject A Code-behind Variable Or Function Evaluation Into The Page Using <%# ?

Jul 23, 2010

Can someone explain to me the rules around what can and cannot be evaluated/inserted into markup using the <%# %> and <%= %> tags in 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 <%# ?

View 2 Replies

Copyrights 2005-15, All rights reserved