Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 557/1278 | < Previous Page | 553 554 555 556 557 558 559 560 561 562 563 564  | Next Page >

• How do I protect against cross-site scripting?

  - by shahinkian

  I am using php, mysql with smarty and I places where users can put comments and etc. I've already escaped characters before inserting into database for SQL Injection. What else do I need to do?

  Read the article

• SQL Query to truncate table in IBM DB2

  - by Cshah

  Hi, Can any one give me the syntax to truncate a table in IBM DB2. I m running the following command: truncate table tableName immediate; The eror is DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=table;truncate ;JOIN , DRIVER=3.50.152 Message: An unexpected token "table" was found following "truncate ". Expected tokens may include: "JOIN ".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.50.152 The syntax matches the one specified in the reference docs of IBM : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_truncate.htm

  Read the article

• Online validators, syntax checkers, testing tools

  - by Max Gontar

  I often need to verify some simple code before posting, and it's great if I have installed IDE, but what if not? It would be nice to have online free tools for SQL, VB.NET, C# code validation, or maybe even testing. EDIT What I actually mean are online live web tools, like JSLint for javascript. Have you seen any?

  Read the article

• Strip OLE header information (MS Access / SQL Server)

  - by crimson13

  I have a C++ application that needs to support binary database content (images, etc). When using MS Access or MS SQL Server this data is wrapped inside an OLE object. How do I strip this OLE header information? Note that I can't just look for the beginning of a specific tag as the content can be png, jpg and a whole heap of other formats. Should I use something like COleDataObject?

  Read the article

• Where can I find an introduction to using PDO?

  - by aslum

  I know my SQL safety isn't up to par. I've read on this site that PHP PDO would be a good first step, and while I did take a look at the PDO Manual it's a bit daunting. Is there somewhere I can find a tutorial on the basics of using PDO rather then straight MySQL calls?

  Read the article

• How to force username and password entry in C# / VS web app?

  - by salvationishere

  I am trying to force user to enter username and password when they run my C#/SQL web application. This was developed in VS 2008 on a 32-bit XP. The current connection string I'm using in my web.config file is: But it still doesn't prompt for a username and password. What am I missing?

  Read the article

• Creating an index on a view with OpenQuery

  - by Sung Meister

  SQL Server doesn't allow creating an view with schema binding where the view query uses OpenQuery as shown below. Is there a way or a walk-around to create an index on such a view?

  Read the article

• Invoking a PL/SQL function from EclipseLink

  - by Mark Robinson

  I'm trying to execute a PL/SQL function in EclipseLink which uses Oracle Specific types(eg. Boolean). I've tried using PLSQLStoredProcedureCall which complains that I'm not executing a procedure and I have tried using StoredFunctionCall but that returns PLS-00382: expression is of wrong type Has anyone developed a solution to invoke functions in EclipseLink with Oracle Types? I have heard that it would be possible to extend StoredFunctionCall but I'd rather leverage existing functionality as much as possible.

  Read the article

• Visual Studio Setup Project Installer Prerequisite for SQL Server CE

  - by blu

  I have a Setup Project in my solution in Visual Studio 2008 SP1. The application installs fine but it is not loading my prerequisite of SQL Server CE. I have the following configurations set: Do I need to do anything else, like with a Custom Action or anything like that? Thanks.

  Read the article

• ASP.NET Membership vs SQL Authentication

  - by Gern Blandston

  For ASP.NET MVC extranet applications, what are the pros and cons of using SQL Authentication instead of the ASP.NET Membership API to handle security?

  Read the article

