It is not a good idea to use the Source argument of the Open method to perform an action query that does not return records because there is no easy way to determine whether the call succeeded. The Recordset returned by such a query will be closed. To perform a query that does not return records, such as a SQL INSERT statement, call the Execute method of a Command object or the Execute method of a Connection object instead.
Now in the table is an autoincrement ID which I need for use in a linked table.
Does the pCmd->Execute() return a recordset and if so what's in it?
Or is there another way to get the data of the just added record?
I need help to know the following:
1) whether the table pets, table users and table orders below is correct
Create table pets (
petId INTEGER IDENTITY PRIMARY KEY,
NAME VARCHAR(30) NOT NULL,
PHOTOURL VARCHAR(30) NOT NULL,
TAGS VARACHR(20) NOT NULL,
PRIMARY KEY (petId),
FOREIGN KEY (userId) REFERENCES Users(userId)
CREATE TABLE Orders (
OrderID int PRIIMARY KEY,
OrderNumber int NOT NULL,
quantity int NOT NULL,
shipDate DATE NOT NULL,
STATUS VARCHAR(30) NOT NULL, // can we use Enum here ?
PRIMARY KEY (OrderID),
FOREIGN KEY (petId) REFERENCES Pets(petId)
Not sure to include User based on the Swagger document
CREATE TABLE Users(
UserID int PRIMARY KEY,
UserName VARCHAR(30) NOT NULL,
FirstName VARCHAR(30) NOT NULL,
LastName VARCHAR(30) NOT NULL,
EMAIL VARCHAR(30) NOT NULL,
PASSWORD VARCHAR(30) NOT NULL,
PHONE VARCHAR(30) NOT NULL,
UserStatus VARCHAR(30) NOT NULL,
2) whether store entity is needed ?
Please help me on above as I am not good with DB and have problem in understanding swagger documentation.
3) If I were to use JPA data in Spring, do I use Custom query for querying the status ?
I need to build a windows app for documents archiving based on SQL server. I'm not sure if it better to store the files inside the database or as regular files. There will be thousands of files, and each file can reach upto 10MB so the total size could be around couple of TB's.
It's usually preferable to store the files in the file system, and store the paths in the database. But you might want to consider using file tables or filestream access instead, if they're available on your server.
I HAVE TO MANAGE INVENTORY
1)PARENTS (1 PK)
2)CHILD (10 PK)
CHILD NEVER SHOW MORE THEN 9 TO 0
IF I UPDATE INVENTORY FORM PARENTS OR CHILD UPDATE AUTOMATICALLY IN A PARENTS
ID I ADD INVENTORY ON A CHILD 15 WE CAN GET RESULT LIKE THAT
THEY SHOW LIKE THAT
1. Don't type in all CAPS. It makes it look like you are yelling and is considered rude.
2. You have not asked a question.
3. All you have to do is write code to do this. When you update inventory then update the other fields too.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
One way to approach this is to have a create a baseline set of scripts which created all of your DB objects: Tables, Indexes, Triggers, Stored Proc, etc. Check those scripts into a version control system () along with your source code. (Make a folder called "SQL" or something)
As you revise your application, create ALTER scripts for the DB objects (Tables, Indexes, Triggers, Stored Proc, etc) which will take the database from State A to State B.
Use some type of naming convention which will show the progress from one version to another.
When you get to a major release of the software, such as v2.0.0, then Re-Create the CREATE DB object scripts which will include all of your ALTER scripts; this way you don't have to keep rolling up schema changes.
ALSO: Take into consideration that you may need Data Manipulation scripts to "seed" some of your tables with basic data. Handle those scripts with something like ALTER_Data_1.0.0_to_1.0.1
Just giving you some ideas, not completely thought out, but I remember doing something like on previous projects.
BTW: I use Subversion / SVN / Tortoise as version control for myself.
In this case Shipment_date is an actual DATE data type whereas the Sales_Order_Ship_Date is a VARCHAR(42) data type.
It works really well on the condition that the original string data represents a date of at least 2010-01-01. The string data is formatted as follows: YYYYMMDD so 2010-01-01 is 20100101 in the string version. It converts perfectly to 2010-01-01 and the same is true for later dates. Any string representing a date before 2010-01-01 though comes out as 0000-00-00.
Does anyone have any ideas as to what is causing this?
Then I corrected my colleague's original code as you described and sure enough it now works exactly as expected.
Why it ended up producing 0000-00-00 is still a mystery but once the dissection of the string is done properly it now accepts any date
I'm trying to add both text and a picture filename to an Access database. The actual .jpg file is stored separately in another folder. I want to use a File control in classic ASP to do this. If I create a page for the text fields and a separate page for the File control, everything works fine but the users are confused by having to go to two pages.
Ideally, they would use the Browse button of the File control to select their picture then the picture's filename would be passed down to the "ImageLink" field in the database Insert SQL command. Any ideas?
Here's my two sections of code:
<formaction="marketplaceentryadd.asp"method="post"><!-- Begin data entry table --><tableborder=1 cellpadding=3 cellspacing=1><tr><tdsize="110"><fontcolor="#FFFFFF">Country:<br/></font></td><td><inputname="txtCountry"type="text"size="50"maxlength="50"/></td></tr><tr><td><fontcolor="#FFFFFF">Description:<br/>(255 char. max)
Numbers only with optional decimal point
</font></td><td><inputname="txtPrice"type="text"size="50"maxlength="50"/></td></tr><tr><td><fontcolor="#FFFFFF">Your Name:<br/></font></td><td><inputname="txtSeller"type="text"size="50"maxlength="50"/></td></tr><tr><td><fontcolor="#FFFFFF">Contact Info:<br/>
(255 char. max)
(255 char. max)
</font></td><td><inputname="txtMoreInfo"type="text"size="50"maxlength="255"/></td></tr><tr><td><fontcolor="#FFFFFF">Picture Filename:<br/>Do not include spaces in the filename<br/>Be sure to include extension (.jpg)</font></td><td><inputname="txtImagelink"type="text"size="50"maxlength="50"/></td></tr><tr><td><inputtype="submit"value="Add Item"/></tr></table></form>
Second page code:
Please select picture to be saved for this item:<br/><br/><FORMmethod="post"encType="multipart/form-data"action="ToFileSystem.asp"><INPUTtype="File"name="File1"><br/><br/><INPUTtype="Submit"value="Upload Picture"></FORM>
Last Visit: 31-Dec-99 18:00 Last Update: 23-Jun-21 13:37