Search Results

Search found 11632 results on 466 pages for 'to field'.

Page 250/466 | < Previous Page | 246 247 248 249 250 251 252 253 254 255 256 257  | Next Page >

• 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

• 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

• Registration with profile picture using services in Drupal

  - by Fran Ruano

  I've been trying to upload a user profile picture during the user registration using Service 3 and so far I haven't had any luck. I tested passing a hard coded fid in the field "picture" and also tried to pass the fields "filemime", "filename", etc. and it didn't work neither. Any idea about what fields I need to populate? I guess it must be related to this post Using Drupal Services and DIOS SDK for setting user picture in iOS app but it doesn't have and answer neither.

  Read the article

• mysql get last auto increment value

  - by Mick

  Hi I have a field in mySql table called jobnumber which auto increments with each new entry. What I want to do is when a user views my form, get the value of the next 'jobnumber' . But I want to do this before any entry is made to the table. IE so when a user looks at a form it will display something like 'this is job number 6954' I have tried $rr = mysql_insert_id() but this only work after I have made an entry Can anyone help please thanks

  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

• 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

• Which command would replace IDENTITY INSERT ON/OFF from SQLServer in Oracle?

  - by rodrigoq

  Hello, I have to migrate this query (simplified here) from T-SQL to ORACLE SET IDENTITY_INSERT table ON INSERT INTO table (id, value) VALUES (1, 2) SET IDENTITY_INSERT table OFF id being an Identity field in SQLServer. I have the same table with a sequence in ORACLE, I couldn't find a snippet that shows how to disable the sequence and set it to start again with the MAX(id) + 1. Any ORACLE expert can help me with this? Thanks, Rodrigo.

  Read the article

• SQL Server: how to create multiple text files from a table

  - by Patrick

  hi, I need to extract data from my SQL Server database into multiple text files. I have a table with 4 columns: UserID, UserName, Tag, Score. I need to create a text file for each Tag (so basically I need to group by Tag and order by score). Before to start I would like to know what's the fastest way to create several text files: File titles = TAG field each line = userID

  Read the article

• 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

• 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

• 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

• 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

• 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

• Getting details of a DLL in C#/.NET

  - by gt

  Is there a way to get the values of various properties of a (both .NET and non-.NET) DLL via C#? I'd like to read the 'Product name' field in particular.

  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 enumerate strings in a string resources file ?

  - by Mina Samy

  Hi all I have a resources file called string.xml in res/valus directory the file has many string resources how can I obtain these items in an array from code ? I tried Field[] x=R.string.class.getFields(); but it does not work. thanks

  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

• 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

• 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

• Codeigniter: Get affected fields in update

  - by Roberto

  There's a way to get which fields were modified after a update query? I want to keep track what field XXX user modified... any ways using active records?

  Read the article

• Zend framework forms, upload file problem

  - by bounce

  Hi, I use Zend forms in my web application. I wonder where Zend puts uploded temp file by default ? I can't find it in server tmp dir. For example if I upload image(1.jpg) via file field, it appears on tmp folder, but as 1.jpg(/tmp/1.jpg). But I need temporary file like /tmp/phpeZApBn. Maybe it is in any other location ? Any help would be appreciated.

  Read the article

• Visual Studio 2010 'Assign to local variable' function?

  - by Frank Meulenaar

  I'm in love with the function in Eclipse "assign to field". Basically, when I have getString(); and I type ctrl-2, Eclipse converts this into String getString = getString(); Is this possible in VS 2010?

  Read the article

• MySql insert data in multiple table at a time

  - by Sanjay

  hi, i have a query regarding to insert data in multiple table.. i have a two tables. one is item table and second is field table. i want to insert data in both table with one query at a time. any idea about it.

  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

• 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

< Previous Page | 246 247 248 249 250 251 252 253 254 255 256 257  | Next Page >