Date: 03/27/08     Keywords: html, database, asp, sql, web

I have taken over a website from another developer and am learning ASP.net and VB.net as I go. He had report functionality that did a query of the database, threw it in a gridview and then added a few lines of code that let it export from the gridview directly in Excel. The customer had me completely redesign the reports so that they required multiple queries of the database to get all the data and display it properly. I've put it into a basic HTML table. My questions are these:

1) Would it have been possible to manually put the data in a gridview, or is a gridview by definition bound to one sql query (I believe the answer is no, its not possible, but would just like to verify.
2) Is there any way to export info from an HTML table into an Excel spreadsheet? Or is it more a case of having to open a new Excel document and add in each field like I had to for the HTML table?

Any and all thoughts and suggestions are welcomed. Thanks in advance!

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

Date: 03/25/08     Keywords: no keywords

I'm working on a directory of farmers markets in my city. I'm doing a very basic job for now, just enough to present to a group of people with funding later this week, then expanding later. As I've been researching, I've found there are many more markets in my city that I originally thought and I'd love to add a ZIP code search feature coupled with a day of the week search since most neighborhood markets are just one day.

I'm not much of a code person and I searched for examples without much success. Has anyone used a code generator for something like this, or can someone point me in the right direction? I'm a little stumped.

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

Date: 03/24/08     Keywords: web, google

Does anyone know why Google will display a mini site map of a site with its search results? Is this an indication of a well organized search engine optimized web site, or it this something the web site has paid for?

To see what I am talking about, look up 'Ubuntu' on Google
http://www.google.com/search?q=ubuntu&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

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

Date: 03/22/08     Keywords: html, web

Hi everyone.
I'm coding a webpage for school using notepad and XHTML.
I am trying to create a table, and can't for the life of me figure out how to do it.
I understand the tags, but I don't know what the acceptible amount of pixels is.
Any help would be much appreciated.
Tif

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

Date: 03/19/08     Keywords: java

so there are a bunch of spans, each with display:none, and opacity:0 as properties. I'm trying to write a series of functions that will toggle the span to display:block, and then gradually fade the span into view, wait a few seconds, and then fade it back out to opacity:0, and then hide it again before moving onto the next span.

The Javascript

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

Date: 03/19/08     Keywords: cms

Hope this is ok to post here.

I'm working on a site that is based around the Xoops CMS... and I've never used that particular CMS before and would rather just write the site from scratch but the contract I'm working on already has it started with this.

So does anyone have any familiarity with Xoops? Suggestions on where to look for tips on how to handle the Modules for it? Documentation (maybe I'm missing it but it doesn't seem to be kept up much at all on the pages for most of the Modules, and most aren't even rated and are dated 2005....).

So any suggestions?

Hopefully?

Thanks.

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

Date: 03/17/08     Keywords: php, apache

For some reason the default version of PDFlib (5.0.3) distributed with the latest version of PHP (5.2.5) crashes on the default example of building a PDF, taking down Apache along with it with this in the error log:

PDFlib exception (fatal): [1202] PDF_set_parameter: Unknown key 'objorient'
Error in my_thread_global_end(): 253 threads didn't exit
[Mon Mar 17 12:54:45 2008] [notice] Parent: child process exited with status 99 -- Restarting.

Fortunately there is an easy fix for it. Simply download the latest version of PDFlib from http://www.pdflib.com and install/register its DLL with PHP.

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

Date: 03/05/08     Keywords: web

I'm a web design student and I recently got the student version of Dreameweaver CS3. It came with two disks, one with the actual program, and the other would be the video training. Halfway through installing it, it stops, ejects the disc and tells me to 'Please insert Adobe ExtendScript Toolkit 2 to continue installation.'...but I never got one of those discs. I tired called customer support but as soon as I got ahold of someone, our power went out and now they're closed for the night, so I have no idea what to do.

I hope this is the right place to post this, I'm just at a loss as to what I should do.

Thanks in advance! And if this isn't the right place to post this, can you please point me in the right direction?

-Rachel.

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

Date: 03/05/08     Keywords: web

Hello all,
I've just landed myself a client for a fairly sizable project. My websites are usually small-scale sites designed for family and trusted acquaintances, and until now I've never had a need to write up a contract for a client to sign.

I'm assuming nobody here is a lawyer, and if I have to pay one I'd rather invest a small amount of money to approve an existing document than spend more to write a new one. Ideally, I'd like to spend no money at all, as it will likely eat away any profit I glean from this site. I just need a simple, legally binding contract that states the client will pay the amount we agreed upon once I deliver a final product. Are there any generic contracts available online, or could someone provide an example of what to include so I can write my own? Thank you!

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

Date: 02/29/08     Keywords: php, asp, web

I am moving this small web site over from ASP to PHP. It includes a few Flash files, many of which are not working on the new site. How can I find out what is not working if I can't open the SWF for editing? im hating flash right now...

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

Date: 02/27/08     Keywords: no keywords

My pages are printing perfectly fine in Firefox, but IE6 just shows a blank page. Does anyone know what could be the problem here?

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

Date: 02/26/08     Keywords: sql

Suppose I have a table filled with events and a date for each event in 'datetime' format. I would like to construct an SQL query that returns a list of events within a specified 49 day block. How would I do this?

SELECT *
FROM events
WHERE date
BETWEEN 2008-03-01 10:00:51
AND 2008-02-29 10:00:51

Doesn't work, and I don't know where to go from here.

Ideally I would like something with math involved like
SELECT *
FROM events
WHERE date
BETWEEN x
AND (x+49)


Do I use the AS keyword to do a TO_DAYS conversion? i haven't a clue.

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

Date: 02/25/08     Keywords: no keywords

Question to all those who process online payments. What resellers would you suggest to get an authorize.net account + payment gateway?


I was looking at payquake.com but found out that they only let you process payments from one domain for each account. I work for a school that owns multiple that we would process payments from.

Any suggestions?

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

Date: 02/24/08     Keywords: php, css, html

I own a fanlisting that's returning troubles in IE7, which I don't have access to at all. I figured I might try and sort out the problem by taking the page in question to a W3C validator, and I got the following error, repeated 6 times for a navigation menu I have on my page:

document type does not allow element "DIV" here; missing one of "APPLET", "OBJECT", "MAP", "IFRAME", "BUTTON" start-tag.

<div class="navitem"><span><a href="about.php">About</a></span> </div>

The mentioned element is not allowed to appear in the context in which you've placed it; the other mentioned elements are the only ones that are both allowed there and can contain the element mentioned. This might mean that you need a containing element, or possibly that you've forgotten to close a previous element.

One possible cause for this message is that you have attempted to put a block-level element (such as "<p>" or "<table>") inside an inline element (such as "<a>", "<span>", or "<font>").


I don't understand what I'm doing wrong. I vaguely understand the concept of block vs. inline elements, but I can't remember what goes in what (or more precisely, what can and what shouldn't go into what).

