Search Results

Search found 14159 results on 567 pages for 'notes from the field'.

Page 318/567 | < Previous Page | 314 315 316 317 318 319 320 321 322 323 324 325  | Next Page >

• I want to do a sql update loop statement, by using the do--while in php

  - by Jean

  Hello, I want to loop the update statement, but it only loops once. Here is the code I am using: do { mysql_select_db($database_ll, $ll); $query_query= "update table set ex='$71[1]' where field='val'"; $query = mysql_query($query_query, $ll) or die(mysql_error()); $row_domain_all = mysql_fetch_assoc($query); } while ($row_query = mysql_fetch_assoc($query)); Thanks Jean

  Read the article

• Extract time part from TimeStamp column in ORACLE

  - by RRUZ

  Actually i' am using MyTimeStampField-TRUNC(MyTimeStampField) to extract the time part from an timestamp column in Oracle. SELECT CURRENT_TIMESTAMP-TRUNC(CURRENT_TIMESTAMP) FROM DUAL this return +00 13:12:07.100729 this work ok for me, to extract the time part from an timestamp field, but i' m wondering if exist a better way (may be using an built-in function of ORACLE) to do this? Thanks.

  Read the article

• how can i get the total from the four different table in single query

  - by karthikeyan1211

  In each table have many number of rows with amount. Like this i have different numbers of amount in each table. Each tables field name is different. How can i get the total of all values in the four tables in a single query? Any way is there?

  Read the article

• j2me/BlackBerry - How to send Email with Attachment from Application?

  - by SWATI

  hey i am building an application in which user can send an email to a person. The user enters the email id of the person to whom email is to be sent in a Edit field and then presses a send button the email must be delivered with an attachment. how can i do it?????? i m really confused after googling. can someone tell me the exact way also,cant i send email from simulator if my cod file is unsigned thanks in advance

  Read the article

• Database system that is not relational.

  - by paan

  What are the other types of database systems out there. I've recently came across couchDB that handles data in a non relational way. It got me thinking about what other models are other people is using. So, I want to know what other types of data model is out there. (I'm not looking for any specifics, just want to look at how other people are handling data storage, my interest are purely academic) The ones I already know are: RDBMS (mysql,postgres etc..) Document based approach (couchDB, lotus notes) Key/value pair (BerkeleyDB)

  Read the article

• Inserting random characters to MYSQL Database

  - by spotlightsnap

  I want to add 100 entry to users table numbers field, random characters length is 10, all entry should be unique as well. How can i achieve this using MYSQL query code ? Or do i need to use PHP ? Help me with code snippets please. Thanks.

  Read the article

• jQuery: How can I work with dates in this format? mm/yyyy

  - by Enrique

  I'm doing a web application for articles Articles must be shown by month, with its published date stored as mm/yyyy Now: 1- Should I use a DATE type field for storing? 2- Will jQuery UI datePicker be useful for showing mm/yyyy? 3- How could I sort by mm/yyyy? I guess it will be more complicated if I store date normally and extract the day from date each time I want to do something, right? Thanks,

  Read the article

• I need to save a String to a text file using Java

  - by Justin White

  I am a beginner Java programmer. I am attempting to make a simple text editor. I have got the text from the text field into a variable that's a String, called "text". My question is, how can I save the contents of the "text" variable to a text file? Thank you!

  Read the article

• How get the offset of term in Lucene ?

  - by Mehdi Amrollahi

  I want to get the offset of one term in the Lucene . How can i get it ? I vectored my content as Field.TermVector.WITH_POSITIONS_OFFSETS Is there any method in Lucene that give me offset of the term in one Document ?

  Read the article

• How can you tell which columns are unused in ALL_TAB_COLS?

  - by thecoop

  When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?

  Read the article

• JQuery input elements

  - by codeasp

  I need to get all input elements within a div and then attach event handlers, so that whenever values change it updates a hidden field. Children elements within the div might already contain event handlers, if so the attach should chain it. Any help is much appreciated.

  Read the article

• SQL Query That Should Return Least two days record

  - by Aryans

  I have a table "abc" where i store timestamp having multiple records let suppose 1334034000 Date:10-April-2012 1334126289 Date:11-April-2012 1334291399 Date:13-April-2012 I want to build a sql query where I can find at first attempt the records having last two day values and so second time the next two days . . . Example: Select *,dayofmonth(FROM_UNIXTIME(i_created)) from notes where dayofmonth(FROM_UNIXTIME(i_created)) > dayofmonth(FROM_UNIXTIME(i_created)) -2 order by dayofmonth(FROM_UNIXTIME(i_created)) this query returns all the records date wise but we need very most two days record. Please suggest accordingly. Thanks in advance

  Read the article

• mysql rollback when auto commit is on

  - by devang

  hi, by mistake i fired a update query and all the records in the table in dat field got updated nd also cannot rollback as auto_commit is on..is der ny other way in which i can retreive the records.plz help its urgent.. Thanks in advance

  Read the article

