1. the design ASP.NET site

    Date: 08/13/07 (SQL Server)    Keywords: database

    Dear developers! If you have time and desire to me to help, help to do the design for site. The Details shall write on E-mail Also ask you to help to form the database and code of the site. In principle, they there is, but wanted that all were made professional. Also write on E-mail.

    The Site has two languages. Shall very pleased if you will help to avoid some mistakes in translation and literate,but the main, understandable write the text.


    Source: http://community.livejournal.com/sqlserver/62393.html

  2. SQLite GUI?

    Date: 08/14/07 (Web Development)    Keywords: php, database, sql, web

    Hello, I was wondering if there was anyone out there who could help me find a GUI for SQLite that is free?

    I just want it to set up the database, My plan is to enter everything into the db with php though a web form. (is that possible?)

    thank you kindly (ahead of time) for any help.

    Source: http://community.livejournal.com/webdev/429074.html

  3. SQLite GUI

    Date: 08/14/07 (WebDesign)    Keywords: php, database, sql, web

    Hello, I was wondering if there was anyone out there who could help me find a GUI for SQLite that is free?

    I just want it to set up the database, My plan is to enter everything into the db with php though a web form. (is that possible?)

    thank you kindly (ahead of time) for any help.

    Source: http://community.livejournal.com/webdesign/1295370.html

  4. some advice - databases in MSSQL

    Date: 08/15/07 (Web Development)    Keywords: database, sql, web

    I'm working on a commercial website, and I've employed a small company to build the site as it requires a database and I don't know about making such things. They are building it in MSSQL.

    A few days ago we saw the first rough version of the site, which was showing progress. However we didn't like the menu being placed down the side of the page, and want it moved to run across the top. Unfortunately, they have replied saying they can't move the menu now, it is too late, the menu at the side has already been coded in to the database.

    Aside from the fact that I am very angry about this decision of theirs to build in a side menu without confirming that was what we wanted, what I'd like to know is, how 'built in' to the database structure is the page structure? I had no idea it was integrated at all. Is it really a huge job to change the layout from a side menu to a top menu, or are they just complaining because they can't be bothered?

    Don't tell me I should have employed a different company because it's too late for that now and I'm already thinking it :o/

    Source: http://community.livejournal.com/webdev/429740.html

  5. looking for some free ColdFusion hosting

    Date: 08/16/07 (WebDesign)    Keywords: database, web, hosting

    I need just a little tiny bit of ColdFusion hosting. Just a couple pages, some images, no databases or anything fancy. I dont mind if the service is plastered with ads, it's just for a little toy I developed a while back that people are whining about me taking down. I'm talking like less than 5 megs. I had a spat with my web host and took everything down, I dont have use for a portfolio anymore anyway. Anybody know a good one?

    Source: http://community.livejournal.com/webdesign/1296435.html

  6. counting up yes votes?

    Date: 08/20/07 (WebDesign)    Keywords: php, mysql, database, sql

    I have a mySQL database, and one of the tables is used as the backend for a ratings system in which people can rate images on a scale of 1-5. In it, I have columns for the following data: id (a primary key field), userid (their phpBB userid), total votes cast, and then a column for every item in the rating system, just as a y/n toggle to check whether or not a person has rated that item. Actual scores are stored elsewhere.

    My problem is fairly simple: I need to clear some of the ratings, because the images are going to change. How can I count up the total number of 'y' in a row in my database in order to update the total votes to reflect that some votes have been reset? Each row represents one user's votes, so it might say that user 1 has voted on images 1, 3 and 5, but not 2 and 4. I want to be able to find out that user 1 has voted 3 times. mysql_num_rows, of course, just returns 1, and I think mysql_num_cols/columns doesn't exist. Right now, the system simply works that every time a user rates something, the total vote is incremented by 1. Does anyone know what I need to do?

    Source: http://community.livejournal.com/webdesign/1298510.html

  7. employment opportunities

    Date: 08/30/07 (Computer Geeks)    Keywords: software, database

    Resume Butlers Career Zone
     
    Jobs Sponsored by Resume Butlers and

    Connex   



    if interested, contact:
    roderick
    graham@resumebutlers
     
      
       

    Source: http://community.livejournal.com/computergeeks/1102260.html

  8. MySQL Master-Master Replication…

    Date: 09/02/07 (Java Web)    Keywords: mysql, database, sql

    Have you tried Master-Master replication (bi-directional slave-master replication) for MySQL? I am finding myself in a position where I need to have this replication to support the load on my blogs and sites. I would very much appreciate if you can share your experience & suggestions with master-master replication of MySQL database. I don’t want to [...]

    Source: http://blog.taragana.com/index.php/archive/mysql-master-master-replication/

  9. Simple DB Design Question

    Date: 09/04/07 (MySQL Communtiy)    Keywords: database

    I don’t quite understand how to best design a database…I was wondering if anyone would be willing to give me their thoughts.

    • It’s for an ever changing group of about 20 kids (they rotate yearly)
    • That can earn an occasionally changing list of 60+ awards

    (This is probably obvious) I want to pull down all the awards a child has earned and the date they earned it.

    Is there anything wrong with creating a single table with children listed in rows and awards listed in columns? 

    (It seems like its wrong—especially on a large scale, but I don’t know why I think that.)

    Thank You !

    Source: http://community.livejournal.com/mysql/117897.html

  10. Dynamic Tables

    Date: 09/05/07 (MySQL Communtiy)    Keywords: software, database, shopping

    A friend of mine uses an interesting technique that I'm curious about. In addition to the initial database tables, his software (scripts, program, whatever) adds and deletes additional tables as needed to store other mostly temporary information. For example, with a shopping cart, he adds a temporary table for each user to have their own table with the items they've added.

    I'm really not too keen on doing things this way. Is anything even remotely like this common and/or good practice?

    Source: http://community.livejournal.com/mysql/118152.html

  11. MySQL to get dynamic load balancing in 2008

    Date: 09/13/07 (Open Source)    Keywords: mysql, software, database, sql

    MySQL will introduce dynamic load balancing to its database platform and enterprise subscription in 2008. That news surfaced during a briefing Thursday with MySQL executives about the open source database company’s forthcoming 5.1 and 6.0 upgrades. Zack Urlocker, Executive Vice President of Products at MySQL, said the load balancing software will ship as part of the next [...]

    Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/156072251/

  12. Wierd error

    Date: 09/15/07 (Asp Dot Net)    Keywords: database, sql, microsoft

    I inherited a program that takes data from a csv file and inserts it into a database.

    The data is in the following format:

    8/20/2007 12:14:21 PM,HDFM,"Nick Yockell","Nate Wittrock",239-850-3931,239-850-2514,"Used 2004 Harley Davidson ","bought bike
    CUSTOMER WANTS TO BRING HIS YAMAHA R6 IN TO TRADE AND SEE HOW MUCH PAYMENTS WOULD BE.
    ",Deliver,aa32ed31-f0c8-4f43-a7d4-830d9f29edcd


    For some reason the function that saves the data to the database is having a problem with the customer phone number (5th column).

    The database column is a varchar(50) - the same as the customer business phone number.

    If the customer home phone contains anything other that digits it cannot be saved to the database.

    However, the customer business phone can contain anything and gets saved just fine.

    The sql statement in the second function runs fine from query analyzer so I know thats not the problem.

    Is there anything in the two functions that could be causing this ?



    private void ProcessFile(string filename, string vendor)
    {


    string path = string.Empty;
    string LoggingDate = DateTime.Now.ToString();

    switch (vendor.ToLower())
    {
    case "vpulse":
    path = DIRECTORYPATHVPULSE;
    break;
    case "calllogpro":
    path = DIRECTORYPATHCALLLOGPRO;
    break;

    }

    try
    {
    OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+path+"\\"+";Extended Properties=\"Text;HDR=No;FMT=Delimited()\"");
    //OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+this.txtSource.Text+"\\"+";Extended Properties=\"Text;HDR=No;\"");
    OleDbCommand ExcelCommand = new OleDbCommand(@"SELECT * FROM "+filename,ExcelConnection);

    OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);

    ExcelConnection.Open();

    DataSet ExcelDataSet = new DataSet();
    ExcelAdapter.Fill(ExcelDataSet);

    ExcelConnection.Close();

    //Process File
    ProcessFileRecords(ExcelDataSet, vendor.ToLower());

    //Email Copy to Alliance Group
    this.EmailFile(path, filename, vendor);



    }
    catch (Exception exc)
    {
    string errorText = exc.ToString();
    System.Diagnostics.EventLog.WriteEntry("Alliance Level 2 DataRetreiver", errorText);

    }
    finally
    {
    //Archive Copy
    this.ArchiveFile(path, filename);
    }
    }




    private void ProcessFileRecordVPulse(object[] record)
    {
    string logdate = string.Empty;
    string dealership = string.Empty;
    string salesperson = string.Empty;
    string customername = string.Empty;
    string homephone = string.Empty;
    string businessphone = string.Empty;
    string product = string.Empty;
    string comments = string.Empty;
    string sellstage = string.Empty;
    string vpulsecalltaskid = string.Empty;

    string LoggingDate = DateTime.Now.ToString();

    try
    {
    logdate = Convert.ToDateTime(record[0]).ToShortDateString();
    dealership = record[1].ToString();
    salesperson = record[2].ToString();
    customername = record[3].ToString();

    try
    {
    homephone = record[4].ToString();
    //homephone.Replace("-", "");
    }
    catch
    {
    homephone = "Bad format";
    }

    businessphone = record[5].ToString();
    product = record[6].ToString();
    comments = record[7].ToString().Replace("
    ", " ");

    //***Get Sales Stage
    sellstage = record[8].ToString();
    switch(sellstage.ToLower())
    {
    case "greet":
    sellstage = "1";
    break;
    case "probe":
    sellstage = "2";
    break;
    case "identify machine":
    sellstage = "3";
    break;
    case "presentation":
    sellstage = "4";
    break;
    case "sit down":
    sellstage = "5";
    break;
    case "write up":
    sellstage = "6";
    break;
    case "close the deal":
    sellstage = "7";
    break;
    case "finance":
    sellstage = "8";
    break;
    case "deliver":
    sellstage = "9";
    break;
    default:
    if (sellstage.ToLower().IndexOf("service") == -1 && sellstage.ToLower().IndexOf("parts") == -1)
    sellstage = "1";
    else
    sellstage = sellstage;
    break;
    }
    //***Get Sales Stage

    vpulsecalltaskid = record[9].ToString();

    //Import lead record
    SqlCommand command = this.GetCommand();

    command.CommandText = @"INSERT INTO CallLogs
    (LogDate,
    VPulseCallTaskId,
    CallLogTypeId,
    DealerId,
    SalesPerson,
    CustomerName,
    CustomerHomePhone,
    CustomerBusinessPhone,
    Product,
    Comments,
    SaleStage,
    LogProcessFlag,
    CSI14Days,
    CSI17Months,
    CSI14DaysProcessFlag,
    CSI17MonthsProcessFlag)
    VALUES
    (@LogDate,
    @VPulseCallTaskId,
    @CallLogTypeId,
    @DealerId,
    @SalesPerson,
    @CustomerName,
    @CustomerHomePhone,
    @CustomerBusinessPhone,
    @Product,
    @Comments,
    @SaleStage,
    @LogProcessFlag,
    @CSI14Days,
    @CSI17Months,
    @CSI14DaysProcessFlag,
    @CSI17MonthsProcessFlag)";

    command.Parameters.Add("@LogDate", logdate);
    command.Parameters.Add("@VPulseCallTaskId", vpulsecalltaskid);
    if ((sellstage.ToLower().IndexOf("service") == -1)&&(sellstage.ToLower().IndexOf("parts") == -1))
    {
    command.Parameters.Add("@CallLogTypeId", "1");
    }
    else
    {
    if (sellstage.ToLower().IndexOf("service") != -1)
    {
    command.Parameters.Add("@CallLogTypeId", "1"); //Service (4)
    dealership = dealership+"_SERVICE";
    sellstage = "1";
    }
    else if (sellstage.ToLower().IndexOf("parts") != -1)
    {
    command.Parameters.Add("@CallLogTypeId", "1"); //Parts (3)
    dealership = dealership+"_PARTS";
    sellstage = "1";
    }
    }
    command.Parameters.Add("@DealerId", dealership);
    command.Parameters.Add("@SalesPerson", salesperson);
    command.Parameters.Add("@CustomerName", customername);
    command.Parameters.Add("@CustomerHomePhone", homephone);
    command.Parameters.Add("@CustomerBusinessPhone", businessphone);
    command.Parameters.Add("@Product", product);
    command.Parameters.Add("@Comments", comments);
    command.Parameters.Add("@SaleStage", sellstage);
    command.Parameters.Add("@LogProcessFlag", false);
    command.Parameters.Add("@CSI14Days", Convert.ToDateTime(logdate).AddDays(14).ToString());
    command.Parameters.Add("@CSI17Months", Convert.ToDateTime(logdate).AddMonths(17).ToString());
    command.Parameters.Add("@CSI14DaysProcessFlag", false);
    command.Parameters.Add("@CSI17MonthsProcessFlag", false);

    command.ExecuteNonQuery();
    this.DisposeCommand(command);
    }

    catch (Exception exc)
    {

    string errorText = exc.ToString();
    System.Diagnostics.EventLog.WriteEntry("Alliance Level 2 DataRetreiver", errorText);

    }

    Source: http://community.livejournal.com/aspdotnet/92096.html

  13. max_user_connections problem

    Date: 09/15/07 (MySQL Communtiy)    Keywords: php, mysql, database, sql

    I have a recurring problem with my site. It gets to max_user_connections very quickly. In '[info]'php they advised me to make rapid-fire connections, and it works better than before, but it still builds up regularly. My host says that sometimes queries block the server. This is now a really serious problem and I'm in trouble with my host.

    This happens since I tried to normalize the database by splitting information on other tables, instead of having fields with comma-separated lists. Thing is, now some query require several JOIN to get all the necessary information. Example:

    $info_query = "SELECT $stories_table.id, $stories_table.series_id, $stories_table.story_num, $stories_table.story_title, $stories_table.pairing_extra, $stories_table.characters_extra, $stories_table.rating, $stories_table.spoilers, $stories_table.challenge, $stories_table.complete,
    $series_table.user_id, $series_table.series_title,
    $users_table.name,
    $chapters_table.id as chid, CONCAT_WS('$chapter_separator', $chapters_table.chapter_num, $chapters_table.chapter_title) AS chapter_title, $chapters_table.chapter_num, $chapters_table.summary, $chapters_table.notes, DATE_FORMAT($chapters_table.date, '$date_format') AS date_f,
    $ratings_table.name as rating_name
    FROM $stories_table
    LEFT JOIN $series_table ON $series_table.id=$stories_table.series_id
    LEFT JOIN $users_table ON $users_table.id=$series_table.user_id
    LEFT JOIN $chapters_table ON $stories_table.id = $chapters_table.story_id
    LEFT JOIN $ratings_table ON $ratings_table.id = $stories_table.rating
    WHERE $chapters_table.story_id = $story_id AND $chapters_table.chapter_num = $chapter_num";

    Could this be the source of my problems? If so, do you know any alternative that doesn't load the server that much? I'm getting really desperate with this.

    My host uses mysql version 4.0.27.

    Thanks!

    Source: http://community.livejournal.com/mysql/119223.html

  14. field checking

    Date: 09/15/07 (PHP Community)    Keywords: database

    I'm making a sign up form, and I'm worried about abuse. Does anyone have good resources I can read for checking fields like FirstName, LastName, UserName, and correct email addresses.
    I'm trying to avoid allowing junk data being inserted into the database.

    Source: http://community.livejournal.com/php/585614.html

  15. WordPress.com’s Dedicated Web Hosting Provider LayeredTech User Accounts Compromised

    Date: 09/19/07 (Java Web)    Keywords: database

    Automattic hosts WordPress.com using dedicated servers from LayeredTech. According to Todd Abrams, President & COO of Layered Technologies: “The Layered Technologies support database was a target of malicious activity on the evening of 9/17/2007 that may have involved the illegal downloading of information such as names, addresses, phone numbers, email addresses and server login details for [...]

    Source: http://blog.taragana.com/index.php/archive/wordpresscoms-dedicated-web-hosting-provider-layeredtech-accounts-compromised/

  16. Site in multiple languages

    Date: 09/19/07 (WebDesign)    Keywords: php, database

    I have a question to you all.... whatВґs the best way to do a site in 3 or 4 languages that has a database/PHP driven guestbook and a photo gallery using Simpleviewer?

    I have started on the first (Norwegian) language menu and find myself with the dilemma of not wanting to set up a Norwegian guestbook (and Spanish guestbook after that!) on top of the English one that already exists. Also, if I set up a Norwegian (etc.) language photo gallery it would mean that I would have to update more than one of the *same* photo gallery each time, so I donВґt want to do that - I simply would like the foreign language sites to use the English guestbook and the English gallery.

    The problem is that once theyВґre on the English site, the menus will all be in English and the only way I can think of redirecting them back to their own language site is to put a little flag on every page where they can click to go back.

    However, this is why IВґm asking you.... is there another way you could recommend? Thanks for any ideas. :)

    Source: http://community.livejournal.com/webdesign/1311708.html

  17. temp tables?

    Date: 09/24/07 (SQL Server)    Keywords: database

    I'm a tad confused here. I thought when you used the syntax...

    CREATE TABLE ##m_tblOpenReceipts(

    ...that the table was destroyed when the stored procedure ended. So why, when I try to run it a second, time, do I get the error...

    Msg 2714, Level 16, State 6, Line 43
    There is already an object named '##m_tblOpenReceipts' in the database.

    ...?

    (This is also the case with a single pound.)

    If I'm wrong about this, as I seem to be, how does one create a true temp table?

    Source: http://community.livejournal.com/sqlserver/63487.html

  18. PHP & Visual FoxPro

    Date: 09/28/07 (PHP Community)    Keywords: database

    I need to run queries on a visual foxpro database. Anyone here have experience with this? Is foxpro multiuser (ie, can I set up a read-only account)?

    thanks!

    Source: http://community.livejournal.com/php/588294.html

  19. Importing data

    Date: 09/30/07 (MySQL Communtiy)    Keywords: php, html, database, sql, web

    Hi

    I have an extremely large SQL dump file (541MB) that I am trying to run and drop the data into a database. I have attempted to use Big Dump which has worked for other databases in the past however I now run into the following error:

    Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 16385 bytes) in /home/netyello/public_html/bigdump.php on line 514


    What I'm wanting to do, if possible, is break down the dump file into smaller chunks so that it can handle it. Is anyone aware of a way to do this or a program that will allow me to do this when creating the dump file from the website?

    Thanks!

    Source: http://community.livejournal.com/mysql/120080.html

  20. AltLaw offers a legal research alternative for federal courts

    Date: 10/03/07 (Data Management)    Keywords: database

    AltLaw, a free legal database created by Prof. Tim Wu of Columbia Law School, has officially launched, Ars Technica reports. Ars describes the service: The database currently provides full-text search of Supreme Court and Federal Appellate opinions from the last decade or so. It also allows for...

    Source: http://government.zdnet.com/?p=3423

Previous page  ||  Next page


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home