Search Results

Search found 17501 results on 701 pages for 'stored functions'.

Page 286/701 | < Previous Page | 282 283 284 285 286 287 288 289 290 291 292 293  | Next Page >

• How to get rank based on SUM's?

  - by Kenan

  I have comments table where everything is stored, and i have to SUM everything and add BEST ANSWER*10. I need rank for whole list, and how to show rank for specified user/ID. Here is the SQL: SELECT m.member_id AS member_id, (SUM(c.vote_value) + SUM(c.best)*10) AS total FROM comments c LEFT JOIN members m ON c.author_id = m.member_id GROUP BY c.author_id ORDER BY total DESC LIMIT {$sql_start}, 20

  Read the article

• Copy and delet the file from the FTP SERVER using Windows Service in c#

  - by thinker007

  I am trying to implement a windows service that will ping a FTP site and copy its contents once in every 3 houre. This service has functions to List all files in the FTP site Copy one file Delete the copied file Repeats step 2 and 3 for all files in the site

  Read the article

• Enity sql to pass parameter and get one back?

  - by molgan

  Hello I am using entity framework that comes with 3.5sp1, and I need to execute a stored and pass 2 parameters, @a int @b int, and get 1 @somedate datetime back. How is that done using entity sql and c#? /M

  Read the article

• wordpress use table sort functionality in own plugin

  - by choise

  Hi, im creating a own plugin for wordpress where i have to view a set of data. now i want to use the wordpress default table view to display my data, and give some functionality to it default table: is there a way to use this table view for my own plugins (some classes or functions) or do i have to create something similar by myself?

  Read the article

• Is opening too many datacontexts bad?

  - by ryudice

  I've been checking my application with linq 2 sql profiler, and I noticed that it opens a lot of datacontexts, most of them are opened by the linq datasource I used, since my repositories use only the instance stored in Request.Items, is it bad to open too many datacontext? and how can I make my linqdatasource to use the datacontext that I store in Request.Items for the duration of the request? thanks for any help!

  Read the article

• How can I set a jQuery tab number that's present in an ASP.NET MVC model?

  - by user314241

  Hi, I have an ASP.NET MVC view on which I've placed jQuery tabs. I'm loading the tabs using: function getContentTab(index) { var url='<% = Url.Content("~/Books/GetBookTab") %/' + index; ... } I have stored the user's default tab selection in the model associated with this view. My question is this, how can I set the tab number (index) with the number in my model data? Thanks, Arnold

  Read the article

• MySQL ODBC 3.51 Driver UTF-8 encoding

  - by kesava

  Currently I am migrating MSSQL to MYSQL.I am using the MySQL ODBC 3.51 driver to connect to mysql using odbc connectivity.I have telugu language charectors stored in the table.They are not showing properly while using the mysql odbc driver, but they are showing up properly while using the sqlserver odbc driver. Here is my connetion string Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=dbtest; User=user1;Password=mysql;Option=3;CharSet=utf8; Please suggest a solution to fix this.

  Read the article

