Search Results

Search found 27530 results on 1102 pages for 'sql truncate'.

Page 923/1102 | < Previous Page | 919 920 921 922 923 924 925 926 927 928 929 930  | Next Page >

• Moving file security from one server to another (asp.net sites, IIS)

  - by Imageree

  I am running windows server with asp.net websites and sql server 2008 and IIS 6. It is working fine. Now I need to move my asp.net websites to another windows server and I have hard time setting correct file security for the new server. Is there any way to compare or move or see difference file security between two servers?

  Read the article

• Preparation of preloaded user data

  - by Dave

  How do you all actually go about doing that? Currently what we will do is send the excel file to users they will fill in the info and we will use excel concatenation to generate the corresponding SQL scripts I kist thinking if there is any better way

  Read the article

• Loop through resultset and add create comma seprated string in ASP Classic

  - by Sam

  Here's my ASP Classic: set irs = recordset(sql,PageDB) if not irs.eof then dim new_list new_list = "" do while not irs.eof 'Add irs("name") to new_list and seperate by comma irs.movenext loop end if kill(irs) How would I add irs(name) to new_list and seperate by a comma?

  Read the article

• UTF-8 - Oracle issue

  - by goe

  I set my NLS_LANG variable as 'AMERICAN_AMERICA.AL32UTF8' in the perl file that connects to oracle and tries to insert the data. However when I insert a record with one value having this 'ñ' character the sql fails. But if I use 'Ñ' it inserts just fine. What am I doing wrong here?

  Read the article

• simple php Dollar $ evaluation in string questions

  - by Mirage

  I have always been confused that .e,g in php i have sql statement $qry = "select * from table where id = $id"; now can i insert "$" directly inside the quotes or i have to use $qry = "select * from table where id =".$id." "; or $qry = 'select * from table where id = $id'; or $qry = 'select * from table where id = '$id''; Which is correct

  Read the article

• CakePHP - get last query run

  - by Phantz

  I want to get the last query CakePHP ran. I can't turn debug on in core.php and I can't run the code locally. I need a way to get the last sql query and log it to the error log without effecting the live site. This query is failing but is being run. something like this would be great: $this->log($this->ModelName->lastQuery); Thanks in advance.

  Read the article

• How can I create a small relational database in MySQL?

  - by Sergio Tapia

  I need to make a small database in MySQL that has two tables. Clothes and ClotheType Clothes has: ID, Name, Color, Brand, Price, ClotheTypeID ClotheType has: ID, Description In Microsoft SQL it would be: create table Clothes( id int, primary key(id), name varchar(200), color varchar(200), brand varchar(200), price varchar(200), clothetypeid int, foreign key clothetypeid references ClotheType(id) ) I need this in MySQL.

  Read the article

• How to concetanate a CHAR

  - by iFloh

  really basic question, I have a string to generate as SQL statement that I need to run through a loop to add all the relevant criteria. How do I concetatate the statement.

  Read the article

• What are the Java equivalents to Linq and Entity Framework

  - by Colin Desmond

  Having played with Linq (to SQL and Objects) as well as the Entity Framework from Microsoft recently, I was wondering what the non-.Net (specifically Java) equivalents are?

  Read the article

• how do I execute a function from TOAD for Oracle and bind the result to a data grid

  - by neesh

  I have a function that takes as one of it's arguments a VARRAY of pl/sql Objects. How do I execute this stored procedure and bind the resultset that it returns to a data grid in TOAD for Oracle?

  Read the article

• cx_Oracle and output variables

  - by Tim

  I'm trying to do this again an Oracle 10 database: cursor = connection.cursor() lOutput = cursor.var(cx_Oracle.STRING) cursor.execute(""" BEGIN %(out)s := 'N'; END;""", {'out' : lOutput}) print lOutput.value but I'm getting DatabaseError: ORA-01036: illegal variable name/number Is it possible to define PL/SQL blocks in cx_Oracle this way?

  Read the article

• Alternative to Windows Azure tables out of the cloud

  - by John Grey

  Hi :) I'm developing a .NET app, which needs to run both on Azure and on regular Windows Servers(2003). It needs to store a few GB of data and SQL Azure is too expensive for me, so I'll use Azure tables in the cloud version. Can you recommend a storage solution, which will run on standalone servers and have an API and behavior similar to Azure tables? From what I've seen Server AppFabric does not include Tables. TIA

  Read the article

• Cleansing string / input in Coldfusion 9

  - by Jakub

  I have been working with Coldfusion 9 lately (background in PHP primarily) and I am scratching my head trying to figure out how to 'clean/sanitize' input / string that is user submitted. I want to make it HTMLSAFE, eliminate any javascript, or SQL query injection, the usual. I am hoping I've overlooked some kind of function that already comes with CF9. Can someone point me in the proper direction?

  Read the article

