Date: 12/17/08 (MySQL Communtiy)    Keywords: mysql, database, sql

I need to "synchronize" the output of a stored procedure in one database (I don't have access to any tables there, just stored procedures) and a table in another database. So I need to call a remote stored procedure once in a while and populate a local table with its output. For the remote database, I know hostname, port, username, password and db name.

Is this possible in mysql? Any help would be appreciated

Source: https://mysql.livejournal.com/133145.html

Date: 12/11/08 (MySQL Communtiy)    Keywords: mysql, database, sql

I'm starting a new consulting gig that requires me to work on a MySQL database. Typically, I use Rapid SQL as my IDE, but I have been informed that it doesn't support 5.x. What IDEs out there support MySQL 5?

Source: https://mysql.livejournal.com/132964.html

Date: 10/30/09 (Asp Dot Net)    Keywords: database

I've been looking around everywhere, but either don't know how to search for it or don't know what I'm looking at... but I'm trying to convert dates that I pull from a database from 30/10/2009 00:00:00AM or whatever it comes up as to just the date. I found a convert statement, but have no idea where to put it in my select statement (or if it goes somewhere else).

I tried
SELECT ID, title, caption, credit, date (CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]) FROM MMphotos WHERE (ID = @ID)

and
SELECT * FROM MMphotos WHERE (ID = @ID) CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]

But neither worked... but both returned different errors. First one is saying "'date' is not a recognized built-in function name" and the second was saying "Incorrect syntax near the keyword 'CONVERT'"

What am I mucking up?

Source: https://aspdotnet.livejournal.com/103632.html

Date: 02/17/09 (Asp Dot Net)    Keywords: database, asp, sql, web

Hi,
What I am trying to do this time is create an asp.net listbox from
an SQL Server 2005 result set (done) which then users can sort the
records to form the running order within the same Listbox and then
submit all the records including the new running order back into
the database. Each record has already been automatically assigned
a running order number based on their position in the old website.

I am looking for suggestions on the quickest and *easist* way to do
this, examples would be much appreciated. My web application is asp.net
written in C#.

Any help is appreciated.

Source: https://aspdotnet.livejournal.com/103147.html

Date: 01/28/09 (Asp Dot Net)    Keywords: html, database, web

I have a site that we are moving from Flat HTML into a Database using in house
written VB.Net applications. The website is roughly 10,000 pages. The volume of
pages however is not the problem. The Page HTML content is all now held in a
database, Now I am looping through the pages and checking each page using regular
expressions for either a href or img src tag so I can collect the URL for all
images and attachments. Once I have these, i pass the URL (currently) to the
HttpWebRequest.DownloadData which makes a request to the website for the url
provided and then the attachment is downloaded and eventually written out using
the WriteAllBytes() function. This works for one iterration and then times out.
What i need to know is why does it time out and is there a better method of doing
this? the files can be rather large that are getting moved the site is about 5.7gb
and most of this will be down to diffrent file formats.

Source: https://aspdotnet.livejournal.com/102801.html

Date: 11/28/08 (Asp Dot Net)    Keywords: database

I'm trying to create an item update page for a product database, and was wondering if there's something similar to

ConnectionString="server=...;database=...;uid=...;pwd=..."
SelectCommand="SELECT * FROM database WHERE (ID = @ID)" >

DefaultValue="%" />


for updating and inserting? I use code like that for search queries, and tried changing "select" to "update" in the code to see if that might work, but no luck. I want there to be a 1st page where you select the product to be updated, then that brings you to a form that has all the product info inserted into the form (with the ID disabled), then you can edit and after submitting, it goes to the 3rd page that gives the success message and updates the table. I have the fist two pages working fine, the form populated with the right data, but after hitting submit, I don't get an error regarding the coding, but no data is updated. I tried using the datagrid method on the MSDN site, because it has worked for inserting new data, but, besides also being kinda bulky to use, it didn't work either. Any suggestions?

Source: https://aspdotnet.livejournal.com/102205.html

