Search Results

Search found 17884 results on 716 pages for 'column types'.

Page 363/716 | < Previous Page | 359 360 361 362 363 364 365 366 367 368 369 370  | Next Page >

• Best way to stop SQL Injection in PHP

  - by Andrew G. Johnson

  So specifically in a mysql database. Take the following code and tell me what to do. // connect to the mysql database $unsafe_variable = $_POST["user-input"]; mysql_query("INSERT INTO table (column) VALUES ('" . $unsafe_variable . "')"); // disconnect from the mysql database

  Read the article

• MySQL ORDER BY offset

  - by monk.e.boy

  In a MySQL query how would I select: all rows ordered by column 'name' where name 'f' so I'd get Gs, Hs ... Xs, Ys, Zs, As, Bs, Cs ... Fs.

  Read the article

• Best C++ static & run time tools

  - by Hortitude

  Apologies if I missed this question already, but I searched and couldn't find it. I have been out the C/C++ world for a little while and am back on a project. I was wondering what tools are preferred today to help with development. The types of tools I'm referring to are: Purify Electric Fence PC-Lint cscope Thanks!

  Read the article

• MySQL: Which is faster — INSTR or LIKE?

  - by Grekker

  If your goal is to test if a string exists in a MySQL column (of type 'varchar', 'text', 'blob', etc) which of the following is faster / more efficient / better to use, and why? Or, is there some other method that tops either of these? INSTR( columnname, 'mystring' ) > 0 vs columnname LIKE '%mystring%'

  Read the article

• Mysql - Get # of months and years

  - by jwzk

  Is there any way to get the # of months and years since a date, using the mysql DATE column? So if I enter 1/1/2009.. I want 1 years, 3 months.. and so on.

  Read the article