• Does Vista prevent changes in Program Files directory?

  - by vfclists

  I have a program developed for Windows XP, but when I try to install it in Windows Vista, I get an error message saying that the SQL database (sqlite3) is read only. Is that due to a feature in Windows Vista?

  Read the article

• How to configure Entity Framework 4 to prevent drop when generate database

  - by csharpnoob

  Hi, is there any option when updating classes in EF4 Modeller to disable the drop of all data and tables, just to append non existing fields and leave old tables and data untouched. I mean not to change every time on every little change to edit manual the SQL files. Thanks.

  Read the article

• What exactly is Arel in Rails 3.0?

  - by Will

  I understand that it is a replacement for ActiveRecord and that it uses objects instead of queries. But... why is this better? will objects/queries be "easier" to create? will it lead to more efficient SQL queries? will it be compatible with all major DB's? - I assume it will. will it be easier/harder to use with stored procedures?

  Read the article

• How do I protect my website from javascript injection attacks when using rich text editors?

  - by VJ

  Hi all I am using the markitup editor to get the value for one of my fields and storing it a sql server 2008 db. Now I guess the problem is people having script tags and javascript in the editor and injecting malicious scripts and I have my validate input turned false. So can anyone suggest me a way to write a custom validation method that maybe checks for script tags and removes them...or just guide me through the steps i need to do ?...also are there other things also that I should be worried about..?

  Read the article

• need a good frontend for MySQL for beginner user

  - by aadersh patel

  implementing a database and need an easy to use frontend. Have tried: HeidiSQL - editing fields was very tedious MySQL-Front - wasnt adding tables through the SQL Editior, and only updated when the prog was restarted. Can anyone recommend a Frontend which they think would be appropriate? Many thanks

  Read the article

• Linq - get compare with transliterated value of fields

  - by Maxim

  Hi! I have a table (sql server). One of its columns ('Name') Contains Cyrillic values. From parameters i recieve value, that contains in this field but the are transliterated. i mean something like: var q = from r in m_DataContext.Table where CTransliteration.Transliterate(r.Name).Contains(trans_text) select r; How can i transliterate value on-fly?

  Read the article

• Mysql Query problem ?

  - by deep

  ID NAME AMT 1 Name1 1000 2 Name2 500 3 Name3 3000 4 Name1 5000 5 Name2 2000 6 Name1 3000 consider above table as sample. am having a problem in my sql query, Am using like this. Select name,amt from sample where amt between 1000 and 5000 it returns all the values in the table between 1000 and 5000, instead I want to get maximum amount record for each name i.e., 3 name3 3000 4 name1 5000 5 name2 2000

  Read the article

• Many returned records cause stackoverflow with Hibernate

  - by mimi law

  If there are many return records from DB. It will get stackoverflow problem. User is a class, which has a one to many relationship (to 3 other classes). When I print out the SQL, i found that the system runs the same query many time to get the data from DB. Does anyone know what the problem is? result.addAll(getCurrentSession().createCriteria(User.class) .add(Restrictions.ilike("name", "tom", MatchMode.ANYWHERE)) .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) .list());

  Read the article

• mysqldump command not working?

  - by Harish Kurup

  I am using mysqldump to take backup of my database, but the command is not working.. the command i am using is mysqldump -u root dbname> 'c:\backupdatafolder\backup.sql' i am running this command in MySQL cli but not running,..is there any thing wrong in the command?

  Read the article

• data display in gridview with diffent color depends on text in asp.net

  - by sravan-grs

  I am displaying student attendance in Gridview from sql server. i choose apsent as A, present as P and leave as L. Now i would like to display A in red color, P in green in Gridview. How is it. please help me

  Read the article

• Entity Framework with XML Files

  - by Tim

  Can someone point me to a good tutorial explaining the Entity Framework using an XML file instead of a database? I have seen some good tutorials with SQL databases, but I can't make the leap to an XML file. Thanks!

  Read the article

• How to increase SOAP ENVELOPE size in android?

  - by Narendra

  In my project I am calling a web-service which giving response back as thousands of records from SQL server but as default size of SOAP ENVELOPE is 64KB I am getting only first 15 records in my logcat...Will please somebody tell me to increase my SOAP ENVELOPE size to 10 MB so that I can fetch all the results....I have searched over internet but didn't get any answer regarding this, my code is as below... SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11); envelope.setOutputSoapObject(request); envelope.dotNet = true;

  Read the article

< Previous Page | 919 920 921 922 923 924 925 926 927 928 929 930  | Next Page >