Date: 11/28/08 (Asp Dot Net)    Keywords: database, sql

I keep getting an error the error 1) in my code, I am using a xsd file to call stored procedure and
access the database. This worked fine under Windows 2000 using visual basic express 2005. I am now
on a XP Machine using VS 2005 and i can get it to work. The error occurs at this point 2) and the
code that defines that dataaccess is listed as 3). So what am i doing wrong then all suggestion
accepted.

1) Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

2) content_page = dataaccess.GetContentPages()

3)

Dim content_page As Object
Dim page As Object
Dim page_number As Integer
Dim page_content As String

' call out the pages from the database
Dim dataaccess As DataSet1TableAdapters.pagesTableAdapter = New DataSet1TableAdapters.pagesTableAdapter
content_page = dataaccess.GetContentPages()

' Loop through the record set
For Each page In content_page
' assigned the page and content values to variables
page_number = page
page_content = page

Source: https://aspdotnet.livejournal.com/101914.html

Date: 07/13/08 (Asp Dot Net)    Keywords: database, asp

I'm trying to set up a database connection with ASP.NET in Dreamweaver MX 2004 (yeah, a little older...), and everything in the site has a check mark that needs to before you add a connection, and I add the database file, and even hit test and it registers fine. Then when I go to add a new record set, I select the database, but it says "***No table found". So apparently it's ok with the file path, it just can't read the database tables.

I've made sure the .net framework was all good to go, and I downloaded the MDAC 2.7 files and got those all set. Is there something I'm missing? I'm trying to work with Access and asp.net because that's what a position I'm trying to move into uses, so, I don't really have other options.

Also, I'm thinking maybe there's an issue with drivers because even when I try to hand code it with examples from http://www.w3schools.com/ASPNET/aspnet_repeater.asp, when I call it up in either IE or Firefox, it just displays the code....
any ideas?

Source: https://aspdotnet.livejournal.com/99757.html

Date: 03/17/08 (Asp Dot Net)    Keywords: database, web

I am trying to create a "fire and forget" webservice that I can kick off from a webpage.


This is the code I have in the webservice:

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;


[WebService(Namespace = "http://www.tempuri.org")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]


public class TestWebService : System.Web.Services.WebService
{

public TestWebService()
{

//Uncomment the following line if using designed components
//InitializeComponent();
}



[SoapDocumentMethod(OneWay = true)]
[WebMethod]
public void MultipleDatabaseHits()
{

// ..... do a bunch of database stuff

}


}



When I launch it from a page using this code, the page doesnt complete loading untill the database work is done.



protected void Button1_Click(object sender, EventArgs e)
{

TestWebService mySvc = new TestWebService();
mySvc.MultipleDatabaseHits();

}



What am I doing wrong ?



I'm not using RPC for soap so I know that the [SoapDocumentMethod(OneWay = true)] command is the correct one to use. I've seen examples where [SoapDocumentMethod(OneWay = true)] came before or after [WebMethod] - I tried it in both places and it didnt make a difference.

Source: https://aspdotnet.livejournal.com/97095.html

Date: 02/08/08 (Asp Dot Net)    Keywords: database, yahoo

I need a grid where I can select a checkbox or select everything else in the row.

So I could select the checkbox and hit the delete button and the row is deleted in the database. Or I could click on one of the other columns in the row and the item is opened in another page. (Kinda the way Yahoo Mail works)

Does anyone know if that is possible ? (And have you seen an example if it is ?)

Source: https://aspdotnet.livejournal.com/95513.html

Date: 01/28/08 (Asp Dot Net)    Keywords: database

How do I run a piece of code each time a page is displayed ?

I thought I could just put it in the page_load and not use a page.ispostback and that would mean the code is called each time the page is displayed.

However, I have a linkbutton that modifies a customer in the database. When the user clicks the linkbutton, the customer is modified and the page is redisplayed BUT I dont see the updated information for the customer.

