Search Results

Search found 10077 results on 404 pages for 'techie db'.

Page 226/404 | < Previous Page | 222 223 224 225 226 227 228 229 230 231 232 233  | Next Page >

• how to enforce multiple unique fields in database table

  - by oo

  i have a table called Cars and the primary key of the table is 'id'. I also have a field called 'name'. I would like to make sure no one enters the same name twice even though it wont break my db integrity. what is the best way of doing this?

  Read the article

• Variable table or column names.

  - by Frank Computer

  INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.brach char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names.

  Read the article

• mysql - How select a akin records?

  - by zeroonea

  I have a table with name varchar address varchar country varchar city varchar ..... to store address of location example: name|address|country HaLong hotel|156 blahblah street|Vietnam Hotel Ha Long|156 blah blah|Vietnam Two rows above is duplicate data. I have a form, when user submit new location. The code need to find akin records to give a message (ex: This location already in db, use it or create new?) How to make a query to get akin record like this?

  Read the article

• LoadControl - from string variable

  - by creo

  If e.g. I keep control markup in DB instead of ascx file. How can I load control from string constant? (of course if I don't want to save copy to disk)

  Read the article

• How to send the my sql result to controller in codeigniter as a variable

  - by udaya

  Hi In my mode I am selecting a field as $query1 = $this->db->query("SELECT dPassword FROM tbl_login WHERE dEmailID='[email protected]'"); How to return dpassword as a variable to my controller I tried this way return dpassword;

  Read the article

• How do I set prifix to django contrib tables names?

  - by Software Enthusiastic

  HI One of my requirement is to have prefix on all the tables of the django based project (Because db is hosted on shared server). I have used db_table Meta option to set the prefix for the tables which I have created. Now my query is how do I set the prefix for tables provided by django.contrib. Instead of auth_group django should create prefix_auth_group.... How do I do that? Thank you very much...

  Read the article

• slot booking problem

  - by pradeep

  Hi, I am making a doctor appointment slot booking mechanism,where in doctor appointment slots will be divided into 30 mins slot each...i have achieved all the working code.. 1 problem i am facing is that..this booking is made at 2 places i.e 2 receptions..so when 1 selects a slot(radio button) not yet confirmed and saved in DB.other reception must not be able to select .how do i do it.any help on this...how do i go abt it.

  Read the article

• Can I use anything other than BIGINT as Primary Key data type in SQLite?

  - by weenet

  I was psyched about the possibility of using SQLite as a database solution during development so that I could focus on writing the code first and dynamically generating the db at runtime using NHibernate's ShemaExport functionality. However, I'm running into a few issues, not the least of which is that it seems that SQLite requires me to use Int64 for my primary keys (vs, say, Int32 or Guid). Is there any way around this?

  Read the article

• WPF Application with Database.

  - by mike

  Hi, i would like to or need to use a database for my wpf project. It has to store "person" "team" "goals" and maybe 2 more things, nothing very big. Ive already used (worked) with databases in java / php (postgresql), but is there maybe an "easier" way to store the things.. i mean if the db is going to be big than i could use (postgre or mysql), but this one would be small.

  Read the article

• Best approach to developing a cross-browser javascript widget that populates from a MySQL database?

  - by MindSculpt

  I'm currently researching the best way to approach building a javascript widget someone can embed on their site, which would retrieve and display information from an external MySQL database. The gist of the widget would mimic the needs/functionality of Twitter's widget (http://twitter.com/about/resources/widgets), where it uses some combination of JS, PHP and/or AJAX and retrieves information from a MySQL DB with secure (or at least somewhat safe) cross-browser access. Thoughts or ideas on the best and most reliable way to approach something like this?

  Read the article

• dynamic meta data and description for pages

  - by pradeep

  Hi, I am developing pages in php dynamically i.e data gets filled up from mysql DB. how do i assign a proper meta data and description for these dynamic pages so that google recognises it properly. What needs to be passed in page so that google takes description properly. when i search a page in google. it takes the data in page as description not description tag contents

  Read the article

• how to store hour and minute in database table while using mktime() function?

  - by Learner Miz

  I am using a form to get the hour and minute using post method and then store it to mysql DB. Such as : $hour = $_POST['hour']; $minute = $_POST['minute']; ** There is no need of date, month and year. I just need to store the hour and minute in a column of a table (ex: exam_time) Column structure: exam_time time NOT NULL Now how to store these value into database using mktime() function. I tried but it stores 00:00:00, not the one which I am sending via form.

  Read the article

• Fetch third party data and store in rails application variable

  - by mark

  Hi I need to do periodical background task fetching data from a weather site. How in rails can I fetch json from a remote url and store it on the server? Also, there doesn't seem to be any point in storing this in a db so how in rails can I store a variable available to all users?

  Read the article

• Importing data and keeping ids and relationships

  - by Justin Hamade

  I am working on cleaning up a mess that another programmer started. The created 2 identical databases for different locations but that obviously caused major issues. They are using cakePHP and there are quite a few relationships. I am pretty sure I will have to write a script to import that data from on DB to the other and keep all the relationships but was wondering if there is an easier way to do it.

  Read the article

• DataBind DataSource Result to ASP Labels

  - by Steven

  I have an AccessDataSource TestSummaryADS. I can easily view the results in a GridView or DropDownList by setting its DataSourceID property. How do I bind a value from the results TestSummaryADS to the text of a label? I'm just trying to populate labels on my page with results from the DB entry. C# or VB.NET answers okay.

  Read the article

• How to delete an object by using PK in nhibernate?

  - by jgauffin

  How do I delete an object without fetching it from the db first? In another ORM, I can do this: session.Delete<User>(1); // 1 = PK

  Read the article

• how to write a bat file to execute the .sql fiel

  - by ganuke

  I want to execute query in side the db.sql file using MySQL 5.1 in windows environment. Can any one help me to this. I want to do this by runing a bat file.

  Read the article

• Using Git or Mercurial, how would you know when you do a clone or a pull, no one is checking in file

  - by Jian Lin

  Using Git or Mercurial, how would you know when you do a clone or a pull, no one is checking in files (pushing it)? It can be important that: 1) You never know it is in an inconsistent state, so you try for 2 hours trying to debug the code for what's wrong. 2) With all the framework code -- potentially hundreds of files -- if some files are inconsistent with the other, can't the rake db:migrate or script/generate controller cause some damage or inconsistencies to the code base?

  Read the article

• How to reduce time for taken by stored Procedure for inserting a single record?

  - by padmavathi

  We wrote a stored procedure for selecting a single record from DB at a time. Using the same stored procedure to read 2000 records it takes 4 seconds. Is there any way to optimize it? (like single stored procedure for 2000 records) Thanks & Regards Padma

  Read the article

• What is the efficient way to make a permission system?

  - by WEBProject

  Currently im just using something like: in the DB Table: access: home,register,login and then in each page: if(!Functions::has_rights('content')) { Functions::noAccess(); } is there more efficient way to do it, php & MySQL? i may want to gain access even to several parts a page, for example: user can read a page, but doesnt comment to it, and I dont want to build a separate system to each module. Thanks in advanced, Tal.

  Read the article

• MVC architecture EJB funcionallity

  - by Ignacio

  HI would like to understand how do ejbs work in an MVC architecture, what i do not get is: When the web app starts, the system creates an ejb for each record in every table of db or an ejb with all the records of all tables? Thank you very much

  Read the article

• question about timestamp with timezone in postgresql+java?

  - by ylazez

  hey guys i have a column in the database(postgresql) i want to insert the current time in GMT in this column when getting the current time and inserting it into the DB it's inserted in the server timezone GMT-5 although that time was in GMT+0 any ideas how to insert this time in the database in GMT timezone ?

  Read the article

• How to get reference of activity object ?

  - by Fevos

  Hi i want to show messageBox or notification when connection lost in Static DB class but i cant use getApplicationContext() becouse its a static class and i tried to call other class called notification but i have error so how i could pass activity object to my new class .

  Read the article

• Validation library for PHP/mysql

  - by Industrial

  Hi! Is there any lightweight validation library available for PHP that easily can check if a specific string or value is valid for a known database type - Something like this: if (is_MEDIUMINT($var)) { $this->db->insert($anothervar); } Thanks!

  Read the article

• Javascript serialization

  - by John

  Have I any chance to serialize meta (any format, so I can store it in DB)? var obj1 = {}; var obj2 = {}; obj1.link = obj2; obj2.link = obj1; var meta = [obj1, obj2]; As I understand the problem is that JSON serialize object`s links to objects.

  Read the article

< Previous Page | 222 223 224 225 226 227 228 229 230 231 232 233  | Next Page >