Hi All, This function inserts a row into a SQL database and needs to return the identity number created: Function WriteDatabase(backupTypeID, numImages, folderSize, success, errorMessage, strLogFileName) On Error Resume Next err.clear Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject(...
Hello. I got this error and Im not sure how to work with it. Simple explanations would be much appreciated. Thanks. Error: There was an SQL error: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause - SELECT email, COUNT(*) AS records_found FROM (emails) WHERE email = 'Emai...
There is a report table for overdue DVD rentals. The store has multiple copies of the same DVD (they are all numbered to be identified). How can I normalize this data to meet 3NF requirements? ...
First post, please be kind. NOTE: I have reviewed entry #20856 (how to implement tagging) but feel this is different due to the fact that the tags method I'm considering is organization specific in my app. I’m hoping someone can confirm the direction I’m going or point out some other options. (background) We are building a web applica...
I've been doing some web development work in PHP recently which has led me to study up on the language in general. So far I have not needed to use it to interact with a database, but I know it provides a lot of convenient functions for doing so. Although I know basic SQL and have worked with basic manipulation of data in a database, I d...
I have three condition to compare. Which one is more faster between the following two? Please point me out. Thanks all! If var = 1 then Command for updating database ElseIf var = 2 then Command for updating database ElseIf var = 3 then Command for updating database EndIf and Select Case var Case 1 Command for up...
Hi, I have checked a few answers but was unable to find specific details on how we can create a SQL table using custom metadata (or Columns from a CSV file) which is uploaded by a user through a CSV file. A feature available with www.dabbledb.com, like creating online database for custom information. It will be a web based .NET applicati...
I am making some small "business intelligence" applications/tools that need to talk to other systems. Primarily accounting systems that believe that databases are an integration layer (or are too lazy to provide an api). What's the easiest way of getting specific data out of a third party database and into my Java objects? Notes: (I...
I want to create a table that will contain dynamic data, it can be in a form of a date, boolean or a text article for example: meta_key = "isActive" meta_valu = "1" or meta_key = "theDate" meta_value = "Sat Jul 23 02:16:57 2005" or meta_key = "description" meta_value = "this is a description and this text can go on and on so i nee...
Typically file servers are used to store images for a web application. For more security and control you'd go for storing images in database. But this proves to be complex and slow. Are there other mainstream options available other than db/file server, to store images securely with user permissions, etc. Edit: I'm deployed on amazon c...
I have the following tables: Financial: PK_FinancialID FK_SchoolID School: PK_SchoolID Class: PK_ClassID FK_SchoolID ClassName Both Class and Financial have Foreign Key relationships to School. I want to make a query that would show all classes that are related to Financial rows that meet certain criteria. Initially I think...
Q: Why do we have more than one database? A: Because they all suck. So which "feature" of your favorite database made you think (or even say) "WTF???" For example, Oracle doesn't support TIME as a native type. Instead, TIME is folded into DATE, so you must chop'n'dice in your queries. Or "optimizer hints" which Oracle is free to ignor...
I would like to develope a databased GUI application for free, which is cross-platform. I almost decided, that the UI should be GTK (logical, not pixel-based layout, GUI description not cluttering the code (glade xml))... What I am missing is a good framework, which connects database and GUI, so I am looking for building database gui ap...
I have a relational database with three tables. The first containts id's that relate to the second. The second contains id's that relate to the third. The third contains the results I am after. Is it possible with a single query to query an id in the first table which gives all results from the third table that relate to it? Sorry I am...
Its difficult to explain this situation but please see the example. I have coded a website where the page loads, I initialize a database class. I sent this class as a function parameter to any functions that needs to access database. I know this is bad approach but currently I have no clue how to do this any other way. Can you please ...
We have an asp.net application that allows users to upload files, the files are saved to temporary disk location and later attached to a record and saved in DB. My question pertains to security and/or virus issues. Are there any security holes in this approach? Can a virus cause harm if it is never executed (file is saved, then open...
I've got a VS2008 database project, and I created a post-deployment script under Scripts > Post-Deployment, but it appears to be a no-op (even when I put syntax errors into the file, everything succeeds). The rest of the database deployment succeeds though (and it does create my tables). Any clues? ...
I work as a freelance web dev, and up until now have been ftping my scripts / databases / static files to my web server manually, but I'm finding that is too error prone. So I'm looking for an app to automate uploading new and updated scripts / files / databases / etc. I know a lot of independent devs use WinSCP or Unison, but I don't th...
I've been tasked with mirroring a site onto a new server. The old site has a few Perl scripts that, as far as I can see internally (i know nothing about Perl, though I have a pretty good understanding of coding generally, and specifically PHP/js/etc) aren't reliant on the old server. That said, when I try to run this script, which looks ...
It didn't always do this, but ever since I split my database and made the front-end an ACCDE file, any time I try to compact and repair either file, a new file called "Database 1" is generated and my original file size doesn't change. Is this normal? My ACCDB is roughly 20MB, and my ACCDE is just over 1M after being used the first time...