(I have another page that displays a grid that shows the latest data whenever it is called).

Should I create a function to load the customer that the page_load and linkbutton both call ?

Source: https://aspdotnet.livejournal.com/94877.html

Date: 03/26/10 (PHP Development)    Keywords: php, database, web

Hi I need a little help with this. I'm looking for a simple PHP script that i used to have and now im having difficulty finding it. All the script does it retrieve the data from another webpage created on your server, so when you click the link (/index.php?page=contact) and the page reloads, the page will have that data in the content area of your index template.

I don't remember this code ever needed a database.
Can anyone help?

Source: https://php-dev.livejournal.com/83094.html

Date: 02/12/10 (PHP Development)    Keywords: database

I'm surprised to see the var_dumps aren't identical. Is there any reason in practice to worry about the difference between them? Also, in general, is code like following frowned upon? I'm building up a data structure through reading rows from a database -- an array of arrays.

array('C'=>'C')));

array(1) {
  ["B"]=>
  &array(1) {
    ["C"]=>
    string(1) "C"
  }
}
array(1) {
  ["B"]=>
  array(1) {
    ["C"]=>
    string(1) "C"
  }
}

Source: https://php-dev.livejournal.com/82911.html

Date: 08/16/09 (PHP Development)    Keywords: database, shopping

Does anyone have any experience of installing paypal express on a custom built shopping cart? i'm getting absolutely nowhere and and starting to lose the will to live :( Is there any kind sole willing to have a look at the code for me? maybe even correct it, test it, make it work? for a little bit of cash? None of the online tutorials i've found make any sense :/

I've got a business account set up and have the API details, and i have a sandbox account with API details. The express button is on the checkout page and takes me to paypal sandbox. but it doesn't seem to be taking the order details through with it. I also need the site to update the database to say payment has been received and the order should be shipped to the paypal address.

Anyone feeling helpful and kind? :) pretty please? I need this doing as sooon as possible.

[x-posted a little]

Source: https://php-dev.livejournal.com/82433.html

Date: 04/19/09 (PHP Development)    Keywords: php, mysql, database, sql

[solved, thanks to synergetic]

HiGuys,

Needing a bit of help with MySQL queries. Hopefully someone has the answer, or a pointer at least :)

Say I have a page displaying an item, www.domain.com/item.php?id=12 and at the bottom of that page i want to have a Previous link and a Next link which will link to the previous and next item in the database, how do i call the item numbers? I don't want to just do $id - 1 or +1 becausethe next item might be number 14 for example, not 13.

So before the links are displayed, i need some way of saying the id is 12, look at what the next number is in the id column and select that one. So it's not just a prev/next page link, but prev/next item in the DB link.

Hopefully my laymans terms aren't too confusing!

Any ideas? :)

many thanks,

Paul

Source: https://php-dev.livejournal.com/81861.html

Date: 03/10/09 (PHP Development)    Keywords: php, mysql, database, sql, web

[solved, thanks to thenetimp]

(x-posted to php)

Hey guys,

I'm coding an image gallery to use on my PHP site and need a bit of help with a couple of features I want to code into it. I was hoping someone here could either give me some pointers or send me to a website that will help with either explainations or code snippets :)

1. Firstly, thumbnails. I have created an admin panel where I upload the images and can set various things like the category, title etc, and all that is stored in a MySql database, and the file uploaded to a general directory. But i'd also like to create a thumbnail of the image as it uploads. I've found several scripts that make thumbnails from images already in a directory, but i'd like it to happen as I upload the image. Is that possible? Without having to use some all-in-one image gallery script heh. I'd also need it to resize the image proportionally so that images aren't just squashed into a 100x100 square shape.

2. Secondly, I'd like to "tag" images like with LJ entries, so that on the front end when a picture is being viewed, the list of tags is shown and can be clicked on to show other image thumbnails with the same tag. But i'm not really sure how to go about this... I was just going to have a table field called img_tags and store them all in that per image, but then is that efficient? searching for matches within a db field? any tips or suggestions?