• Using the using statement with WinForms... Good Practice?

  - by Nate Heinrich

  I understand the concept and reasons behind using the using statement, and I use it with things like file resources and remote connections, I was wondering if it is good practice to use the using statement with WinForm forms and dialogs? using (MyDialog dlg = new MyDialog()) { if (dlg.ShowDialog() == EDialogResult.OK) { // Do Something } } Thanks!

  Read the article

• set datasource crystal report 10 at runtime using vb 6.0 and SQL server 2005

  - by rah.deex

  Please help... I am so confused, how to set Crystal Report 10 data source at runtime using VB 6.0. I am using SQL SERVER 2005 for database and I create the reports using stored procedure.. do You have any idea to solve my problem ? thanks before..

  Read the article

• The entity framework and database agnostic programming, possibilities?

  - by Theo

  We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too. It should be easy to switch the db vendor by some setting in a config file. Is this possible? I prefer real life examples! What kind of providers did you use?

  Read the article

• SQL to join to the best matching row

  - by williamjones

  I have a wiki system where there is a central table, Article, that has many Revisions in their own table. The Revisions each contain a created_at time and date column. I want to update the Articles to contain a denormalized field sort_name from the most recent Revision's name field. What SQL command can I issue to fill in each Article's sort_name field with its most recent Revision's name field? For what it's worth, I'm on PostgreSQL.

  Read the article

• Data Conversion

  - by cre-johnny07

  How do I convert 0.50 to 50 or 0.1429 to 14.29 in sql query? My data type is real.

  Read the article

• Visual Representation Of Database Schema

  - by Richard Knop

  is there some standard about how to graphically represent database schemas? Is UML a defacto standard for this? Also, is there some free tool that can help me convert an sql file (basically bunch of CREATE TABLE queries) into some nice graph (UML or not UML)?

  Read the article

• SQL GUI Programs

  - by jake

  Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.

  Read the article

• Check if a string contains a substring in SQL Server 2005 Stored Procedure

  - by NLV

  Hello I've a string @mainString = 'CATCH ME IF YOU CAN'. I want to check whether the word 'ME' inside @mainString. So how to check if a string has a substring in sql? Thank you Regards NLV

  Read the article

• How to Configure TreeView to display data from SQL Server

  - by Ani

  I have a Browser and I want to display history & favorites of user on webbrowser on button_Click event. Can I accomplish this by using treeview in my form? if not what other way i can use. Data about History and Favorites is stored in SQL server database. Thanks, Ani

  Read the article

• Removing Database References from an ASP.NET MVC Site

  - by Maxim Z.

  I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance. Can I completely remove this dependency? If so, how do I get rid of all this database stuff?

  Read the article

• Capabilities and pricing of Amazon's cloud computing platform?

  - by ajl

  I'm finding it very hard to estimate how much my web application might cost running in Amazon's cloud? My app is similar to stackoverflow.com - asp.net, ajaz, sql database. Can anyone estimate how much it might cost to run stackoverflow in Amazon's cloud?

  Read the article

• SQL is declarative, what about LINQ

  - by pokrate

  I can change SQL at runtime. Can I do the same with LINQ ? Can I have LINQ queries coming from an xml file, which I can edit at runtime ?

  Read the article

• Refresh tables in Visual Studio?

  - by Curtis White

  How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express. The clear results does not seem to refresh.

  Read the article

• How to show the user one day behind messages in Vb.net webform?

  - by ahmed

  I am working on a Incoming and outgoing messages webform, I would like to show the users the only messages in their INBOX of one day behind. I have a dropdown where I'm giving the selection of All and Pending messages. But if the users have any pending messages in INBOX of just one day behind ,they have to choose All to retrieve the messages. So how do I retrieve messages from message table of just one day behind ? I am using SQL 2000 vb.net web application.

  Read the article

• Is there any better search method instead of string.Contains("keyword") using asp.net?

  - by Mike108

  For example, the users of our app want to search products by entering a keyword of productName. The Products table of the sql server database contains about 10 million records. Is there any better and higher-performance search method implement instead of productName.Contains("keyword") using asp.net C# ?

  Read the article

< Previous Page | 553 554 555 556 557 558 559 560 561 562 563 564  | Next Page >