I"m not even sure if this is the reason why my page doesn't display properly in IE7, but I'm hoping it's a step in the right direction.

Help?

ETA: I tried for HTML 4.01 Transitional, and it passed after the latest (online) revision, but now my DIV links in the navigation area aren't working at all. I don't understand why they're not; the CSS defined a single, large background image and the proper display location for the layer with the links... and it worked before everything was validated, so now I'm even more confused.

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

Date: 02/22/08     Keywords: no keywords

THE FUTURE OF SOCIAL NETWORKING

0. Introduction.

Almost three years ago, I started the Appleseed Project as a way to start experimenting with the idea of distributed social networking. Armed with enough hubris and naivete to think I could build it alone, I coded and coded until I got to the point I am now: With a project that stands at around 75% complete, it functions as a sort of proof-of-concept for distributed social networking in general. I've learned a lot, however, about the technological hurdles and impact that a truly open and distributed social networking platform could provide.

I'm writing this as a way to present my ideas and what I've learned in the hopes that an open and distributed solution becomes the direction that social networking takes. Although I would be happiest to see Appleseed succeed, I'd be excited to see any open and distributed social networking solution be adopted and replace the walled gardens that currently dot the internet landscape.

Read More

(note: please digg this up if you have a digg.com account!)

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

Date: 02/17/08     Keywords: web, ebay

It was recently suggested to me that I try "auctioning off" my web design service on ebay, in an effort to "lure in" new clients and get some extra money. But I've never done anything like this before, and my friend, who has years more experience than I do (and thus would probably know more about this option), can't be reached.

So I'm asking here. Is this generally a good idea? If you've done it yourself, how does it work? Any big problems? If I'm very upfront about my terms and what I can do, does this help? If this is indeed a bad idea, what is a good alternative?

x-posted to webdesign

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

Date: 02/17/08     Keywords: php

Recently I've switched form IIS to XAMPP - for php configuration reasons.

I used to be able to access my work PC from home by doing:

pcname.company.com or ipa.ddr.ess.1

I've setup a local.testing.com and it works at work, but at home, I get the default page.

I've got the http.conf and virtualhosts setup - any ideas?

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

Date: 02/16/08     Keywords: java, web

Hey, I have 2 areas of questions.

1.
Having decided to learn Java I was wondering if I could get some advice from the Java programmers out there, especially those doing it professionally. I'm currently using this book to learn Java, but it focuses on Java2SE and seems to be somewhat lacking on the tutorials and projects. What kind of projects can I work on that would be useful in a J2EE environment and that I could show to a potential employer? Also, what are the differences I should be aware of when working with J2SE as opposed to J2EE. I have both the J2SE JDK and J2EE SDK installed on my development machine.

2.
My local comm college offers an associates degree concentrating in Internet and Web Development that they say will get me ready for the Certified Internet Web Professional exams. I've never heard of them. Is it something worth looking into?

As always, advice and answers in either area is greatly appreciated. Thanks!

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

Date: 02/16/08     Keywords: templates, html, google

My co-worker is looking for a good mass e-mailer. What do you recommend for bulk/mass mailing lists?

It should have automatic BBC, bounced e-mail management, WYSIWYG html templates with the option of sending in plain text, can handle apostrophes, quotation marks, and all other punctuations.

I Googled and saw all those pricey bulk e-mailers. I am looking at those $99-$149 "Professional Bulk E-mailers" but not sure if they are worth it...

Thanks,

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

Date: 02/14/08     Keywords: no keywords

I'm looking for verification:

It *is* possible to have multiple filters on an element (the proprietary IE coding).

What I'm curious about, is it possible to apply both alphaImageLoader AND opacity to the same element?

So far, I've been unable to make that happen, unless I do something along the lines of:

[Error: Irreparable invalid markup ('') in entry. Owner must fix manually. Raw contents below.]

I'm looking for verification:

It *is* possible to have multiple filters on an element (the proprietary IE coding).

What I'm curious about, is it possible to apply both alphaImageLoader AND opacity to the same element?

So far, I've been unable to make that happen, unless I do something along the lines of:

As that's a pain in the ass, I was hoping I could drop the containing div and do both on the image directly.

First person to help gets a slice of cake.

I really wish IE6 didn't need to be supported.

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