Search Results

Search found 30606 results on 1225 pages for 'database relations'.

Page 803/1225 | < Previous Page | 799 800 801 802 803 804 805 806 807 808 809 810  | Next Page >

• How do I detect bots programatically

  - by Tom

  we have a situation where we log visits and visitors on page hits and bots are clogging up our database. We can't use captcha or other techniques like that because this is before we even ask for human input, basically we are logging page hits and we would like to only log page hits by humans. Is there a list of known bot IP out there? Does checking known bot user-agents work?

  Read the article

• Grails UnitTest

  - by Tomáš

  Hi (it is propably stupid question) how can acquire Domain class from database in test? class PollServiceTests extends GrailsUnitTestCase { Integer id = 1 void testSomething() { Teacher teacher1 = Teacher.get(id) assert teacher1 != null } } I always get null or No signature of method: cz.jak.Teacher.get() is applicable for argument types: (java.lang.Integer) values: [1] thanks a lot Tom

  Read the article

• Find all the varchar() fields in sql server?

  - by JD

  Hi, Is it possible to find all the varchar() columns in my database? I am using SQL Server 2008 and would like to get the list in SQL server management console. JD.

  Read the article

• Default Sorting in DynamicData

  - by Jens A.

  I am using DynamicData in the version that shipped with VS2008. In the default List view, the data is sorted by order of entry into the database. I'd like to get it sorted by a field of a specific name (descending). As a last resort I tried to use the OrderByParameter of the LinqDataSource with a QueryStringParameter, but I could not get it to sort anything. =) Is there an easy way to accomplish this?

  Read the article

• Right tool for tracking DB structure changes

  - by termopro

  Right now i have a PHP project and i track all changes in code by SVN. I would also like to track changes made in database structure. Which is the right tool to use ?

  Read the article

• How to get the one paramater from list of items in php

  - by Mirage

  I have one field in database table with following lines show_email_icon= show_hits= feed_summary= page_title= show_page_title=1 pageclass_sfx= menu_image=hd_events.png secure=0 All the stuff is stored as text in one field of mysql table Now i want to get the menu_image. How can i get that

  Read the article

• removing non ascii characters from a string using python / django

  - by Gaurav

  I have a string of HTML stored in a database. Unfortunately it contains characters such as ® I want to replace these characters by their HTML equivalent, either in the DB itself or using a Find Replace in my Python / Django code. Any suggestions on how I can do this?

  Read the article

• NHibernate: How do I do this in the HBM mapping?

  - by SharePoint Newbie

  Hi, I have an entity FinancialWeek which maps to continuous periods defined in a database table. For example: Week 1, From: 1/01/2010, To: 7/01/2010 Week 2, From: 8/01/2010, To: 14/01/2010 I need to define a lazy property for Next and Previous weeks in my entity. How do I do this in the HBM mapping? Thanks

  Read the article

• how to start multiple instance of an application in a test

  - by BenZen

  Hi I m working on a client-server program, where there is no test at all. When i try to do some test with two server, it's look like both server is connected to the same database. I think the reason is some bad use of static field. So i wonder, is there a way to start two VM in a junit test?

  Read the article

• Adding code to plugin that only executes the first time its activated?

  - by Scott B

  Is it possible to wrap code in a special function that only executes the first time the plugin is activated? I have some database code I need to run on plugin activation, but the code need not run again after that.

  Read the article

• Is a clear and replace more efficient than a loop checking all records?

  - by Matt

  I have a C# List, that is filled from a database.. So far its only 1400 records, but I expect it to grow a LOT.. Routinely I do a check for new data on the entire list.. What I'm trying to figure out is this, is it faster to simply clear the List and reload all the data from the table, or would checking each record be faster.. Intuition tells me that the dump and load method would be faster, but I thought I should check first...

  Read the article

• Is there a fast way to change all the collation to utf8_unicode?

  - by Mark

  I have realised after making about 20 tables that I need to user utf8_unicode as opposed to utf8_general. What is the fastest way to change it using PHPMyAdmin? I had one idea: Export the database as SQL then using notepad run a find and replace on it and then reimport it... but it sounds like a bit of a headache. Is there a better way?

  Read the article

• Is there a good IDE for SQLite ?

  - by Chris Conway

  Is there a tool out there that can interact with a SQLite database in a similar way that TOAD works with Oracle or Management Studio works with SQL Server? I'm looking for something that visually shows table structures, views, etc. Looking to target the Windows platform (preferably Vista). Thanks!

  Read the article

