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…
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.
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.
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.
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.)
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.