• how to find the video source

    Hi Good day Sir, I'm just working as anti-pirate assistant to our company, and i'm going stressed out in finding how and where to get the embbeded video source of this kind of code: <div id='my-video'></div><script type='text/javascript'> jwplayer('my-video').setup({ file:...

    kennethmanalo5 pointsBadges:
  • How can I select random rows in PostgreSQL?

    I'm looking to get a random selection of rows from PostgreSQL. I've already tried this: select * from table where random() < 0.01; But one of my friends told me to use this: select * from table order by random() limit 1000; My table has over 200 million rows so I need it to be fast. Which way...

    ITKE345,950 pointsBadges:
  • Saving calculated data in Access 2000

    How do I save a calculated value on a form into a field in my table?

    chicbora5 pointsBadges:
  • Microsoft Access 2013 button placement on form

    In Access 2013 (Win 7) with controls aligned vertically, is there an easy way to have equal spacing between them?

    LeonFromWA5 pointsBadges:
  • Change user/file path in Access database

    My boss left and I took over her access database. When I try to pull the information from tables she created I get error that says"C:user****is not a valid path make sure path name correct or connected to server. How can I change the database to be "mine" so I can access the tables information?

    tkarp5115 pointsBadges:
  • Set up DB2 Web Query dashboard

    I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

    Piano520 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Can we split a column in MySQL?

    In MySQL, we have a column that has comma separated data, like this: 1,2,3 3,2,1 4,5,6 5,5,5 So we're trying to run a search that would actually query each value of the CSV string individually. 0<first Is there a way to do this in MySQL? Thanks so much.

    ITKE345,950 pointsBadges:
  • export VB6 report in pdf format.

    I'm making a project in VB 6 using MS Access as a database. I'm making a report in crystal report and want to export that report in PDF format.

    Ambastha5 pointsBadges:
  • How to I insert a table if it doesn’t exist in a MySQL database?

    In a MySQL database, I'm trying to do the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name='value' ); But it keeps returning the same error. I don't want to insert a record if the...

    ITKE345,950 pointsBadges:
  • How can I find duplicate records in a MySQL database

    I'm trying to pull out duplicate records in a MySQL database. I've already figured out how to do it this way: SELECT address, count(id) as cnt FROM list GROUP BY address HAVING cnt > 1 This is what it results in: 100 MAIN ST 2 But I need to do a pull that shows each row that has a duplicate,...

    ITKE345,950 pointsBadges:
  • Deleting multiple rows in MySQL

    We have a table with the following fields: id (Unique) url (Unique) title company site_id We now need to remove rows that have the same title, company and site_id. We've figured out one way to do it: SELECT title, site_id, location, id, count( * ) FROM jobs GROUP BY site_id, company, title,...

    ITKE345,950 pointsBadges:
  • How to put Access Control List in Cisco WS-C2960-24TT-L

    What are the commands to put Access control List in cisco WS - C2960-24TTL

    Whyshree5 pointsBadges:
  • Connection of Crystal Report 2008 with VB6.

    Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.

    Anishrohlx5 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • Can I select 10 rows randomly in MySQL?

    What's the best way to write a query that can select 10 rows randomly from a total of 800,000.

    ITKE345,950 pointsBadges:
  • Can I replicate the ROW_NUMBER() in MySQL?

    Does anyone know of a way, in MySQL, to replicate a SQL Server function "ROW_NUMBER()?"  Here's my example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 With this, I would be able to add a condition to limit "intRow" to 1 to get a single...

    ITKE345,950 pointsBadges:
  • How to create a MySQL pivot table

    I currently have a MySQL table that looks like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3 But now I need to run a SQL query to get...

    ITKE345,950 pointsBadges:
  • How to check if a table exists in MySQL without throwing an exception

    Does anyone know if there's a way to check if a table exists in MySQL (possibly through PHP) without throwing an exception? It's not beneficial for me to parse the results of "SHOW TABLES LIKE." There must be some sort of query I can use.

    ITKE345,950 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following