3. oh and as an extra thought, how can i then take those tags and make a tag cloud maybe?

All and any help would be most appreciated! :)

paul
x

Source: https://php-dev.livejournal.com/81475.html

Date: 12/25/08 (PHP Development)    Keywords: html, database, google

I am trying to write an event calendar application. For no other reason than the learning experience, so please don't answer by "go use google calendars". You don't learn anything that way.

I have written the part that builds the display of the calendar. I found a class that built a display, but it had all the HTML in the class so I rewrote it to be more of what I wanted.

Now I want to create the database to store the events. I want to enter an event by date. I want to be able to add an event every 2 weeks on thursday, every 3 months on wednesday, but I am not sure how to approach putting that in the database. Looking for some database structure suggestions.

Source: https://php-dev.livejournal.com/80976.html

Date: 02/17/07 (PHP Development)    Keywords: php, mysql, browser, css, html, database, sql, web, linux, apache

Schedge, an Austin based company, is reinventing scheduling.

We are looking for an experienced Lead PHP developer.

Have you developed enterprise scale PHP applications?
Have you worked with technologies like AJAX and MVC?

Then this might be the position for you!

You'll be responsible for leading the development efforts of the core application. The position is contract-to-hire with the option of equity in the company.

Key Areas of Responsibility:
* PHP Application and database development
* Work with Designers and other Developers to build complex user interfaces and data interactions
* Write/Update functional specs

Required Experience:
* Enterprise scale PHP experience
* MVC (Model-view-controller) design experience
* Basic DOM Scripting experience
* Basic (X)HTML & CSS experience
* MySQL
* Multi-browser development
* Apache Webserver

Preferred additional experience:
* Experience with the CakePHP (or similar) PHP framework
* Flash or Action Scripting experience
* MySQL clustering
* Code development for Linux servers

You'll be a good fit if:
* You “get the Web”, and understand it’s full potential.
* Work efficiently and get it right, not just "good enough"
* Can set and execute priorities individually and in a group
* Effectively communicate to people of varying levels of technical expertise

Please note: This is a 100% telecommuting position but the ideal (but not required) candidate would be located in Austin, TX and available for weekly meetings.

If you feel you are a good fit for this position please send your resume and rate per hour to jobs@schedge.com

[cross posted] My apologies if you receive this post more then once.

Source: https://php-dev.livejournal.com/75751.html

Date: 07/13/08 (See my site)    Keywords: database, web, seo

                            Be Something!!

TalentZoo.com is THE website communications professionals and executives, job seekers, and media-savvy people frequent for:

• Information on the company's offline class recruitment services
• A kick-ass job board with the most coveted positions in the advertising, marketing, public relations, broadcasting, and publishing fields
• A resume database employers with Talent Zoo accounts can browse when looking to make their next hire
• Up-to-date industry news
• Industry resources, including articles, podcasts, blogs, and even a salary monitor for professionals to measure their worth
• Our Rookie Directory, where communications professionals with less than 2 years' experience can get their names in front of top employers looking for young talent
• We are currently seeking Bloggers who specialize in Marketing, Advertising, Public Relations!!  Take a look at our blogs:
• www.beneaththebrand.com; www.beyondmadisonavenue.com; www.flackme.com; www.12pointtype.com; www.digitalpivot.com; www.seoshootout.com

Interested?  See our website at: www.talentzoo.com

Source: https://see-my-site.livejournal.com/116084.html

Date: 12/23/06 (Web Hosts)    Keywords: database, google

Does anyone have any suggestions for a search engine script that I can use for my site? I'd like to allow users to search for things within my site [primarily videos], but the problem seems to hinge on the fact that I don't use databases to drive my site.

I wouldn't mind creating the search index myself, I just want something nice and clean to display results and all that. I looked at the option of adding a Google custom search engine to my site but I don't much like the branding and ads.

Any suggestions would be awesome!

Source: https://webhosts.livejournal.com/37707.html