i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
9  1857 
<ja***********@gmail.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...
>i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
The best way is, you don't.
That is, if you construct an identifier with meaningful sub-parts, you have
to extract those to do anything with them. It is better to store the
information separately, and concatenate it (if you feel compelled to do so)
in VBA code or expressions when you present / show the data to someone. That
way, you can search on the Fields, instead of having to extract them to
search or having to store redundant information.
If you do store them separately, there is a very convenient feature
(AutoNumber) you can use for internal things... joins, foreign keys, etc..
but it's not really for display to a user.
Larry Linson
Microsoft Access MVP ja***********@gmail.com wrote:
i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In VBA it'd be something like this:
strPrefix = Format(Year(Date()),"yy") & "TTAG" & _
IIf(County='x' Or County='y' Or County='z',12,00)
strKey = strPrefix & Format(Nz(DMax("KeyValue","Table_name", _
"KeyValue LIKE '" & strPrefix & "*'"),0),"00")
You didn't say what to put when the county is not one of X, Y, or Z, so
I put "00" in the IIf() function's False option.
The DMax() function looks for a key that starts with the first part of
the key you're creating, the strPrefix. Translated, it'd look something
like this:
DMax("KeyValue","Table_Name","KeyValue Like '06TTAG12*'")
which should find the next number to add to the end of the key (be sure
to change the column and table names to your column & table names).
The Nz() function around the DMax() function will return zero when there
isn't any Max for that prefix.
The Format() function around the Nz() function will change a single
digit number to a double-digit number.
BTW, I'm sure you realize you can only have 99 keys w/ that prefix. Is
that enough?
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR7SHYechKqOuFEgEQJCpACg7yepO8EDovfKDwPShQ3nnj OtJPcAoMhd
VTXdMM6T6CTPN4mSGdWQ+NyC
=OtBW
-----END PGP SIGNATURE-----
Thank you very much for the information. on the counties bit, there
are 52 counties grouped into 25 sections, so i would need to go 1
through 25. can i do that with this code?
MGFoster wrote:
ja***********@gmail.com wrote:
i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In VBA it'd be something like this:
strPrefix = Format(Year(Date()),"yy") & "TTAG" & _
IIf(County='x' Or County='y' Or County='z',12,00)
strKey = strPrefix & Format(Nz(DMax("KeyValue","Table_name", _
"KeyValue LIKE '" & strPrefix & "*'"),0),"00")
You didn't say what to put when the county is not one of X, Y, or Z, so
I put "00" in the IIf() function's False option.
The DMax() function looks for a key that starts with the first part of
the key you're creating, the strPrefix. Translated, it'd look something
like this:
DMax("KeyValue","Table_Name","KeyValue Like '06TTAG12*'")
which should find the next number to add to the end of the key (be sure
to change the column and table names to your column & table names).
The Nz() function around the DMax() function will return zero when there
isn't any Max for that prefix.
The Format() function around the Nz() function will change a single
digit number to a double-digit number.
BTW, I'm sure you realize you can only have 99 keys w/ that prefix. Is
that enough?
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR7SHYechKqOuFEgEQJCpACg7yepO8EDovfKDwPShQ3nnj OtJPcAoMhd
VTXdMM6T6CTPN4mSGdWQ+NyC
=OtBW
-----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You could, but it wud be very messy. It wud be better to break the
count part into a Case statement. E.g.:
Select Case strCounty
Case "Alameda", "Contra Costa" "Diablo"
strCounty = "01"
Case "Santa Clara", "San Jose", San Clemente"
strCounty = "02"
Case ... etc. ...
End Select
Just substitute your county names in the Case lines and the appropriate
number in the "strCounty =" line. Then replace the IIf() function that
decided the county number w/ the strCounty variable.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR9q9YechKqOuFEgEQJqygCghaSqjFH3eDvDfz2mf0Ff3N Ucf2kAoKCW
1oLwiXptLVt1khgcD5/qVuyd
=7KaL
-----END PGP SIGNATURE----- eu********@gmail.com wrote:
Thank you very much for the information. on the counties bit, there
are 52 counties grouped into 25 sections, so i would need to go 1
through 25. can i do that with this code?
MGFoster wrote:
>ja***********@gmail.com wrote:
>>i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In VBA it'd be something like this:
strPrefix = Format(Year(Date()),"yy") & "TTAG" & _
IIf(County='x' Or County='y' Or County='z',12,00)
strKey = strPrefix & Format(Nz(DMax("KeyValue","Table_name", _
"KeyValue LIKE '" & strPrefix & "*'"),0),"00")
You didn't say what to put when the county is not one of X, Y, or Z, so
I put "00" in the IIf() function's False option.
The DMax() function looks for a key that starts with the first part of
the key you're creating, the strPrefix. Translated, it'd look something
like this:
DMax("KeyValue","Table_Name","KeyValue Like '06TTAG12*'")
which should find the next number to add to the end of the key (be sure
to change the column and table names to your column & table names).
The Nz() function around the DMax() function will return zero when there
isn't any Max for that prefix.
The Format() function around the Nz() function will change a single
digit number to a double-digit number.
BTW, I'm sure you realize you can only have 99 keys w/ that prefix. Is
that enough?
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR7SHYechKqOuFEgEQJCpACg7yepO8EDovfKDwPShQ3nnj OtJPcAoMhd
VTXdMM6T6CTPN4mSGdWQ+NyC
=OtBW
-----END PGP SIGNATURE-----
ja***********@gmail.com wrote:
i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
Atomicity: Each attribute must contain a single value, not a set of
values.
Think about this.
will this code allow me to generate the number when they his submit and
store it in the table with the data they just submitted
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You could, but it wud be very messy. It wud be better to break the
count part into a Case statement. E.g.:
Select Case strCounty
Case "Alameda", "Contra Costa" "Diablo"
strCounty = "01"
Case "Santa Clara", "San Jose", San Clemente"
strCounty = "02"
Case ... etc. ...
End Select
Just substitute your county names in the Case lines and the appropriate
number in the "strCounty =" line. Then replace the IIf() function that
decided the county number w/ the strCounty variable.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR9q9YechKqOuFEgEQJqygCghaSqjFH3eDvDfz2mf0Ff3N Ucf2kAoKCW
1oLwiXptLVt1khgcD5/qVuyd
=7KaL
-----END PGP SIGNATURE-----
eu********@gmail.com wrote:
Thank you very much for the information. on the counties bit, there
are 52 counties grouped into 25 sections, so i would need to go 1
through 25. can i do that with this code?
MGFoster wrote:
ja***********@gmail.com wrote:
i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In VBA it'd be something like this:
strPrefix = Format(Year(Date()),"yy") & "TTAG" & _
IIf(County='x' Or County='y' Or County='z',12,00)
strKey = strPrefix & Format(Nz(DMax("KeyValue","Table_name", _
"KeyValue LIKE '" & strPrefix & "*'"),0),"00")
You didn't say what to put when the county is not one of X, Y, or Z, so
I put "00" in the IIf() function's False option.
The DMax() function looks for a key that starts with the first part of
the key you're creating, the strPrefix. Translated, it'd look something
like this:
DMax("KeyValue","Table_Name","KeyValue Like '06TTAG12*'")
which should find the next number to add to the end of the key (be sure
to change the column and table names to your column & table names).
The Nz() function around the DMax() function will return zero when there
isn't any Max for that prefix.
The Format() function around the Nz() function will change a single
digit number to a double-digit number.
BTW, I'm sure you realize you can only have 99 keys w/ that prefix. Is
that enough?
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR7SHYechKqOuFEgEQJCpACg7yepO8EDovfKDwPShQ3nnj OtJPcAoMhd
VTXdMM6T6CTPN4mSGdWQ+NyC
=OtBW
-----END PGP SIGNATURE-----
eu********@gmail.com wrote:
will this code allow me to generate the number when they his submit and
store it in the table with the data they just submitted
The eldest Oyster looked at him,
But never a word he said:
The eldest Oyster winked his eye,
And shook his heavy head--
Meaning to say he did not choose
To leave the oyster-bed.
But four young Oysters hurried up,
All eager for the treat:
Their coats were brushed, their faces washed,
Their shoes were clean and neat--
And this was odd, because, you know,
They hadn't any feet.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I don't know; it depends on what/how you're doing (it).
If you have a bound form w/ separate controls that hold each part of the
key you can combine the different parts into one "field" when the data
is saved, by using the Form's BeforeUpdate event. Just concatenate the
values from each relevant control into the key string; then save the key
string into a column. E.g.:
Me.KeyColumn = <a function to get the data into one string>
Just use the VBA examples I gave, as the body of the function.
Have you been reading the posts by Lyle Fairfield and Larry Linson? It
is a good idea to make sure you are following the Normal Form rules.
You can still have the concatenated key, if you wish, or you can use the
key's source columns (fields) as part of a Primary Key (PK) (PKs can be
composed of more than one column).
Try reading a good book on database design. I usually recommend
_Database Design for Mere Mortals_, by Hernandez. There are discussions
about PKs on many database news groups. Use Google to find more
citings.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRSBz3IechKqOuFEgEQJwmwCg1jCbjTdHbW676RSH1XN/c3MBWRgAoOuU
VAud7v77+qseNCllWSwe3fPV
=1Brq
-----END PGP SIGNATURE----- eu********@gmail.com wrote:
will this code allow me to generate the number when they his submit and
store it in the table with the data they just submitted
MGFoster wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You could, but it wud be very messy. It wud be better to break the
count part into a Case statement. E.g.:
Select Case strCounty
Case "Alameda", "Contra Costa" "Diablo"
strCounty = "01"
Case "Santa Clara", "San Jose", San Clemente"
strCounty = "02"
Case ... etc. ...
End Select
Just substitute your county names in the Case lines and the appropriate
number in the "strCounty =" line. Then replace the IIf() function that
decided the county number w/ the strCounty variable.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR9q9YechKqOuFEgEQJqygCghaSqjFH3eDvDfz2mf0Ff3N Ucf2kAoKCW
1oLwiXptLVt1khgcD5/qVuyd
=7KaL
-----END PGP SIGNATURE-----
eu********@gmail.com wrote:
>>Thank you very much for the information. on the counties bit, there
are 52 counties grouped into 25 sections, so i would need to go 1
through 25. can i do that with this code?
MGFoster wrote:
ja***********@gmail.com wrote:
i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In VBA it'd be something like this:
strPrefix = Format(Year(Date()),"yy") & "TTAG" & _
IIf(County='x' Or County='y' Or County='z',12,00)
strKey = strPrefix & Format(Nz(DMax("KeyValue","Table_name", _
"KeyValue LIKE '" & strPrefix & "*'"),0),"00")
You didn't say what to put when the county is not one of X, Y, or Z, so
I put "00" in the IIf() function's False option.
The DMax() function looks for a key that starts with the first part of
the key you're creating, the strPrefix. Translated, it'd look something
like this:
DMax("KeyValue","Table_Name","KeyValue Like '06TTAG12*'")
which should find the next number to add to the end of the key (be sure
to change the column and table names to your column & table names).
The Nz() function around the DMax() function will return zero when there
isn't any Max for that prefix.
The Format() function around the Nz() function will change a single
digit number to a double-digit number.
BTW, I'm sure you realize you can only have 99 keys w/ that prefix. Is
that enough?
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR7SHYechKqOuFEgEQJCpACg7yepO8EDovfKDwPShQ3nnj OtJPcAoMhd
VTXdMM6T6CTPN4mSGdWQ+NyC
=OtBW
-----END PGP SIGNATURE-----
This has all been really helpful. I really appreciate it.
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I don't know; it depends on what/how you're doing (it).
If you have a bound form w/ separate controls that hold each part of the
key you can combine the different parts into one "field" when the data
is saved, by using the Form's BeforeUpdate event. Just concatenate the
values from each relevant control into the key string; then save the key
string into a column. E.g.:
Me.KeyColumn = <a function to get the data into one string>
Just use the VBA examples I gave, as the body of the function.
Have you been reading the posts by Lyle Fairfield and Larry Linson? It
is a good idea to make sure you are following the Normal Form rules.
You can still have the concatenated key, if you wish, or you can use the
key's source columns (fields) as part of a Primary Key (PK) (PKs can be
composed of more than one column).
Try reading a good book on database design. I usually recommend
_Database Design for Mere Mortals_, by Hernandez. There are discussions
about PKs on many database news groups. Use Google to find more
citings.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRSBz3IechKqOuFEgEQJwmwCg1jCbjTdHbW676RSH1XN/c3MBWRgAoOuU
VAud7v77+qseNCllWSwe3fPV
=1Brq
-----END PGP SIGNATURE-----
eu********@gmail.com wrote:
will this code allow me to generate the number when they his submit and
store it in the table with the data they just submitted
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You could, but it wud be very messy. It wud be better to break the
count part into a Case statement. E.g.:
Select Case strCounty
Case "Alameda", "Contra Costa" "Diablo"
strCounty = "01"
Case "Santa Clara", "San Jose", San Clemente"
strCounty = "02"
Case ... etc. ...
End Select
Just substitute your county names in the Case lines and the appropriate
number in the "strCounty =" line. Then replace the IIf() function that
decided the county number w/ the strCounty variable.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR9q9YechKqOuFEgEQJqygCghaSqjFH3eDvDfz2mf0Ff3N Ucf2kAoKCW
1oLwiXptLVt1khgcD5/qVuyd
=7KaL
-----END PGP SIGNATURE-----
eu********@gmail.com wrote:
Thank you very much for the information. on the counties bit, there
are 52 counties grouped into 25 sections, so i would need to go 1
through 25. can i do that with this code?
MGFoster wrote:
ja***********@gmail.com wrote:
i have to build a table within access that receives it's information
from an ASP web page and generates the primary key, with numbers and
letters, from the data submitted. a numer would be like this
06TTAG1202, but a little more complicated . the 06 would be from the
current year at time of submission, the TTAG would remain constant, the
12 would come from the information in the county feild (counties x,y,
and z would receive the designation 12) and the 02 would mean that this
is the second record with a unique number matching all of the previous
portions. how do you make access generate numbers like this?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In VBA it'd be something like this:
strPrefix = Format(Year(Date()),"yy") & "TTAG" & _
IIf(County='x' Or County='y' Or County='z',12,00)
strKey = strPrefix & Format(Nz(DMax("KeyValue","Table_name", _
"KeyValue LIKE '" & strPrefix & "*'"),0),"00")
You didn't say what to put when the county is not one of X, Y, or Z, so
I put "00" in the IIf() function's False option.
The DMax() function looks for a key that starts with the first part of
the key you're creating, the strPrefix. Translated, it'd look something
like this:
DMax("KeyValue","Table_Name","KeyValue Like '06TTAG12*'")
which should find the next number to add to the end of the key (be sure
to change the column and table names to your column & table names).
The Nz() function around the DMax() function will return zero when there
isn't any Max for that prefix.
The Format() function around the Nz() function will change a single
digit number to a double-digit number.
BTW, I'm sure you realize you can only have 99 keys w/ that prefix. Is
that enough?
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRR7SHYechKqOuFEgEQJCpACg7yepO8EDovfKDwPShQ3nnj OtJPcAoMhd
VTXdMM6T6CTPN4mSGdWQ+NyC
=OtBW
-----END PGP SIGNATURE-----
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Tony Clarke |
last post by:
Hi,
I'm trying to write a system thats used for about 50 clients that uses html
forms and php to log details. The problem is that when a client loads the
form page it's given a value which is...
|
by: David Berry |
last post by:
Hi All. I'm trying to write an ASP page that shows me the UNIQUE account number for a customer (so I can pass it to another page) based on a search criteria. For example, I want to do a select...
|
by: August1 |
last post by:
A handful of articles have been posted requesting information on how
to use these functions in addition to the time() function as the seed
to generate unique groups (sets) of numbers - each group...
|
by: D |
last post by:
My first attempt at this and I'm searching formulas like so
RIGHT(TEXT(A15,'yy'),1)*1000+A15-CONCATENATE(1,'-','jan','-',TEXT(A15,'yy'))+1
I want to extract the row / col coordinates (A15 in...
|
by: Chris |
last post by:
Before I started to create table, etc to track unique form field record
number assigments I thought I'd check to see if there is now a better way to
do this in .NET.
I have a parent form (table)...
|
by: D. Dante Lorenso |
last post by:
I'm trying to build a table that will store a history of records
by enumerating the records. I want the newest record to always
be number ZERO, so I created a trigger on my table to handle the...
|
by: A. Farber |
last post by:
Hello,
I'm programming a web game on OpenBSD, but am
also trying to keep in runnable on Linux and Cygwin.
I have a list of tables at which a player/kibitzer can
sit down or create a new empty...
|
by: shira |
last post by:
Hi,
Looking to see if someone might have an explanation for this behavior.
Is it a bug? Corruption?
I have been able to reproduce the problem with only 2 rows and 1
field. Here is the table:...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