• double precision in Ada?

  - by yCalleecharan

  Hi, I'm very new to Ada and was trying to see if it offers double precision type. I see that we have float and Put( Integer'Image( Float'digits ) ); on my machine gives a value of 6, which is not enough for numerical computations. Does Ada has double and long double types as in C? Thanks a lot...

  Read the article

• Cannot have a qualifier in the select list while performing a JOIN w/ USING keyword.

  - by JuiceBerry123

  I am looking at a practice test that doesn't have explanations about the correct answers. The question I'm confused about basically asks why the following SQL statement can never work: SELECT oi.order_id, product_jd, order_date FROM order_items oi JOIN orders o USING(order_id); The answer it gave was: "The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list" Can someone elaborate on this? I am pretty stumped.

  Read the article

• Detect variance on generic type parameters of interfaces

  - by Water Cooler v2

  Is there a way to reflect on an interface to detect variance on its generic type parameters and return types? In other words, can I use reflection to differentiate between the two interfaces: interface IVariant<out R, in A> { R DoSomething(A arg); } interface IInvariant<R, A> { R DoSomething(A arg); } The IL for both looks the same.

  Read the article

• Entity Framework - How do create an association to/from the same entity?

  - by Greg

  Hi, In Entity Framework (VS2010) how do I create an association to/from the same table? (a many-to-many is what I want) Background - I was expecting under the bonnet a NODE and RELATIONSHIP table, where the latter has a parent_node_id and a child_node_id (i.e. pointing back to the NODE id column). I can't seem to get the designer to add it...

  Read the article

• The Next-gen Databases

  - by Randin

  I'm learning traditional Relational Databases (with PostgreSQL) and doing some research I've come across some new types of databases. CouchDB, Drizzle, and Scalaris to name a few, what is going to be the next database technologies to deal with?

  Read the article

• ListBoxItem height not getting updated

  - by Gili

  Hi, I have a listbox inside another list box, in inner list box listboxitems height may grow or shrink. My problem is that when the inner items shrink the outer list box doesn't re-render its height. Thus - stays with the previous height before the inner list shrinked. I have tried so many things here, among Invalidate of all types, selection and de-selection of the list box item that should be updated and more - nothing helps.... Can anyone pls help me with this? Thanx, Gili

  Read the article

• having condition on result of a subquery in mysql

  - by naiquevin

  hi i am trying to run a query like this SELECT a, b , c, (SELECT INNULL(x,y)) as mycol WHERE mycol < 400 ; BUt it gives the error #1054 - Unknown column 'mycol' in 'where clause' What would be the right way to do this? Thanks.

  Read the article

• Email from an app, but not use a a pop up controller, just text inside a text box.

  - by Sam Jarman

  Hey is there any way to send whats in a text view (im trying to make a suggestion box) to my email address? example user types in the box " I think you should add twitter support" then that is sent in the background to my email address [email protected] then a message is popped up on the screen saying "suggestion sent" just an example of what i mean Any ideas, tutorial links would be greatly appreciated guys Thanks

  Read the article

• Using data from a dataset in styles with Mapnik

  - by Alex King

  I've setup Mapnik to connect to a PostGIS database, and display geometry. I'd like to have a column in my database called opacity, and use it as the opacity for that row of geometry when Mapnik renders it. So far, I've only found information on how to display text from the database, and how to use filters to display different styles when database values are within parameters. Nothing about how to use the values directly inside of a style or layer though - is this possible?

  Read the article

• Exception in inserting data into data using JPA in netbeans

  - by sandeep

  SEVERE: Local Exception Stack: Exception [EclipseLink-7092] (Eclipse Persistence Services - 2.0.0.v20091127-r5931): org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot add a query whose types conflict with an existing query. Query To Be Added: [ReadAllQuery(name="Voter.findAll" referenceClass=Voter jpql="SELECT v FROM Voter v")] is named: [Voter.findAll] with arguments [[]].The existing conflicting query: [ReadAllQuery(name="Voter.findAll" referenceClass=Voter jpql="SELECT v FROM Voter v")] is named: [Voter.findAll] with arguments: [[]].

  Read the article

• Prevent some DataColumns in a DataTable from being bound to DataGridView

  - by Rajarshi

  Is there any way I can specify that some columns in a DataTable will not be automatically bound to a DataGridView when I set the DataSource property of the DataGridView to the DataTable. For example, if I have a DataTable with columns as "Id, Name" then can I specify that Id column will not be shown in DataGridView? I know I can set some Visible property in DataGridView after it is bound, but can I specify in the DataTable/DataColumn itself?

  Read the article

• Multiple conditions on select query

  - by stats101

  I have a select statement and I wish to calculate the cubic volume based on other values within the table. However I want to check that neither pr.Length_mm or pr.Width_mm or pr.Height_mm are NULL prior. I've looked at CASE statements, however it only seems to evaluate one column at a time. SELECT sa.OrderName, sa.OrderType, pr.Volume_UOM ,pr.Length_mm*pr.Width_mm*pr.Height_mm AS Volume_Cubic ,pr.Length_mm*pr.Width_mm AS Volume_Floor ,pr.Length_mm ,pr.Height_mm ,pr.Width_mm FROM CostToServe_MCB.staging.Sale sa LEFT JOIN staging.Product pr ON sa.ID = pr.ID

  Read the article

• Gnuplot - splot matrix csv data

  - by Jakub Czaplicki

  How can I plot (a 3D plot) a matrix in Gnuplot having such data structure. I cannot find a way to use the first row and column as a x and y ticks (or to ignore them) ,5,6,7,8 1,-6.20,-6.35,-6.59,-6.02 2,-6.39,-6.52,-6.31,-6.00 3,-6.36,-6.48,-6.15,-5.90 4,-5.79,-5.91,-5.87,-5.46 Is the splot 'data.csv' matrix the correct parameter to use ?

  Read the article

• How about performance of linq to sql, Entity Framework and NHibernate?

  - by Abonec

  I was learning this ORM because think this is good technology for most projects. But most employers required acquirement of ADO.NET and SQL. This ORM not will use in high-loaded system (like popular web-sites)? In which types of projects this ORM will be useful? Are highly loaded projects using ORM?

  Read the article

• C# naming convention for constants other than Pascal and All Caps

  - by Ismail S

  In my project currently we are using All caps as naming convention for constants. I would like to change it and I'm OK for me but my team lead has a strong argument that it will not visibly distinguish constant from Properties and other Types. Please help me with any other suggestions.

  Read the article

• Formula to follow addition of rows

  - by Wayne McCaslin

  New to VBA, please help. I have a range say A2:D10; input causes rows to be added. New entries are being added using NextRow=_. Works perfectly, however, how do I get the formulas in columns C and D to follow each new row being added. I cannot just format entire column due to my sort criteria. Example formula is =IF(ISTEXT($B11),$C$2-$D11,"")

  Read the article

• Functional programming approach for Java's input/output streams

  - by Elazar Leibovich

  I'm using Java's DataInputStream with scala to parse some simple binary file (which is very bad exprerience due to the lack of unsigned types, even in scala, but that's a different story). However I find myself forced to use mutable data structure, since Java's streams are inherently state preserving entities. What's a good design to wrap Java's streams with nice functional data structure?

  Read the article

• How may I scroll with vim into a big file ?

  - by Luc M

  Hello, I have a big file with thousands of lines of thousands of characters. I move the cursor to 3000th character. If I use PageDown or <CTRL>-D, the file will scroll but the cursor will come back to the first no-space character. There's is an option to set to keep the cursor in the same column after a such scroll ? I have the behavior with gvim on Window, vim on OpenVMS and Cygwin. Regards

  Read the article

• get a simple list from sqlite in python (not a list of tuples)

  - by Jeremiah Rose

  it's annoying how sqlite always returns a list of touples! i can see the why this is necessary, but when i am querying a single column, how do i get a plain list? e.g cursor.fetchall() returns [(u'one',), (u'two',), (u'three',)] from this, how do i get the simple list [u'one', u'two', u'three']?

  Read the article

• PHPMailer attachment type and size limit

  - by SomeoneS

  i have one form and i am using PHPMailer to send data from that form to my email. Users can send attachments as well, but i have one rpoblem: how to make PHPMailer to deny attachments larger than 2Mb and to allow only iamge attachments (no other types of documents)? This is code i using for multiply email attachments with PHPMailer: foreach(array_keys($_FILES['fileAttach']['name']) as $key) { $source = $_FILES['fileAttach']['tmp_name'][$key]; $filename = $_FILES['fileAttach']['name'][$key]; $mail->AddAttachment($source, $filename); }

  Read the article

< Previous Page | 359 360 361 362 363 364 365 366 367 368 369 370  | Next Page >