• Efficient way to build a MySQL update query in Python

  - by ensnare

  I have a class variable called attributes which lists the instance variables I want to update in a database: attributes = ['id', 'first_name', 'last_name', 'name', 'name_url', 'email', 'password', 'password_salt', 'picture_id'] Each of the class attributes are updated upon instantiation. I would like to loop through each of the attributes and build a MySQL update query in the form of: UPDATE members SET id = self._id, first_name = self._first name ... Thanks.

  Read the article

• Match a comma followed by a newline with a regular expression

  - by MarathonStudios

  I have a comma delimited list I want to import into a database, and in some cases the last item is blank: item1, item2, item3 item1, item2, item1, item2, I'd like to replace all of these empty columns with a placeholder value using a regexp item1, item2, item3 item1, item2, PLACEHOLDER item1, item2, PLACEHOLDER I tried preg_replace("/,\n/", ",PLACEHOLDER\n",$csv);, but this isn't working. Anyone know what regexp would work for this?

  Read the article

• Java/JSP/Tomcat web hosting

  - by Zaheer Baloch

  Hello guys, I am looking for a hosting solution for my Java/JSP web application. Do you know any servers which provide Tomcat hosting for v5 or greater and MySQL database?

  Read the article

• Getting the GUID for any given path to sharepoint.

  - by user327823

  Hey, I'm trying to get the GUID of a given sharepoint URL. I don't mind using the API or the webservices or Sharepoint's database. if i were to write a function, it's signature would be: //get a GUID from path. string GetGuidFromPath(string path){} I had a lead: SPContentMapProvider but it doesn't seem to get the right info. Thank you!

  Read the article

• Where Does Temporary Tables Gets stored in sql server.

  - by Shantanu Gupta

  Where does temporary tables gets stored in database. I want to drop a temporary table if it already exists. I can do this for securable table by querying at information schema but i done know where temporary tables are stored

  Read the article

• MySQL Problems......

  - by Kovu

  With the tool "mysql administrator" i get a complete connection to my database, I can change userthings and so on. But not PHPMyAdmin nor Joomly Installation will get a connection, they timed out. Any Ideas?

  Read the article

• How to delete an image using PHP & MySQL?

  - by IMAGE

  I was wondering if some one can give me an example on how to delete an image using PHP & MySQL? The image is stored in a folder name thumbs and another named images and the image name is stored in a mysql database.

  Read the article

• How to build a widget for my website

  - by Gublooo

  Hey guys I'm very new to the whole programming - so far I only have experience with building websites, database etc. I currently have a website where users can share their online purchases. I want to build a widget that other websites can integrate on their site. Users should be able to insert their purchases directly through this widget without having to come to my website. Thats the idea but I have no idea how to go about it - can anyone point me in the right direction. Thanks

  Read the article

• byte[] to image android

  - by Sephy

  Hi everybody, My issue is as follows : I have stored a few pictures into the sqlite database, using the blob format, which seems to work ok. now i want to get my pictures out of the DB and put then back into images... to complicate the matter, their format is variable (png, jpg, maybe something else, im not sure) Is there a way of doing so in android? thank you

  Read the article

• Postgres turn on log_statement programmatically

  - by rwallace

  I want to turn on logging of all SQL statements that modify the database. I could get that on my own machine by setting the log_statement flag in the configuration file, but it needs to be enabled on the user's machine. How do you enable it from program code? (I'm using Python with psycopg2 if it matters.)

  Read the article

• Does table (string, string) require index?

  - by abatishchev

  In my database running on SQL Server 2008 R2 I have a special table for global variables: CREATE TABLE global_variables ( name NVARCHAR(50), value NVARCHAR(50) NOT NULL CONSTRAINT PK_global_variables PRIMARY KEY CLUSTERED ( name ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO Does such table require indexing on value or not?

  Read the article

• what is the object "sqlconnection.BeginTransaction" useful for?

  - by vo-dang295

  when i connect to database by ado.net. As for sqlconnection object, it has a function:BeginTransaction with 3overload. I dont know how to use it and what's its function for? Help me plz!

  Read the article

< Previous Page | 799 800 801 802 803 804 805 806 807 808 809 810  | Next Page >