• Specifying schema for temporary tables

  - by Tom Hunter

  I'm used to seeing temporary tables created with just the hash/number symbol, like this: CREATE TABLE #Test ( [Id] INT ) However, I've recently come across stored procedure code that specifies the schema name when creating temporary tables, for example: CREATE TABLE [dbo].[#Test] ( [Id] INT ) Is there any reason why you would want to do this? If you're only specifying the user's default schema, does it make any difference? Does this refer to the [dbo] schema in the local database or the tempdb database?

  Read the article

• jQuery and AJAX what should I use?

  - by thedp

  Hello, I've decided to go with jQuery for all my AJAX related client side needs. But jQuery has way too many functions for the same task: $.post, $.get, $.ajax, $.getJSON... My question is what should I use? Thank you.

  Read the article

• multiple 2 decimal place figure by a percentage

  - by YsoL8

  Hello A have price data stored like this: 10.25 And percentage data like this 1.1100 (1.00%) I need a function that accurately multiplies the price by the percentage. (in php) Thanks

  Read the article

• Convert.ToSingle() for float dat Type

  - by Asim Sajjad

  I have used many of the Convert.To..... functions for conversion , but I didn't understand one thing that for every datatype they have provide a Convert.To function but not for float datatype, in order to convert to float you need to use Convert.ToSingle() , why is this so ?

  Read the article

• How do you work with the hierarchyid data type in a dataset or object

  - by Luke101

  Hello, I would like to work with the hierarchyid in a dataset or custom object. I am not sure how to get parents, children, siblings and other functions will the data is in memory. I can do it within the database but once the info is pulled out of the database into a dataset and cached -- how do you work with it then?

  Read the article

• protecting non .aspx pages with Asp.net Membership provider

  - by Dave

  I'm currently using the asp.net membership provider (with logins stored in db) to protect certain pages of my site. However, I also have non .aspx resources I wish to protect - word docs, excel spreadsheets, pdfs, etc. Is this even possible? If so how would I go about doing this? thanks!

  Read the article

• Check if an object is defined in html

  - by Manikanta

  In HTML, I have an object tag as follows: <OBJECT ID="objectid" CLASSID="some-class-id" CODEBASE="some-codebase"> I have written a function in JavaScript to access this object. I checked the null value as follows: if(objectid==null){-----} i want to check if the object is undefined or is empty. Do we have any functions to check so?

  Read the article

• Landau notation (ide) tools support

  - by Jeriho

  It is good idea to have impotant information during developing like Landau notation to know functions's time costs. So it should be documented in sources isn't it? I'm looking for tools that can calculate it.

  Read the article

• jquery selecting element by data attribute

  - by zizo

  Is there an easy and straight-forward method to select elements based on their data attribute? For example, select all anchors that has data attribute named customerID which has value of 22. I am kind of hesitant to use rel or other attributes to store such information, but I find it much harder to select an element based on what data is stored in it. Thanks!

  Read the article

• Combining multiple classes gives me errors

  - by Martti Laine

  Hello I'm creating a website with structure like this: class main { } class mysql extends main { } class user extends main { } class etc extends main { } The idea is for these classes to use functions from each other. This doesn't work. How can I call a function from mysql in user? Martti Laine

  Read the article

• What's the best way to upload 1,000 (different) content files to a GAE Java web app every day?

  - by qiq

  I need to upload a large number of content files to an App Engine app every day - perhaps 1,000 or more - that will be served from the app. Cumulatively over time I expect these uploads to add up to over 1,000,000 separate content files stored in the production app. Is the appcfg tool the best or only way to carry out these daily batch file uploads?

  Read the article

• drop down box php

  - by DAFFODIL

  I have stored 6 records in mysql db,when i use this code each of the 6 records getting displayed in seprate drop down box,i want them to be displayed in a single drop down box.Where am i going wrong? Any help ii be appreciated. Thnx in advance. http://dpaste.com/hold/180077/

  Read the article

• How to Generate XSL code automatically ?

  - by B. Kumar

  Hello Everyone, I have UI which provide the facility to create own format by using drag and drop utility. I have also xml file which contains the data. Now task is how to automatically generate the .xsl file of the dynamically designed format for the data stored in xml form. If you have any idea about the solution of the above problem. I will thankful for any help regarding this… Thanks B. Kumar

  Read the article

• How to find about structure of bitmap and JPEG files?

  - by Sorush Rabiee

  I'm trying to write a very simple image processing program for fun and practice. I was using System.Drawing. ... .Bitmap class to handle images and edit their data. but now I want to write my own class of Bitmap object implementation and want to know how bmp files (and other common bitmap formats) and their meta-data (indexing, color system & etc) are stored in files, and how to read and write them directly?

  Read the article

• What are "Location" and "Repositories" in the VisualSVN?

  - by Roman

  I am trying to install VisualSVN to manage my code with other users. In the middle of the installation I have a window saying "Change if necessary installation path and initial VisualSVN Server setting". And after that (in the same window) I have two fields: "Location" and "Repositories". What these two parameters mean? I know URL where the common code is stored. Should I specify this URL in the "repositories" field?

  Read the article

• How can I start emacs with one process in the top window and another in the lower window of a frame.

  - by kpatelPro

  I have some processes that run from functions, i.e.: M-x run-proc1 M-x run-proc2 I would like to know what command to issue from the command line to run emacs with run-proc1 running in the upper window and run-proc2 running in the lower window. Thanks!

  Read the article

• What C headers for directory traversal are process safe in Linux ?

  - by bobby

  I'm currently using dirent.h and ftw.h for directory traversal at my CGI website 100% programmed in C. I am not sure if they are process safe; would various users interfere with each other while on my site ? Which functions would you recommend for this purpose ?

  Read the article

• jQuery Validate Element

  - by Idsa

  jQuery Validate plugin passes element value to inline validate functions. I'm trying to get element's id and an error telling that "element.attr is not a function" : function someFunction(element) { var elementId = element.attr('id'); } rules: { someFiled: { required: someFunction } }

  Read the article

< Previous Page | 282 283 284 285 286 287 288 289 290 291 292 293  | Next Page >