database interface

Hi Folks,

I’ve got the chance to do a revamp of an existing website. Its quite a big site 60+ pages and currently with a confusing layout, its also cms - created with Umbarco.

My main inquiry is that one aspect (currently) is an interface to a large(ish) existing database of records. Now this is were I’m out of my comfort zone more than normal. Is it relatively easy to create such an interface or not ?? I think it currently uses asp.net (?) There wouldn’t be any cms elements on this page.

My initial thinking (if I don’t pass on it) is a FW design integrated then into Mojomotor - or…

any thoughts appreciated,

S


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Do you know which database engine they are currently using? SQL Server, MySQL, PostgreSQL, etc.? That’s going to drive your decision pretty sharply. Unless, of course, all you need is a short-term way to export all that data into a format that you can control…

Walter

PS: I think Mojo will work on MySQL or PostgreSQL, but I’m not sure if there are adapters for other database engines.

On Feb 9, 2012, at 10:07 AM, seoras wrote:

My main inquiry is that one aspect (currently) is an interface to a large(ish) existing database of records. Now this is were I’m out of my comfort zone more than normal. Is it relatively easy to create such an interface or not ?? I think it currently uses asp.net (?) There wouldn’t be any cms elements on this page.


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Thanks Waltd

I’ll have to check that out and get back. It was created separately from the website so I can easily enquire.
The code behind the search page contains something called ‘arrDynaList’ - 2651 lines of it. If that indicates anything. I suspect it won’t be anything too esoteric.

cheers,

S


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

If you want, copy and paste about thirty lines of it (nowhere near any password attributes) onto Gist or Pastie and post a link here. Someone (maybe me) will recognize it by its style, I’m sure.

Walter

On Feb 9, 2012, at 1:11 PM, seoras wrote:

Thanks Waltd

I’ll have to check that out and get back. It was created separately from the website so I can easily enquire.
The code behind the search page contains something called ‘arrDynaList’ - 2651 lines of it. If that indicates anything. I suspect it won’t be anything too esoteric.

cheers,

S


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Ok,

git clone git://gist.github.com/1781937.git gist-1781937

I’m assuming I’ve done it right not having used this before.

s


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Ah I see:

s


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

This looks like something you would find in Dreamweaver – the MM prefixes to JavaScript functions is a dead giveaway.

I don’t see any database access here, you may need to look further in the code. See if any part of it has a delimiter like <?php or <% – those are popular template language block tags that allow you to mix server-side code within HTML for dynamic processing. Seeing one of those in the midst of a chunk of HTML would help narrow down the data access method being used.

To post Gist here (and have it come up all pretty and syntax-highlighted) simply copy the URL from your browser when you’ve finished uploading. Yours would look like this:

And paste it alone on a line like I just did. The link will be magically replaced with the code you posted at Gist. (If you’re looking at this on the Web, you’re probably wondering what I did – I simply pasted a URL https://gist.github.com/1781937 into a line by itself. The FreewayTalk server did the rest.)

Walter

On Feb 9, 2012, at 1:50 PM, seoras wrote:

Ok,

git clone git://gist.github.com/1781937.git gist-1781937

I’m assuming I’ve done it right not having used this before.

s


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

This looks like something you would find in Dreamweaver — the MM prefixes to JavaScript functions is a dead giveaway.

It could be that they had an interface issue also and used DW I suppose.

No ‘delimiter’ that I can see.

Don’t know if these indicate anything:

I’ll perhaps leave just now and see if I can get info on database type.

Thanks again,

S


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Anything with VBScript is going to be one flavor of ASP or another. It’s possible that these templates you are editing are completely free of code, and may be relying on external processing scripts to wire them up. That’s pretty cool if that’s the case. I haven’t used any flavor of ASP since 1997, and I’m not eager to return.

Walter

On Feb 9, 2012, at 3:04 PM, seoras wrote:


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

It’s possible that these templates you are editing are completely free of code, and may be relying on external processing scripts to wire them up.

I’m not editing any templates. Its a start from scratch website.

Looking less something I can handle and might have to pass on.

I’ll still try and get more info on database.

s


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options