• How can I build a CountIF function in SharePoint?

  - by Paul

  CountIF function in excel , How do I use the same function in sharepoint Calculated Field. I want count number of "GO" from Column 1 to Column 12 i.e. Col 1 "GO", Col 2 "GO", Col 3 "No GO", Col 4 "GO": GOs=3

  Read the article

• How to copy a text array to a series of cells in Excel

  - by aSystemOverload

  I am dynamically creating a report, where I create a worksheet, bring in the records afresh. How can I easily type the field names and copy them to the cells. Without doing one cell per line, there are ~20 columns. I tried: dim fieldNames as variant fieldNames = ("'DS Date', 'A', 'B', 'A','S ASD', 'S','D S','D S', 'S','D S', 'SD', 'S','D'") Sheets("DATA").Range("C14:W14").Value = Application.WorksheetFunction.Transpose(fieldNames) But it just posts the whole thing in each cell? Any ideas?

  Read the article

• Are zip code and postal code violation of 3rd normal form?

  - by ojblass

  Given that state information is implicit in the zip code aren't storing both of them some violaiton of third normal form? Can or should you simply combine them into one field?

  Read the article

• Update table of two different database

  - by chetan

  This is the query to update table in one database that is of other Update test.temp a, test2.temp b Set a.name=b.name Where a.no=b.no; Now I don't want to write every field i.e a.name=b.name Is there any solution?

  Read the article

• Help with this JET Sql Query [SOLVED]

  - by yae

  Hi: I need help to do this query select. for example I have these fields: idInvoice date amount Depending of the date I need multiply the field "amount" for x number or other one. For example, if the date is less 01/01/2010 to multiply for 20 . But if it is major or equal to multiply for 35 Select idInvoice, date, amount, amount * varNumber from invoices

  Read the article

• How to display records below form on submission in php without the use of database?

  - by OM The Eternity

  How to make the use of hidden variables as array for consecutive submission of data so that they can be used to display the records list. I have a form with 4 text fields and a file upload field.. as i submit he form it should get appended to the list which needs to be displayed below the form, such that these values are NOT stored in the DB.. So in this case how can i use the post array to collect the data and display in the list below?

  Read the article

• How to display records below form on submission in php without the use of database?

  - by OM The Eternity

  I have a form with multiple fields in it along with a image input field, just below the form i have a list to be displayed on every submit of this form... this has to be done without the use of DB.. I think this can be achieved by using session but its not working with me, as evrytime page gets refreshed and session gets recreated/reset.. Please help me in resolving this issue

  Read the article

• How do I search for the comma character within data stored in SQL Server?

  - by Fred

  I have some data that I needs to be searched for the comma character. example entry I need to locate in the field Citation in the Citations table: This is sometimes true, Textual Reference In the end, I'm looking to extract Textual Reference Selecting the column with the data: select Citation from Citations;

  Read the article

• Is there a reference document for OOTB SharePoint web part interfaces?

  - by Javaman59

  I want my web parts to act as providers and consumers with OOTB SharePoint web parts, including filters. To design these web parts I need to know the interface of the OOTB web parts, eg. a "Links" web part provides an IWebPartRow, with a Type, URL and Notes. I can get the information by: a web part programmed to interact generically, and display the data it receives putting the web parts on a page, and look at the available connections inspecting the DLL's (haven't tried this, because I can't find the DLL's, but I guess it's possible) It seems strange to me that there is no documentation of these interfaces. Is there a Microsoft document, or a book, which documents the OOTB web parts and filters?

  Read the article

• How to Calculate longest streak in SQL?

  - by VJ

  I have EMPLOYEE-ID,DATE,IsPresent I want to calculate longest streak for a employee presence.The Present bit will be false for days he didnt come..So I want to calculate the longest number of days he came to office for consecutive dates..I have the Date column field is unique...So I tried this way - Select Id,Count(*) from Employee where IsPresent=1 But the above doesnt work...Can anyone guide me towards how I can calculate streak for this?....I am sure people have come across this...I tried searching online but...didnt understand it well...please help me out..

  Read the article

• Retrieving substring of a bound value

  - by shivesh

  I am binding some data to control, but want to limit the number of character of a specific field to a 30 first characters. I want to do it, if it's possible, on aspx page. I tried this: Text='<%# String.Format("{0}", Eval("Title")).Substring(0,30) %> ' But got this error: Index and length must refer to a location within the string. Parameter name: length

  Read the article

• mysql command for update

  - by Mac Taylor

  hey guys i need to add a special text to all rows in my mysql table , how to add some text to the end of all rows' content in a table just for one field i used this code : UPDATE `blogs` SET `title`= `title`+ 'mytext'; but didnt work for me

  Read the article

< Previous Page | 314 315 316 317 318 319 320 321 322 323 324 325  | Next Page >